Exam 13: Access_Module_3

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.

To use a common filter to find only those customers whose city begins with G, click the arrow to the right of the field name and point to the ____ command to display the custom text filters.

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

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

To use Filter By Selection to find all customers located in Granger, click the City field for any record where the city is Granger and then click the ____ button on the HOME tab.

A(n) ____________________ is a form that allows you to simultaneously view both simple form and datasheet views of the data.

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

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

To save validation rules, default values, and formats, click the Save button on the ____ to save the changes.

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.

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

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

You can restore filter settings that you previously saved in a query by using the ____________________ command on the Advanced menu.

To create a validation rule for the State field to restrict entries to TN or TX, enter ____ in the Validation Rule property box.

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

To display the Total row in a datasheet, click the Sum button on the ribbon. ____________________

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

The property that the value in a foreign key must match another table's primary key is called _________________________.

A(n) ____ query adds a group of records from one table to the end of another table.

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