Deck 6: Action and Specialized Queries: Hands-On-Exercise Videos

Question 1

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

Answer 1

True

Question 2

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

Answer 2

False

Question 3

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

Answer 3

False

Question 4

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

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

Question 5

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

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

Question 6

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

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

Question 7

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

Question 8

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

Question 9

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

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

Question 10

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

Question 11

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

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

Question 12

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

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

Question 13

You CANNOT edit a crosstab query.

Question 14

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

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