Question 1

In the figure above,  item 3 could also be entered as ____.

Accepted Answer

A)  colorado 
B)  COLORADO 
C)  CoLoRaDo 
D)  All of the above

Question 2

In Query Design View, record selectors are thin gray bars above the field names.

Accepted Answer

A) True 
 B)False

Question 3

A(n) ____ is a saved view of the data whose criteria is not discarded when you close the datasheet.

Accepted Answer

A)  Query 
B)  Filter 
C)  Find 
D)  Union

Question 4

The question mark (?) is the wildcard character which stands for any single character in criteria.

Accepted Answer

A) True 
 B)False

Question 5

Filter By ____________________ filters records based on more than one selection criteria by using a special window.

Accepted Answer

The answer of Filter By ____________________ filters records based on...

Question 6

This button helps search for data in a single field or in all fields.

Accepted Answer

A)  Find 
B)  Sort Ascending 
C)  Filter By String 
D)  Filter By Criteria

Question 7

SQL is the acronym for " simple query language ".

Accepted Answer

A) True 
 B)False

Question 8

The upper portion of Query Design View shows a table's ____________________ list.

Accepted Answer

The answer of The upper portion of Query Design View...

Exam 2: Building and Using Queries

In the figure above, item 3 could also be entered as ____.