Question 1

A purge query is used to remove records from a table.

Accepted Answer

A) True 
 B)False  False

Question 2

You would use a(n)________ query to make changes to the retail price field for records meeting a specified criteria.

Accepted Answer

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

Question 3

A select query is used to select records from one or more tables and use them to create a new table.

Accepted Answer

A) True 
 B)False  False

Question 4

A make table query selects records from one or more tables and uses them to create a new table.

Accepted Answer

A) True 
 B)False

Question 5

You CANNOT edit a crosstab query.

Accepted Answer

A) True 
 B)False

Question 6

The results of running an update query can be reversed using the Undo button.

Accepted Answer

A) True 
 B)False

Question 7

A(n)________ query is used to display aggregate data in a row-and-column layout.

Accepted Answer

A) summary 
B) crosstab 
C) action 
D) outline

Question 8

You would use a(n)________ query to remove the records of former employees from a table.

Accepted Answer

A) erase 
B) dispose 
C) delete 
D) exclude

Question 9

You should back up your database before testing an action query.

Accepted Answer

A) True 
 B)False

Question 10

You use a ________ query to select records of former employees from a table and use them to create a new table.

Accepted Answer

A) create table 
B) merge tables 
C) combine tables 
D) make table

Question 11

A(n)________ query is used to copy new employee records from one table and add them to an existing table.

Accepted Answer

A) make table 
B) append 
C) select 
D) dispose

Question 12

You would use a find duplicates query to find the same values in a table.

Accepted Answer

A) True 
 B)False

Question 13

The ________ Query Wizard would be used to compare customer records in the Customer and Order tables to determine which customers have made no purchases.

Accepted Answer

A) Find Unmatched 
B) List Unmatched 
C) Find Missing 
D) List Missing

Question 14

To find the same values in a table,you would use the Find ________ Query Wizard.

Accepted Answer

A) Repeated 
B) Alike 
C) Matching 
D) Duplicates

Exam 16: Action and Specialized Queries: Hands On Exercise Videos

A purge query is used to remove records from a table.

You would use a(n) ________ query to make changes to the retail price field for records meeting a specified criteria.

A select query is used to select records from one or more tables and use them to create a new table.

A make table query selects records from one or more tables and uses them to create a new table.

You CANNOT edit a crosstab query.

The results of running an update query can be reversed using the Undo button.

A(n) ________ query is used to display aggregate data in a row-and-column layout.

You would use a(n) ________ query to remove the records of former employees from a table.

You should back up your database before testing an action query.

You use a ________ query to select records of former employees from a table and use them to create a new table.

A(n) ________ query is used to copy new employee records from one table and add them to an existing table.

You would use a find duplicates query to find the same values in a table.

The ________ Query Wizard would be used to compare customer records in the Customer and Order tables to determine which customers have made no purchases.

To find the same values in a table,you would use the Find ________ Query Wizard.