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

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

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

Why is it better to enter zero in a field instead of leaving the field blank?

Why must care be taken when running a delete query?

It is recommended to preview results before running a delete query.

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

A(n)________ can be used when records with missing data have been found.

A find unmatched query compares records in two related tables and displays the records found in both tables.

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

The process of creating a make table query is very similar to which other type of query?

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.

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

An action query can be used to add,edit,or delete data in a database.

What is the best precaution to take prior to running an update query?

The delete query saves you the chore of having to locate and delete records manually.

Moving records from one table to another can be accomplished with the combination of an append query and a delete query.

To find which customers have not yet ordered,you would run a(n)________ query.

If the destination table exists and you run the make table query,Access automatically deletes the source table.

What is the purpose of a find unmatched query?

An append query is used to update or change data automatically based on criteria that you specify.