Solved

Match Each Term with the Statement That Best Describes It

Question 5

Matching

Match each term with the statement that best describes it.

Premises:

Responses:

Rules that determine how criteria is entered

Sorting

The lower pane in Query Design View

Wildcard

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

Syntax

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

Criteria

Creates a temporary subset of records

Filter

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

Is Null

Used to search for a pattern

Query grid

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

Query

Premises:

Rules that determine how criteria is entered

The lower pane in Query Design View

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

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

Creates a temporary subset of records

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

Used to search for a pattern

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

Responses:

Sorting

Wildcard

Syntax

Criteria

Filter

Is Null

Query grid

Query

Correct Answer:

Premises:

Responses:

Rules that determine how criteria is entered

The lower pane in Query Design View

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

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

Creates a temporary subset of records

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

Used to search for a pattern

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