Exam 5: Maintaining a Database

Modified Multiple Choice The wildcard symbols for use with filters are ____.

To change the list of choices in a single or multivalued lookup field, open the table in Design view, select the field to be modified, and tap or click the ____ tab in the Field Properties pane.

To open a form in Form view from the Navigation Pane, press and hold or right-click the form and tap or click Form View on the shortcut menu.

To use Filter By Selection to find all customers located in Greer, tap or click the City field for any record where the city is Greer and then tap or click the ____ button on the HOME tab.

To find records in one table that have no matching records in another table, use the _____ Query Wizard.

When you specify referential integrity, you need to decide how to handle the update of the primary key. What decisions do you need to make?

You can search for a record in Form view but not in Datasheet view.

As an alternate to using the Find button, you can press ____ to search for a specific record and display the Search and Replace dialog box shown in the accompanying figure.

If you add a field to a table and later realize the field is in the wrong location, you can move the field. To move the field, tap or click the ____________________ for the field and then drag the field to the new location.

To use a common filter to find only those customers whose city begins with G, tap or click the arrow to the right of the field name and point to the ____ command to display the custom text filters.

The relationship in the accompanying figure was created by tapping or clicking the ____________________ check box in the Edit Relationships dialog box.

If a SECURITY WARNING appears when you open a database, tap or click the ____ option button.

When you use a split form, you only can add records using the simple form.

You can use the Find button on the HOME tab to search for records in datasheets, forms, query results, and reports.

To add a record using the form shown in the accompanying figure, tap or click the ____ button on the Navigation bar.

If the Customer Number field in a record always should display the three characters in the customer number in uppercase, then the correct format for this field is ____.

When a filter is in effect, you can redisplay all records by tapping or clicking the ____ button on the HOME tab.

A default value is a value that Access will display on the screen in a particular field before the user begins adding a record.