Exam 5: Access: Maintaining a Database

To update records using an update query, enter the field to be updated in the design grid, enter any necessary criterion, and then click the ____ button to update the records.

Figure 3-2 To search for a specific record click the Find button on the Home tab shown in the accompanying figure to display the ____ dialog box.

When you use an update query, you must enter a criterion.

You cannot preview the data to be deleted in a delete query before actually performing the deletion.

A multilookup field is a field that contains more than one value.

When you use Filter By Form to restrict records that appear, you create the filter and then click the ____ button to apply the filter.

You can use a filter in either Datasheet view or Form view.

To open another database, click the Office Button, click ____ on the Office Button menu, select the database to be opened, and then click the Open button.

To add a new record using Form view, click the Add Record button on the Navigation bar.

One reason to include a foreign key for a table is to eliminate duplicate records.

Validation rules are rules that a user must follow when entering the data.

Figure 3-3 To open the Relationships window in the accompanying figure, click the _________________________ button on the Database Tools tab.

You cannot apply a filter to the results of a query.

To delete a field from a table, open the table in ____ view, click the row selector for the field to be deleted and then press the DELETE key.

Access includes only three types of action queries: delete, update, and append.

If you plan to move your data to SQL Server at a later date, do not use ____________________ fields.

If a Security Warning appears when you open a database, click the ____ button to display the Microsoft Office Security Options dialog box.

To create a multivalued field, create a ____________________ field being sure to check the Allow Multiple Values check box.