Access Unit B

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

The datasheet of a query is sometime called a logical view of the data b/c 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.

Used to build a query to display a few fields

The window in which you develop 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 of filtering records in a database of form, or when building a query.

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

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

The bottom pane of the Query Design View window in which you specify the fiels, 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 currently selected.

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

Criteria placed in the same row of the query design grid.

Rules by which criteria beed to be entered