Exam 5: Maintaining a Database

Critical Thinking Questions Case 3-1 Bavant Publishing has decided to add some additional validation rules to the Customer table shown in Design view in the accompanying figure. They have asked you to create these validation rules. Bavant would like to make sure that if an employee enters the letters pa in the State field that it displays in the database as PA. What property do you need to change and what would you enter in the property box?

To create an update query, create a new query and then tap or click the ____ button on the DESIGN tab.

To sort the data that appears in a datasheet on multiple fields, the major and minor keys must be next to each other in the datasheet with the major key on the right.

To move from Layout view to Form view, tap or click the ____ button on the Access status bar.

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

Maintenance of a database can involve the need to _________________________ periodically; that is, to change the database structure.

To create a lookup field, select ____________________ from the menu of available data types.

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

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

When an update query is created, a(n) _________________________ row displays in the design grid.

To search for a specific record tap or click the ____ button on the HOME tab to display the Find and Replace dialog box shown in the accompanying figure.

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