Exam 7: Action and Specialized Queries

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

What query or queries would you use to find all repeat customers, change their shipping costs to zero, and then three months from now track their purchases to see if they purchased more over the last three months than the three months before the shipping costs were changed?

Match the following terms with their descriptions: I. Action query II. Append query III. Delete query IV. Update query V. Crosstab query A. Adds records from a source table to a destination table B. Changes data values C. Removes records D. General term for any query that changes data E. Displays trends over time

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

Finding ________ values and knowing what to do with them remains one of the challenges of good database design.

Which of the following is not true about running action queries?

An Update query can only update (change) values in one field at a time.

Which action query can be undone if you change your mind immediately after running the query?

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

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

What queries are often used in conjunction with delete queries to move records from one table to another?

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

You can present grouped and summarized data with a(n) ________ query

The Make Table query is an example of a(n) ________ query.

Running an update query from ________ view does not display the results in a datasheet like a select query does.

In a Find duplicates query, it does not matter which table is chosen first.

In an Append query, what happens to any records that violate the Primary key (or any other) rule?

A(n) ________ query removes records from a table.

Which of the following is not a type of query in Access?

What two queries would you use to move all customers with unpaid invoices into a new table of their own and remove them from the original table?