Exam 18: Action and Specialized Queries: Moving Beyond the Select Query

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

A crosstab query works best when the data source has at least two grouping fields.

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

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

Where do the column headings display in a crosstab query?

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

A(n)________ query is used to update or change data automatically based on criteria that you specify.

To test an update query before running the query,what should you do first?

Your company has increased the minimum credit line for all of its customers,you would run a(n)________ query to include the increase in your table.

What must be present for a find unmatched query to work?

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

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

Delete,append,and update queries are all examples of a(n)________ query.

Once records with missing data are found,what type of query can you use to add the needed information?

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

It is important to ensure that when you delete duplicate records,you do not delete associated records in a related table.

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

Why should you backup your database before testing an action query?

An append query changes the data values in one or more fields for all records that meet specific criteria.