Unit B Key Terms

An Access object thatprovides a spreadsheet-like view of the data, similar to that in tables.

The datasheet of a query is sometimes called a logical view of the data because it is not a copy of the data, but rather, a selected view of data from the underlying tables.

A language that provides a standardized way to request information from a relational database system.

Prompts you for information needed to create a new query.

The window in which you develope queries by specifying the fields, sort order, and limiting criteria that determine which fields and records are displayed in the resulting datasheet.

Entries (rules and limiting conditions) that determine which records are displayed when finding or filtering records in a datasheet or form, or when building a query.

A list of the available fields in the table or query that the field list represents.

The line identifying which fields establish the relationship between two related tables

The bottom pane of the Query Design View window in which you specify the fields, sort order, and limiting criteria for the query

The button to the left of a field in Table Design View that indicates which field is

A way to filter records for an exact match.

A way to filter data that allows two or more criteria to be specified at the same time.

A special character used in criteria to find, filter, and query data. The asterisk (*) stands for any group of characters. For example, the criteria I* in a State field criterion cell would find all records where the state entry was IA, ID, IL, IN, or Iowa. The question mark (?) wildcard stands for only one character.

Crteria placed on the same row of the query design grid.

Rules by which criteria need to be entered.