Exam 16: Action and Specialized Queries: Hands On Exercise Videos

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

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

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

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

You CANNOT edit a crosstab query.

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

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

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

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

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

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

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

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

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