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

What does the type of data displayed in a crosstab query depend on?

The results of running an update query can be reversed using the Undo button.

You would use a(n) ________ query to remove the records of former employees from a table.

To remove the duplicate records found in a table, you would run a(n) ________ query.

To find the same values in a table, you would use the Find ________ Query Wizard.

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

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

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

There is no way to verify that the correct records will be updated when using an update query.

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

A ________ query makes it easy to correct errors or add values to blank fields.

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

What is the purpose of a find unmatched query?

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

Match the following terms with their meanings: I. update query II. append query III. make table query IV. delete query A. creates a new table from data that already exist in a database B. removes records from a table based on criteria that you specify C. updates or changes data automatically based on criteria that you specify D. adds records to an existing table

It is recommended to preview results before running a delete query.

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

Where do the row headings display in a crosstab query?

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