Question 1

____________________ a table or query datasheet temporarily displays only those records that match given criteria.

Accepted Answer

The answer of ____________________ a table or query datasheet temporarily...

Question 2

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

Accepted Answer

A)   >
B)   >=
C)  ..
D)  .E) B) and C)
F) None of the above

Question 3

A query can be used to create calculated fields.

Accepted Answer

A) True 
 B)False

Question 4

A(n)  ____ is a temporary view of the data that is removed when you close the datasheet.

Accepted Answer

A)   filter
B)   query
C)   grid
D)   sortE) None of the above
F) B) and D)

Question 5

To filter for comparative data, use the Filter By Selection feature.

Accepted Answer

A) True 
 B)False

Question 6

The ____ button filters records that equal, do not equal, or are otherwise compared with the current value.

Accepted Answer

A)   Comparative
B)   Selection
C)   Comparison
D)   AdvancedE) A) and B)
F) A) and C)

Exam 2: Building and Using Queries

A query can be used to create calculated fields.