Question 1

A(n)________ query removes records from a table based on criteria that you specify.

Accepted Answer

A) delete 
B) append 
C) update 
D) make table

Question 2

Action queries display different icons than select queries in the Navigation Pane.

Accepted Answer

A) True 
 B)False

Question 3

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 4

Why must care be taken when running a delete query?

Accepted Answer

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

Question 5

It is recommended to preview results before running a delete query.

Accepted Answer

A) True 
 B)False

Question 6

Which type of query automatically creates a new table from data that already exists in a database?

Accepted Answer

A) Make Table 
B) Update 
C) Append 
D) Delete

Question 7

A(n)________ can be used when records with missing data have been found.

Accepted Answer

A) update query 
B) append query 
C) delete query 
D) make table query

Question 8

A find unmatched query compares records in two related tables and displays the records found in both tables.

Accepted Answer

A) True 
 B)False

Question 9

Backing up the database prior to running an update query is the best precaution.

Accepted Answer

A) True 
 B)False

Question 10

The process of creating a make table query is very similar to which other type of query?

Accepted Answer

A) Append query 
B) Delete query 
C) Find duplicates query 
D) Update query

Question 11

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 12

Once records with missing data are found,what type of query can you use to add the needed information?

Accepted Answer

A) Update 
B) Delete 
C) Make table 
D) Find duplicates

Question 13

An action query can be used to add,edit,or delete data in a database.

Accepted Answer

A) True 
 B)False

Question 14

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 15

The delete query saves you the chore of having to locate and delete records manually.

Accepted Answer

A) True 
 B)False

Question 16

Moving records from one table to another can be accomplished with the combination of an append query and a delete query.

Accepted Answer

A) True 
 B)False

Question 17

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 18

If the destination table exists and you run the make table query,Access automatically deletes the source table.

Accepted Answer

A) True 
 B)False

Question 19

What is the purpose of a find unmatched query?

Accepted Answer

A) To compare records in two related tables and display the records found in one table and not the other. 
B) To find records that are the same in two related tables. 
C) To combine information in one table with information in another table. 
D) To summarize a table into columns and rows to show trends.

Question 20

An append query is used to update or change data automatically based on criteria that you specify.

Accepted Answer

A) True 
 B)False

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

A(n) ________ query removes records from a table based on criteria that you specify.

Action queries display different icons than select queries in the Navigation Pane.

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

Why must care be taken when running a delete query?

It is recommended to preview results before running a delete query.

Which type of query automatically creates a new table from data that already exists in a database?

A(n) ________ can be used when records with missing data have been found.

A find unmatched query compares records in two related tables and displays the records found in both tables.

Backing up the database prior to running an update query is the best precaution.

The process of creating a make table query is very similar to which other type of query?

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.

Once records with missing data are found,what type of query can you use to add the needed information?

An action query can be used to add,edit,or delete data in a database.

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

The delete query saves you the chore of having to locate and delete records manually.

Moving records from one table to another can be accomplished with the combination of an append query and a delete query.

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

If the destination table exists and you run the make table query,Access automatically deletes the source table.

What is the purpose of a find unmatched query?

An append query is used to update or change data automatically based on criteria that you specify.