Solved

Match Each Term with the Statement That Best Describes It

Question 46

Matching

Match each term with the statement that best describes it.

Premises:

Responses:

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

Wildcard

Creates a temporary subset of records

Query

Used to search for a pattern

Filter

Rules that determine how criteria is entered

Query grid

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

Is Null

The lower pane in Query Design View

Syntax

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

Criteria

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

Sorting

Premises:

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

Creates a temporary subset of records

Used to search for a pattern

Rules that determine how criteria is entered

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

The lower pane in Query Design View

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

Responses:

Wildcard

Query

Filter

Query grid

Is Null

Syntax

Criteria

Sorting

Correct Answer:

Premises:

Responses:

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

Creates a temporary subset of records

Used to search for a pattern

Rules that determine how criteria is entered

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

The lower pane in Query Design View

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