FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 7: Action and Specialized Queries

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

Short Answer

Review LaterAdd Note

Review Later

A(n) ________ query removes records from a table.

Correct Answer

verified

Show Answer

Question 22

Multiple Choice

Review LaterAdd Note

Review Later

Which of the following is not true about running action queries?

A) They can be undone.
B) They can be cancelled before completion.
C) You will receive a warning when you attempt to run them.
D) They change data.

Correct Answer

verified

Show Answer

Question 23

Multiple Choice

Review LaterAdd Note

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?

Before running an Update query, you usually begin with a(n) ________ query to view the results before making a permanent change.

In a Find duplicates query, it does not matter which table is chosen first.

The first step in creating a Delete query is to create what other type of query?

In an Append query, what happens to any records that violate the Primary key (or any other) rule?

A(n) ________ query is usually created to show trends in values.

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

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

In a crosstab query, where do the values of a field selected as a row heading display?

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

The Make Table query is an example of a(n) ________ query.

Which of the following is not a type of query in Access?

What must you do before you can create a crosstab query that references more than one table?

Match the following terms with their descriptions: I. Action query II. Append query III. Delete query IV. Update query V. Crosstab query A. Adds records from a source table to a destination table B. Changes data values C. Removes records D. General term for any query that changes data E. Displays trends over time

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

Finding ________ values and knowing what to do with them remains one of the challenges of good database design.

Running an update query from ________ view does not display the results in a datasheet like a select query does.

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?