Exam 3: Querying a Database

To find all clients whose names begin with Gr, enter Gr* in the Criteria row of the design grid.

To create a parameter query, enter a parameter rather than a specific value as a criterion in the design grid. The parameter must be enclosed in _____.

In the accompanying figure, the criterion for Current Due is 0. To find all clients whose current due amount is greater than $1,000.00, erase the 0 and enter _____ in the Criteria row of the Current Due column.

The field or fields on which records are sorted is called the sort key.

You can export to Excel but you cannot export data to a text file.

The ____________________ function finds the smallest value in a group of records.

To organize entries in the Navigation Pane by table, click ____ on the Navigation Pane menu.

You can include ____ in calculations to indicate which calculation should be done first.

Crosstab queries are useful for summarizing data.

To create a parameter query that will prompt users to enter a city name as input, place [Enter City] as the criterion in the City field.

Modified Multiple Choice The special criteria that can be used in queries are ____.

The ____________________ wildcard represents any individual character.

An aggregate function is a function that performs some mathematical function against a group of records.

To find all individuals whose name is Francis or Frances, enter ____ in the Criteria row of the appropriate column.

To omit duplicates from a query, use the property sheet and change the Unique Values property to _____.

A(n) ____________________ query is a query that prompts for input whenever it is used.

The arithmetic symbols for use in query calculations are ____.