Exam 4: Maintaining a Database

To find duplicate records in a table, use the _____ Query Wizard.

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

When you use Advanced Filter/Sort to filter records using complex criteria, create the filter and then click the ____ button on the Home tab to view the results.

A ____ field allows the user to select from a list of values.

You can use the asterisk (*) wildcard in a filter but not the question mark (?) wildcard.

Validation rules ensure validity of the data in the database, while entity integrity ensures the validity of the relationships.

When specifying referential integrity, one way to handle the update of a primary key is to _________________________; that is, have Access allow the update but then automatically make the corresponding change in any related records in other tables.

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

To search for a specific record click the _____ button on the Home tab shown in the accompanying figure to display the Find and Replace dialog box.

Modified Multiple Choice Validation rules can indicate a ____.

To add a new record using Form view, click the New (blank) record button on the Navigation bar.

When specifying referential integrity, one way to handle deletions is to _________________________; that is, have Access allow the deletion but then automatically delete any related records in other tables.

To create a split form, select the table in the Navigation Pane, click Create on the Ribbon, and then click the ____ button on the Create tab to display a menu and click Split Form on the menu.

To delete record GF56 shown in the accompanying figure, click the record selector in the datasheet for the record on which the client number is GF56 and then press ____.

The simplest type of filter is called Filter By Form.

Critical Thinking Questions Case 3-2 Camashaly has just realized that they need to make some additional changes to the Client table shown in Design view in the accompanying figure. They have asked you to make these changes. Camashaly would like to move the Client Type field in the Client table. The field should appear before the Business Analyst Number field. What do you need to do to move the field?