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

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?

What should be the first step taken before creating an update query?

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

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

If you run a make table query again at a later time,what happens?

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

An append query is a query that:

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

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

When running an append query,what happens if a record violates the primary key rule for the destination table?

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

Where do the row headings display in a crosstab query?

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

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

Duplicate values in a table can prevent you from:

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

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

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

You should NOT rerun an action query.

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