Exam 6: Access: Maintaining a Database

-To move to the first record using the form shown in the accompanying figure,tap or click the ____ button on the Navigation bar.

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

-To add the Book Rep and Customer tables to the Relationships window shown in the accompanying figure,tap or click the Add button in the ___________________ dialog box.

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.

A(n)____________________ query adds,deletes,or changes data in a table.

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

You cannot preview the data to be updated in an update query before actually performing the update.

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

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

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

To find records in one table that have no matching records in another table,use the _____ Query Wizard.

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

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

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

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)_________________________ is a field in one table whose values are required to match a primary key in another table.

To use Filter By Form to filter records,tap or click the ____ button on the HOME tab and then click Filter By Form.

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

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

To specify that entries in the Returns field must be between $0.00 and $30,000.00,enter ____ in the Validation Rule property box.