Exam 4: Access: Querying a Database

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

To save validation rules, default values, and formats, click the Save button on the ____ to save the changes.

The wildcard symbols for use with filters are ____.

Unless you specify otherwise, Access assumes that the criteria you enter involve equality (exact matches).

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.

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.

The question mark (?)wildcard represents any individual character.

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

A parameter query calculates a statistic for data that is grouped by two different types of information.

To change a query so that each item in a multivalued field occurs on a different row, use the ____ property.

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

A question that is asked of Access or any other database management system is called a(n)____________________.

When you use Advanced Filter/Sort to filter records using complex criteria, create the filter and then click the ____ button on the Home tab to view the results.

To find all clients whose amount paid is greater than $1,000.00 or whose business analyst is analyst 11, enter each criterion on the same line.

You cannot preview the data to be deleted in a delete query before actually performing the deletion.

In the accompanying figure, the Client table was added to the query by selecting the table and clicking the Add button in the ____ dialog box.