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

The type of data displayed in a crosstab query depends on which aggregate function you choose when creating the query.

After becoming familiar with the data in a database,what should be the first step when creating an action query?

A(n)________ query can be used for adding records to an existing table.

If the destination table exists and you run the make table query,Access automatically deletes the source table.

What is the purpose of a crosstab query?

A find unmatched query compares records in two related tables and displays the records found in both tables.

Moving records from one table to another can be accomplished with the combination of what two types of queries?

An action query can be used to add,edit,or delete data in a database.

A(n)________ query removes records from a table based on criteria that you specify.

A(n)________ query provides the easiest way to move records from one table to another.

An append query is used to update or change data automatically based on criteria that you specify.

To avoid a mistake when using an update query that includes making calculations on a field,what is one thing you can do to prevent losing the original information?

A(n)________ would be used to replace null values with zeros?

If you would like to add data from an Excel spreadsheet to an existing Access table,you might use a(n)________ query.

Action queries include update,append,make table,and delete.

One reason an append query can fail is because of duplicate primary keys in the source and destination tables.

Why is it important to monitor how many times an update query is executed?

Access does not have a way to identify duplicate values.

Choosing the wrong matched field in an unmatched query will cause you to query incorrect information.