Solved

Match Each Term with the Statement That Best Describes It

Question 52

Matching

Match each term with the statement that best describes it.

Premises:

Responses:

The lower pane in Query Design View

query

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

Is Null

Used to search for a pattern

criteria

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

wildcard

Allows you to apply some basic formatting modifications such as changing the font size, font face, colors, and gridlines

query grid

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

filter

Creates a temporary subset of records

sorting

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

datasheet

Premises:

The lower pane in Query Design View

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

Used to search for a pattern

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

Allows you to apply some basic formatting modifications such as changing the font size, font face, colors, and gridlines

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

Creates a temporary subset of records

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

Responses:

query

Is Null

criteria

wildcard

query grid

filter

sorting

datasheet

Correct Answer:

Premises:

Responses:

The lower pane in Query Design View

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

Used to search for a pattern

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

Allows you to apply some basic formatting modifications such as changing the font size, font face, colors, and gridlines

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

Creates a temporary subset of records

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