Exam 5: Maintaining a Database

In the Bavant Publishing database, a one-to-many relationship exists between the Book Rep table and the Customer table.

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

A secondary key is a field in one table whose values are required to match the primary key of another table.

To filter records using complex criteria, tap or click the ____ button on the HOME tab and then tap or click Advanced Filter/Sort on the menu that appears.

To specify that a field is to be required, change the value for the _____ property from No to Yes.

Four types of filters are available in Access: Filter By Selection, Common Filters, Filter By Form, and Advanced Filter/Sort.

To print a copy of a relationship, tap or click the _____________________ button shown on the accompanying figure.

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

To order the records in the Customer table in reverse alphabetical order by City, click the ____ button.

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

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

To open the Relationships window in the accompanying figure, tap or click the _________________________ button on the DATABASE TOOLS tab.

To change a query so that each item in a multivalued field occurs on a different row, use the ____ property.

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

Modified Multiple Choice You can add a record to a table by ____.

The button on the Access status bar that displays a form in Form view is Form View.

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

To indicate that the only allowable values for the Customer Type field are HS, COM, and UNI, enter ____ in the Validation Rule property box.