Exam 17: Access: Maintaining a Database

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?

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

To include totals and other statistics at the bottom of a datasheet,tap or click the ____ button on the HOME tab to include the Total row in the datasheet.

Looking for the customer whose number is PLI22 is an example of searching.

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

To change gridlines in a datasheet,open the table in Datasheet view,select the entire datasheet,and tap or click the ____________________ button on the HOME tab.

To remove a total row that appears in a datasheet,tap or click the ____ button on the HOME tab.

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

Case 3-2 Bavant has just realized that they need to make some additional changes to the Customer table shown in Design view in the accompanying figure.They have asked you to make these changes. -Bavant would like to move the Customer Type field in the Customer table.The field should appear before the Book Rep Number field.What do you need to do to move the field?

In the type of relationship between the Book Rep and Customer tables illustrated in the accompanying figure,the infinity symbol indicates that one book rep is related to _________________________ customers.

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

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.

The Unfilter button toggles between filtered and unfiltered displays of the records in a table.

You cannot preview the data to be updated in an update query before actually performing the update.

You can use a make-table query to create an archive table.

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

Computations available for the Total row in a column that contains currency include ____.

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

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.

A(n)_________________________ is a field in one table whose values are required to match a primary key in another table.