Name: 

The question mark (?) wildcard represents any collection of characters.

To enter a criterion for a particular field without displaying the field in the results of the query, include the field in the design grid, enter the criterion, and remove the check mark from its Show check box.

A query that prompts for input whenever it is run is a run-time query.

You create a parameter by enclosing a value in a criterion in curly braces ({}).

To remove a table from a query, right-click the field list and then click Drop Table on the shortcut menu.

To save a query, the query design must appear on the screen.

To enter a number in a criterion, type the number without any dollar signs or commas.

To search for a range of values in one field, use the RANGE operator.

To find all clients whose amount paid is greater than $20,000.00 or whose recruiter is recruiter 21, enter each criterion on the same line.

If you specify more than one sort key, the sort key on the left will be the minor sort key and the one on the right will be the major sort key.

When you sort data, duplicates normally are included.

When tables are joined in a query, it is not possible to restrict retrieval by using criteria.

The expression for a calculated field can be typed directly into the Field row.

Grouping means creating groups of records that share some common characteristic.

Parameter queries are useful for summarizing data.

If a Security Warning appears when you open a database, click the ____ button to display the Microsoft Office Security Options dialog box.

In the accompanying figure, you can delete the table by right-clicking the field list and clicking ____ on the shortcut menu.

In the accompanying figure, you can remove a column by clicking just above the field name to select the column and then clicking the ____ key(s).

In the accompanying figure, you can find all clients whose names begin with Be, by entering _____ in the Criteria row of the Client Name field.

To use a saved query, right-click the query in the Navigation Pane and then click ____ on the shortcut menu.

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

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

To display the Join Properties dialog box, right-click the join line and click ____ on the shortcut menu.

To include calculated fields in queries, enter a name for the calculated field, a(n) _____, and then the expression in one of the columns in the Field row.

To calculate statistics for only those records that satisfy certain criteria, select ____ as the entry in the Total row for the field, and then enter the criterion in the Criteria row.

If there are no restrictions involved in the query, nor any special order or calculations, you can use the ____________________ wizard.

The View button menu appears in the accompanying figure. To change the design of a query, click the ____________________ button on the menu.

The View button menu appears in the accompanying figure. To see the results of a query, click the ____________________ button on the menu.

A(n) ____________________ is a condition that the records to be included in a query must satisfy.

To find all clients whose names begin with Be, enter ____________________ as the criterion for the Client Name field.

____________________ are symbols that represent any character or combination of characters.

To find all clients whose amount paid is more than $20,000.00, use the ____________________ operator.

If two tables have matching fields, that is, fields with the same name, Access draws a line called a(n) ____________________ line between the matching fields to indicate that the tables are related.

The ____________________ is an Access tool that helps you create complex expressions.

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

When you create a query, you should follow some general guidelines for query design. What are these six guidelines?

Which aggregate function will find the client with the largest amount paid?