Exam 7: Action and Specialized Queries

Action queries change data.

Before running an Update query,you usually begin with a(n)________ query to view the results before making a permanent change.

Which query would you use to show the sales by region for each of four quarters?

The first step in creating a Delete query is to create what other type of query?

Of the four action queries,which one would help you find repeat customers?

You cannot run a Make Table query if a table with that name already exists in the database.

Crosstab queries display the results in a grid of columns and rows.

Before running an Append query,it is best to first create a(n)________ query to view the results before making a permanent change.

What must you do before you can create a crosstab query that references more than one table?

In a crosstab query,the field values which are displayed on the left side are also called the ________ heading.

Tables can be created using the Crosstab query type.

When you create a query,by default you are creating a parameter query.

When an Append query is run on a table that has no primary key,where do the new records appear?

When running a Make Table query,if the "Move Records" check box is checked,then the table will be created and all appropriate records will be moved (not just copied)to the new table.

In a crosstab query,where do the values of a field selected as a row heading display?

A(n)________ query is usually created to show trends in values.

What query would you use to find items that have never sold?