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

When running an append query,the data types of the source fields do not have to match the data types of the destination fields.

What should you do before running a delete query?

You can use Undo when running an update or delete query.

A(n)________ can be used when records with missing data have been found.

An append query selects records from one or more tables and uses then to create a new table.

Which query identifies multiple instances of the same information in a table?

Action queries display different icons than select queries in the Navigation Pane.

It is not recommended to preview the datasheet prior to running a make table query.

You can use a make table query to copy some or all records from a source table to a destination table even if the destination table does not exist.

The process of creating a make table query is very similar to which other type of query?

Duplicate values in a table can prevent you from:

Backing up the database prior to running an update query is the best precaution.

The field names that display on the left side of a crosstab query are called ________.

What is the difference between an update query and an append query?

You would use a(n)________ query to identify records of all customers who live in Tennessee in order to change their area code to a new number.

Which type of query automatically creates a new table from data that already exists in a database?

An append query is used to add records to an existing table.

The find unmatched query requires two tables with a common field where one of the tables is missing information.

The ________ is responsible for maintaining databases,including performing backups,security checks,and upgrades to keep data both safe and accessible.

When updating records,convert the select query to an update query and insert the missing information.