CGS ACCESS CH 4

Criteria in the same row implies ______. Records must meet both criteria.

AND

Text files that use a comma as the delimiter may be saved as a(n) _____ file.

CSV (comma-seperated value)

Click the ____filter option to remove the filter from the field.

Clear

The Query Wizard button in located in the _____ tab of the Ribbon.

Create

In a parameter query, instead of specific criterion, enter ____ for the use in the Criteria row.

prompts

If you want to control how records are displayed, set the _____ order as part of the query design.

sort

Filtering with AutoFilter is ______.

temporary

In the Simple Query Wizard, the ____ options shows every field you selected for every record.

Detail

The Expression Builder can be used to create complex expressions including functions similar to those in _____.

Excel

In order to reuse a query in the future, click the Run Later option in the Query Tools Desing tab.

False

If a record that contains data you want to filter is visible, you can click the field and use the ____ feature.

Filter by Selection

A ______ Query will find all the record that have duplicate values in one or more fields.

Find Duplicates

In a select query, typing ____ in the Criteria cell for a particular field will show all records that are missing data in that field.

Is Null

Different criteria in multiple rows implies _____. Records must match one criterion, but not all.

OR

The Run button is located near the left side of the Ribbon on the Query Tools Design Tab, in the _____ group.

Results

If you want to include a field in your query, but do not want that field to show in the Datasheet view, click the _______ box to remove the checkmark for the field you want to hide.

Show

A select query displays data from one or more related tables or queries, based on the fields that you select.

True

In a query, expression can reference fields, mathematical operators, functions, and constants.

True

If you want to include all the fields from a table in your query, click and drag the _____ from the top of the table to the field row.

asterisk (*)

In a query, a ____ displays a value returned by an expression (a formula).

calculated field

The Expression Builder is used to create calculated ____ in forms and reports.

controls

By applying a(n) ____ to a database object, you display a subset of records that meet your criteria.

filter

Sorting query results in ascending order sorts them _______.

from A to Z

A select query displays data from one or more related tables or queries, based on the fields that you select.

true

By hiding a field in a query, you can use it to define criteria without making the field ____ in the final query results.

visible