Question 1

A query can be used to create calculated fields.

Accepted Answer

A) True 
 B)False

Question 2

Critical Thinking Questions Case 2-1
Daniel Arno owns a lawn and landscape business with many customers. Occasionally, he wants to filter the data about his customers in various ways.
Daniel lives in Oxford and he would like to find all customers who do not live in Oxford. Which comparison operator should he use?

Accepted Answer

A)  = 
B)  #=# 
C)   
D)  >=

Question 3

The record selector button is to the right of a record in a datasheet. ____________________

Accepted Answer

A) True 
 B)False

Question 4

Critical Thinking Questions Case 2-1
Daniel Arno owns a lawn and landscape business with many customers. Occasionally, he wants to filter the data about his customers in various ways.
Daniel wants to make even more use of wildcard characters. Which operator is he most apt to use in these searches?

Accepted Answer

A)  Find 
B)  Like 
C)  Search 
D)  Near

Question 5

To delete records from a query datasheet, click the record selector button to the left of the record, click the Home tab, click the Delete button in the Records group, and click Yes.

Accepted Answer

A) True 
 B)False

Question 6

The ____ button provides a list of values in the selected field that can be used to customize a filter.

Accepted Answer

A)  Values 
B)  Selection 
C)  Filter 
D)  Advanced

Question 7

Which of the following comparison operators means "greater than"?

Accepted Answer

A)  > 
B)  >= 
C)  >> 
D)  <=

Question 8

Use the ____ command to save the current object with a new name.

Accepted Answer

A)  Datasheet 
B)  View 
C)  Save As 
D)  Save

Exam 2: Building and Using Queries

A query can be used to create calculated fields.

The record selector button is to the right of a record in a datasheet. ____________________

Critical Thinking Questions Case 2-1 Daniel Arno owns a lawn and landscape business with many customers. Occasionally, he wants to filter the data about his customers in various ways. Daniel wants to make even more use of wildcard characters. Which operator is he most apt to use in these searches?

To delete records from a query datasheet, click the record selector button to the left of the record, click the Home tab, click the Delete button in the Records group, and click Yes.

The ____ button provides a list of values in the selected field that can be used to customize a filter.

Which of the following comparison operators means "greater than"?

Use the ____ command to save the current object with a new name.