Exam 7: Action and Specialized Queries

An action query is useful when an end user is required to enter the same information into many records.

When creating a crosstab query, you need a minimum of how many fields?

Match the following terms with their descriptions: I. Column heading II. Row heading III. Find duplicates query IV. Find unmatched query V. Make Table query A. Finds records which are found in one table, but not the other table B. Displayed at the top of a crosstab query C. Displayed at the left side of a crosstab query D. Selects records from one table and creates a new table with those records included E. Finds repeated values

Of the four action queries, which one would help you find records that are the same after you appended an Excel spreadsheet of data into your table?

What query would you use to find items that have never sold?

When you run an action query that affects data, Access always warns you how many records will be affected.

Which action query would you use if you wanted to add records from another table?

Which action query would you use if you wanted to change every occurrence of "Miss" or "Mrs." to "Ms"?

All duplicated data represents poor database design.

Which query would be helpful to locate students for whom no grades have been assigned during a semester?

What happens when a Make Table query is run when a table with the same name already exists in the database?

Unlike other queries, you can only reference one object as the data source in a Crosstab query.

Match the following recommendations with the appropriate commands or queries: i. Perform this before running an action query. II. Do this very carefully. III. Use this to help find redundant data. IV. Be aware that this is true of all action queries. v. Doing this will delete an existing table.

The ________ query is a good alternative to the Find and Replace tool.

The use of the Make table query is often followed by the Delete query.

It is always a good practice to backup your entire database before running an action query.

Of the four action queries, which one would help you track student grades over the past decade?

A(n) ________ query automatically removes records based on certain criteria.

You cannot undo updates or deletions performed by a(n) ________ query.

When you convert a Select query to an Append query, Access removes the Show row and adds a(n) ________ To row in its place.