Exam 7: Action and Specialized Queries

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

Append queries are often used in conjunction with ________ queries to move records from one table to another and removed records from the current table.

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

Which action query provides an easy, automated way to copy records from one table to another table?

Before running an action query, it is good idea to backup your database.

What query would you use to give all full-time employees a 3% raise?

A find ________ query compares records in two related tables and displays the records found in one table but not the other.

When you create a query, by default you are creating a(n) ________ query.

The ________ query can add records from a spreadsheet to an existing table.

Tables can be created using the Crosstab query type.

As with other actions in Access, you can undo the changes made by running actions queries.

Which is the first table chosen when creating a find duplicates query?

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

When you update data in a query, you are actually updating the data in the underlying table.

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

It is possible, using the Make Table query to create a table in another database.

The Delete action query deletes tables.

What query or queries would you use to move every item that has never been sold to a new database, then reduce the price of each item by 10%?

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

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