Question 1

As you add rows of OR criteria to the query design grid, you decrease the number of records selected for the resulting datasheet.

Accepted Answer

A) True 
 B)False  False

Question 2

You can enter, edit, and navigate data in a query datasheet just like a report datasheet.

Accepted Answer

A) True 
 B)False  False

Question 3

In the figure above, which button opens the Find and Replace dialog box?

Accepted Answer

A)  3
B)  4
C)  5
D)  6 D

Question 4

Is ____________________ criteria will find all records where no entry has been made in the field.

Accepted Answer

The answer of Is ____________________ criteria will find all records...

Question 5

In the figure above, which button would you use to filter for more than one criterion?

Accepted Answer

A)  2
B)  3
C)  4
D)  5

Question 6

When you double-click a field in a field list in Query Design View, it is

Accepted Answer

A)  Deleted from the query
B)  Added to the next available position in the query design grid
C)  Used as the first sort order
D)  Set as the primary key field

Question 7

Deleting a field from a query also deletes it from the underlying table.

Accepted Answer

A) True 
 B)False

Question 8

You enter and edit data in a query datasheet in the same way you do in a table datasheet.

Accepted Answer

A) True 
 B)False

Question 9

In Query Design View, the query design ____________________ shows you the fields that you have requested for the query.

Accepted Answer

The answer of In Query Design View, the query design...

Question 10

____________________ means temporarily isolating a subset of records in a table or query.

Accepted Answer

The answer of ____________________ means temporarily isolating a subset of...

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

To filter for comparative data and to specify more complex criteria, use the Filter By Selection feature.

Accepted Answer

A) True 
 B)False

Question 13

Any edits you make in a query datasheet are permanently stored in the underlying relationships .

Accepted Answer

A) True 
 B)False

Question 14

To search for a pattern, you can use a ____________________ character, a symbol you can use as substitute for characters to find information that matches your find criteria.

Accepted Answer

The answer of To search for a pattern, you can...

Question 15

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

Accepted Answer

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

Question 16

Which of the following comparison operators means "less than or equal to"?

Accepted Answer

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

Question 17

In the figure above, item 4 points to a ____.

Accepted Answer

A)  Field name
B)  Primary key fields
C)  Design view
D)  Tables

Question 18

Which of the following comparison operators means "not equal to"?

Accepted Answer

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

Question 19

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

Accepted Answer

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

Question 20

____ are rules or limiting conditions you set to determine which records will be selected in a filter or query.

Accepted Answer

A)  Criteria
B)  Filters
C)  Queries
D)  None of the above

Exam 2: Building and Using Queries

As you add rows of OR criteria to the query design grid, you decrease the number of records selected for the resulting datasheet.

You can enter, edit, and navigate data in a query datasheet just like a report datasheet.

In the figure above, which button opens the Find and Replace dialog box?

Is ____________________ criteria will find all records where no entry has been made in the field.

In the figure above, which button would you use to filter for more than one criterion?

When you double-click a field in a field list in Query Design View, it is

Deleting a field from a query also deletes it from the underlying table.

You enter and edit data in a query datasheet in the same way you do in a table datasheet.

In Query Design View, the query design ____________________ shows you the fields that you have requested for the query.

____________________ means temporarily isolating a subset of records in a table or query.

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

To filter for comparative data and to specify more complex criteria, use the Filter By Selection feature.

Any edits you make in a query datasheet are permanently stored in the underlying relationships .

To search for a pattern, you can use a ____________________ character, a symbol you can use as substitute for characters to find information that matches your find criteria.

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

Which of the following comparison operators means "less than or equal to"?

In the figure above, item 4 points to a ____.

Which of the following comparison operators means "not equal to"?

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

____ are rules or limiting conditions you set to determine which records will be selected in a filter or query.