Matching
Match each term with the statement that best describes it.
Premises:
Rules that determine how criteria is entered
Criterion that finds all records where no entry has been made in the field
Putting records in ascending or descending order based on a field's values
Creates a temporary subset of records
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
The lower pane in Query Design View
Responses:
Query grid
Wildcard
Sorting
Syntax
Filter
Is Null
Query
Criteria
Correct Answer:
Premises:
Responses:
Rules that determine how criteria is entered
Criterion that finds all records where no entry has been made in the field
Putting records in ascending or descending order based on a field's values
Creates a temporary subset of records
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
The lower pane in Query Design View
Premises:
Rules that determine how criteria is entered
Criterion that finds all records where no entry has been made in the field
Putting records in ascending or descending order based on a field's values
Creates a temporary subset of records
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
The lower pane in Query Design View
Responses:
Related Questions
Q18: A join line is also called a
Q27: Which of the following keys will help
Q40: An Excel workbook has the file extension
Q43: How can the order of precedence in
Q44: A query datasheet is sometimes called a
Q48: To add a table's field list to
Q49: _ are rules or limiting conditions you
Q51: Press this keystroke combination to move focus
Q53: The report section before a group of
Q128: The Excel operator for exponent is _.<br>A)