Exam 35: Access : Action and Specialized Queries: Moving Beyond the Select Query

Where do the column headings display in a crosstab query?

Why must care be taken when running a delete query?

Delete,append,and update queries are all examples of a(n)________ query.

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

A delete query automatically creates a new table from data that already exists in a database.

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

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

What must be present for a find unmatched query to work?

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

How do appended records appear in the destination table?

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.

Find unmatched queries provide a subset of the data that answers most questions that users ask about the data in their databases.

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

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

To remove the duplicate records found in a table,you would run a(n)________ query.

You should NOT rerun an action query.

The grouping in a crosstab query comes from the definitions of row and column headings.

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

When running a delete query,you are prompted with a warning message.