Exam 5: Maintaining a Database

A(n) ____ field is a field that can be computed from other fields.

A lookup field allows the user to select from a list of values when updating the contents of a field.

When the Book Rep table is related to the Customer table, it is possible to view the customers of a given book rep when you are viewing the datasheet for the Book Rep table. The customers for the book rep will appear below the book rep in a split form .

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

To use the shortcut menu to create an update query, press and hold or right-click any open area in the upper pane, point to ____ on the shortcut menu, and then tap or click Update Query on the submenu that appears.

A(n) ____ query adds records from an existing table to a new table, that is, a table that has not yet been created.

To order the records in the Customer table by city in alphabetical order, use the ____ button.

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

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.

When you create a calculated field, users can update the field.

Normally, Access prohibits the deletion of a record in which the primary key matches a foreign key in another table.

Filter By Query allows you to filter based on multiple criteria, for example, to find only those customers whose returns are $0.00 and whose book rep number is 42.

To clear a filter, tap or click the ____ button on the HOME tab and then tap or click Clear All Filters.

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

To exit Access, click the ____ button on the right side of the Access title bar.

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

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

If the TAB key is used to move from field to field in a record, press F2 to produce an insertion point in a field.