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

Prior to updating data in a table,you must first locate the records that need to be modified.

While reviewing a table,you find that the same customer was added to the customers table twice,you decide to run a(n)________ query to determine if there are any other records added multiple times.

Once you run an action query,you are committing yourself to an irreversible change.

An append query is a query that:

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

An append query deletes records from one or more tables and adds them to an existing table.

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

To test an update query before running it,you can:

When running an append query,an append query warning message appears specifying the number of rows to be appended.

Which of the following is NOT a rule for appending queries?

How is a crosstab query different from other queries?

What is the purpose of a find unmatched query?

What are the four types of action queries?

Moving records from one table to another can be accomplished with the combination of an append query and a delete query.

Which type of query calculates data using a sum,average,or other function and groups the results by two sets of values?

What is the best way to check an update query before running it?

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

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

Where do the row headings display in a crosstab query?

The find unmatched query only works if two tables share a common field.