Exam 7: Action and Specialized Queries

Which of the following is not a rule for using an Append query?

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

What query would help you find if a customer purchased from you more than once?

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.

Which of the following is an example of a field which should not have duplicate data?

In a Crosstab query, the column heading is displayed at the ________ of the datasheet.

Match the following queries with the action they would perform: I. Append II. Delete III. Make Table IV. Crosstab V. Find duplicates A. Remove records from a table B. Display trends over time C. Find repeat customers D. Select records, then create a new table for them E. Add records from another table

A(n) ________ Table query can create a new table based on data in an existing table.

In a crosstab query, what data is found at the intersection of the rows and columns?

Match the following statements with which commands or queries they are true: i. This is a safe way to test an action query. II. This cannot be created directly from the Table tools tab; Design tab; Query Type group. III. This is often run after an Append query. IV. This is how most action queries begin. v. Performing this is always a good idea.

What does Access do to denote action queries differently in the Navigation Pane?

When you create a query, by default you are creating what type of query?

Match the following queries with what is unique about them: I. Crosstab II. Delete III. Update IV. Make Table V. Append A. Can only use one data source B. Similar to a copy and paste for records C. Removes records D. Should be run multiple times only with extreme caution E. Deletes existing table with same name

When creating a crosstab query, you need a minimum of four fields.

The Delete query is often used immediately after a(n) ________ query.

When working with queries, viewing a query in Datasheet View is the same as running the query.

Which of the following is not a reason for using specialized queries?

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

What query would you use if you were given an Excel spreadsheet of old customers and asked to incorporate these records into the Customers table of your database?

A(n) ________ query changes data values in one or more fields based on specific criteria.