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

To avoid a mistake when using an update query that includes making calculations on a field,what is one thing you can do to prevent losing the original information?

After becoming familiar with the data in a database,what should be the first step when creating an action query?

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

A(n)________ query can be used to archive older records that need to be stored outside of the current table.

Which query identifies multiple instances of the same information in a table?

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

What should you do before running a delete query?

Why must care be taken when running a delete query?

What is the first step in creating an append query?

The field names that display at the top of a crosstab query are called ________.

Before running a delete query,what should you do?

You would use a(n)________ query to identify records of all customers who live in Tennessee in order to change their area code to a new number.

Why is it important to monitor how many times an update query is executed?

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

While reviewing a table,you find that the same customer was added to the customers table twice,you decide to run a(n)________ query to determine if there are any other records added multiple times.

When updating records,convert the select query to an update query and insert the missing information.

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

Duplicate values should always be deleted from a database table.

What is the purpose of a crosstab query?