Exam 17: Access: Maintaining a Database

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.

If you add a field to a table and later realize the field is in the wrong location,you can move the field.To move the field,tap or click the ____________________ for the field and then drag the field to the new location.

If you plan to move your data to SQL Server at a later date,do not use ____________________ fields.

Identify the letter of the choice that best matches the phrase or definition. -Allows you to delete all the records satisfying some criterion.

Identify the letter of the choice that best matches the phrase or definition. -Field that can be computed from other fields.

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

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

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.____________________

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

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 update records using an update query,enter the field to be updated in the design grid,enter any necessary criterion,and then tap or click the ____ button to update the records.