Exam 12: Access_Module_2

Less than (<), greater than (>), and NOT (not equal to) are examples of ____.

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

To use the Report Wizard to create a report for a query, select the query in the Navigation Pane, click ____ on the ribbon, and then click the Report Wizard button.

You cannot create a report for a query.

When you enter text data in a criterion, you must enclose the text in quotation marks.

In ____________________ files, the width of any field is the same on every record.

To combine criteria with ____________________, place the criteria on the same row.

The ____ operator allows you to search for a range of values in one field.

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

In fixed-width files, each record is on a separate line and the fields are separated by a special character.

The ____________________ wildcard represents any individual character.

Case 2-2 PrattLast Associates needs to find the account managers whose start date is earlier than 1/1/2015. -What criteria should PrattLast enter in the Start Date column of the design grid?

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

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

A(n) ____________________ is a window containing the various properties of the object.