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

Question 1

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

Answer 1

False

Question 2

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

Answer 2

B

Question 3

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

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

Answer 3

C

Question 4

You would use a find duplicates query to find the same values in a 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 copy new employee records from one table and add them to an existing table.

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

Question 7

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

Question 8

You CANNOT edit a crosstab query.

Question 9

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

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

Question 10

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

Question 11

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

Question 12

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

Question 13

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

Question 14

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