Exam 7: Action and Specialized Queries

Depending on what an Update query is designed to do; it is often not a good idea to run the query again.

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

Which action query provides an easy,automated way to copy records from one table to another table?

Which action query can be undone if you change your mind immediately after running the query?

Which of the following is not a reason for using specialized queries?

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

Which of the following is not a rule for using an Append query?

You can present grouped and summarized data with a(n)________ query

When you create a query,by default you are creating a(n)________ query.

What query would you use to give all full-time employees a 3% raise?

What query is often used to display trends in values?

What query would help you find if a customer purchased from you more than once?

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

It is possible,using the Make Table query to create a table in another database.

When you assign a date field to the column heading in a crosstab query,which option does Access not give you for summarizing your data?

A(n)________ query changes data values in one or more fields based on specific criteria.

The Make table query is limited to creating tables in the current database.

The Delete query is often used immediately after a(n)________ query.

What query or queries would you use to find all repeat customers,change their shipping costs to zero,and then three months from now track their purchases to see if they purchased more over the last three months than the three months before the shipping costs were changed?