Solved

Match Each Term with the Statement That Best Describes It

Question 34

Matching

Match each term with the statement that best describes it.

Premises:

Responses:

Used to search for a pattern

Criteria

The lower pane in Query Design View

Query grid

Criterion that finds all records where no entry has been made in the field

Is Null

Limiting conditions used to narrow the number of records on a datasheet

Filter

Putting records in ascending or descending order based on a field's values

Query

Creates a temporary subset of records

Wildcard

Rules that determine how criteria is entered

Sorting

Creates a datasheet of selected fields and records from one or more tables

Syntax

Premises:

Used to search for a pattern

The lower pane in Query Design View

Criterion that finds all records where no entry has been made in the field

Limiting conditions used to narrow the number of records on a datasheet

Putting records in ascending or descending order based on a field's values

Creates a temporary subset of records

Rules that determine how criteria is entered

Creates a datasheet of selected fields and records from one or more tables

Responses:

Criteria

Query grid

Is Null

Filter

Query

Wildcard

Sorting

Syntax

Correct Answer:

Premises:

Responses:

Used to search for a pattern

The lower pane in Query Design View

Criterion that finds all records where no entry has been made in the field

Limiting conditions used to narrow the number of records on a datasheet

Putting records in ascending or descending order based on a field's values

Creates a temporary subset of records

Rules that determine how criteria is entered

Creates a datasheet of selected fields and records from one or more tables