Exam 7: Action and Specialized Queries

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

What two queries would you use to move all customers with unpaid invoices into a new table of their own and remove them from the original table?

When you create a query,by default you are creating what type of query?

A find ________ query compares records in two related tables and displays the records found in one table but not the other.

What query would you use if you were given an Excel spreadsheet of old customers and asked to incorporate these records into the Customers table of your database?

An Update query can only update (change)values in one field at a time.

In a crosstab query,what data is found at the intersection of the rows and columns?

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

The Delete action query deletes tables.

Unlike other queries,changing elements in a Crosstab query is difficult and it is usually easier to just create a new query.

In a Crosstab query,the column heading is displayed at the ________ of the datasheet.

Append queries are often used in conjunction with ________ queries to move records from one table to another and removed records from the current table.

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

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

All duplicated data represents poor database design.

Which of the following is not a common aggregate function used in a crosstab query?

What queries are often used in conjunction with delete queries to move records from one table to another?