Question 1

____ are tests 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 A

Question 2

Enter OR criteria on different Criteria rows in the query design grid.

Accepted Answer

A) True 
 B)False  True

Question 3

To add, delete, or change fields in a query, you use Query Design View.

Accepted Answer

A) True 
 B)False  True

Question 4

Match between columns
                        Premises: Limiting conditions used to narrow the number of records on a datasheet

Accepted Answer

The Answer of sorting and query grid and wildcard and is...

Question 5

In large datasheets, you may want to ____ certain fields so that they remain on the screen at all times.

Accepted Answer

A)   fix
B)   post
C)   freeze
D)   view

Question 6

Criteria ____ is the term for rules by which criteria must be entered in a query.

Accepted Answer

A)   Syntax
B)   Formatting
C)   Sorting
D)   Filter by Form

Question 7

To sort records based on the selected field in the order Z to A, use the _____ button.​

Accepted Answer

A)   ​Down
B)   ​Descending
C)   ​Z to A
D)   ​Reverse Sort

Question 8

Match between columns
                        Premises: Creates a temporary subset of records

Accepted Answer

The Answer of filter and query and sorting and criteria is...

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

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

Question 11

Match between columns
                        Premises: Putting records in ascending or descending order based on a field's values

Accepted Answer

The Answer of Is Null and sorting and query and is...

Question 12

____________________ 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 13

The wildcard character that stands for any group of characters is the ____.

Accepted Answer

A)   period (.) 
B)   semicolon (;) 
C)   asterisk (*) 
D)   plus sign (+)

Question 14

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 15

____________________ are limiting conditions you set in the query design grid.

Accepted Answer

The answer of ____________________ are limiting conditions you set in...

Question 16

The easiest way to filter the records for an exact match is to use the Filter By Form feature.

Accepted Answer

A) True 
 B)False

Question 17

The ____________________ button provides filter features such as Filter By Form, and Clear All Filters.​

Accepted Answer

The answer of The ____________________ button provides filter features such...

Question 18

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 19

A(n) ____________________ answers a question about the information in the database.

Accepted Answer

The answer of A(n) ____________________ answers a question about the...

Question 20

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)   sort

Exam 2: Building and Using Queries

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

Enter OR criteria on different Criteria rows in the query design grid.

To add, delete, or change fields in a query, you use Query Design View.

Match each term with the statement that best describes it.

In large datasheets, you may want to ____ certain fields so that they remain on the screen at all times.

Criteria ____ is the term for rules by which criteria must be entered in a query.

To sort records based on the selected field in the order Z to A, use the _____ button.

Match each term with the statement that best describes it.

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

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

Match each term with the statement that best describes it.

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

The wildcard character that stands for any group of characters is the ____.

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.

____________________ are limiting conditions you set in the query design grid.

The easiest way to filter the records for an exact match is to use the Filter By Form feature.

The ____________________ button provides filter features such as Filter By Form, and Clear All Filters.

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?

A(n) ____________________ answers a question about the information in the database.

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

Exam 2: Building and Using Queries

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

Enter OR criteria on different Criteria rows in the query design grid.

To add, delete, or change fields in a query, you use Query Design View.

Match each term with the statement that best describes it.

In large datasheets, you may want to ____ certain fields so that they remain on the screen at all times.

Criteria ____ is the term for rules by which criteria must be entered in a query.

To sort records based on the selected field in the order Z to A, use the _____ button.​

Match each term with the statement that best describes it.

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

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

Match each term with the statement that best describes it.

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

The wildcard character that stands for any group of characters is the ____.

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.

____________________ are limiting conditions you set in the query design grid.

The easiest way to filter the records for an exact match is to use the Filter By Form feature.

The ____________________ button provides filter features such as Filter By Form, and Clear All Filters.​

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?

A(n) ____________________ answers a question about the information in the database.

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

To sort records based on the selected field in the order Z to A, use the _____ button.

The ____________________ button provides filter features such as Filter By Form, and Clear All Filters.