Exam 6: Action and Specialized Queries: Hands-On-Exercise Videos

The ________ Query Wizard would be used to compare customer records in the Customer and Order tables to determine which customers have made no purchases.

The results of running an update query can be reversed using the Undo button.

You should back up your database before testing an action query.

You would use a(n)________ query to make changes to the retail price field for records meeting a specified criteria.

A(n)________ query is used to display aggregate data in a row-and-column layout.

A(n)________ query is used to copy new employee records from one table and add them to an existing table.

A make table query selects records from one or more tables and uses them to create a new table.

You would use a find duplicates query to find the same values in a table.

You CANNOT edit a crosstab query.

You would use a(n)________ query to remove the records of former employees from a table.

A purge query is used to remove records from a table.

To find the same values in a table,you would use the Find ________ Query Wizard.

You use a ________ query to select records of former employees from a table and use them to create a new table.

A select query is used to select records from one or more tables and use them to create a new table.