Question 1

What is the purpose of a crosstab query?

Accepted Answer

The answer of What is the purpose of a crosstab...

Question 2

What is the difference between an update query and an append query?

Accepted Answer

The answer of What is the difference between an update...

Question 3

Why must care be taken when running a delete query?

Accepted Answer

The answer of Why must care be taken when running...

Question 4

What is the best way to check an update query before running it?

Accepted Answer

The answer of What is the best way to check...

Question 5

What are the four types of action queries?

Accepted Answer

The answer of What are the four types of action...

Question 6

The field names that display on the left side of a crosstab query are called ________.

Accepted Answer

The answer of The field names that display on the...

Question 7

What is the best precaution to take prior to running an update query?

Accepted Answer

The answer of What is the best precaution to take...

Question 8

Your company has increased the minimum credit line for all of its customers,you would run a(n)________ query to include the increase in your table.

Accepted Answer

The answer of Your company has increased the minimum credit...

Question 9

To find which customers have not yet ordered,you would run a(n)________ query.

Accepted Answer

The answer of To find which customers have not yet...

Question 10

Why is it important to monitor how many times an update query is executed?

Accepted Answer

The answer of Why is it important to monitor how...

Question 11

While reviewing a table,you find that the same customer was added to the customers table twice,you decide to run a(n)________ query to determine if there are any other records added multiple times.

Accepted Answer

The answer of While reviewing a table,you find that the...

Question 12

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

Accepted Answer

The answer of A ________ query makes it easy to...

Question 13

What should you do before running a delete query?

Accepted Answer

The answer of What should you do before running a...

Question 14

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

Accepted Answer

The answer of To remove the duplicate records found in...

Question 15

Delete,append,and update queries are all examples of a(n)________ query.

Accepted Answer

The answer of Delete,append,and update queries are all examples of...

Question 16

How do appended records appear in the destination table?

Accepted Answer

The answer of How do appended records appear in the...

Question 17

You would use a(n)________ query to identify records of all customers who live in Tennessee in order to change their area code to a new number.

Accepted Answer

The answer of You would use a(n)________ query to identify...

Question 18

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

Accepted Answer

The answer of The ________ is responsible for maintaining databases,including...

Question 19

Why is it better to enter zero in a field instead of leaving the field blank?

Accepted Answer

The answer of Why is it better to enter zero...

Question 20

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

Accepted Answer

The answer of If you would like to add data...

Quiz 14: Action and Specialized Queries: Moving Beyond the Select Query