Exam 6: Action and Specialized Queries: Moving Beyond the Select Query

An append query deletes records from one or more tables and adds them to an existing table.

Once records with missing data are found, what type of query can you use to add the needed information?

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

Action queries display different icons than select queries in the Navigation Pane.

What is the best way to check an update query before running it?

When running an append query, what happens if a record violates the primary key rule for the destination table?

When running an append query, an append query warning message appears specifying the number of rows to be appended.

If you run a make table query again at a later time, what happens?

Duplicate values in a table can prevent you from:

Which type of query automatically creates a new table from data that already exists in a database?

To test an update query before running it, you can:

To test an update query before running the query, what should you do first?

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

A(n) ________ query removes records from a table based on criteria that you specify.

Your company has increased the minimum credit line for all of its customers, you would run a(n) ________ query to include the increase in your table.

The find unmatched query requires two tables with a common field where one of the tables is missing information.

Why should you backup your database before running an action query?

Which type of query calculates data using a sum, average, or other function and groups the results by two sets of values?

Why must care be taken when running a delete query?

Backing up the database prior to running an update query is the best precaution.