Access Mod 3 Q2

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

• True

• False

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

• True

• False

The Remove Filter command on the Advanced menu clears all filters.

• True

• False

Filter By Query allows you to filter based on multiple criteria, for example, to find only those accounts whose returns are $0.00 and whose account manager is 38.

• True

• False

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

• True

• False

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

• True

• False

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

• True

• False

In the PrattLast Associates database, a one-to-many relationship exists between the Account Manager table and the Account table.

• True

• False

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

• True

• False

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.

• True

• False