Query

An object where a subset of fields and records from one or more tables (or queries) are selected and presented in one datasheet. Remember that Access data is only physically stored in tables, even though it can be viewed and edited through other objects such as queries, forms, and reports. Each time a query is opened, it presents a current view of the latest updates to the database.

Field Selector

Sorting

Reorganizing records in ascending or descending order based on the contents of a field (otherwise they are organized by the data in the primary key field). To sort by MORE THAN ONE FIELD, create a query.

Filters

Will display only those records that match given criteria, but are not as powerful or flexible as queries. Queries are saved objects, while filters are temporary. CANNOT BE SAVED! They are a quick way to display data from a current datasheet.

AND Criteria

OR Criteria

Criteria placed on different rows of the query design grid are OR criteria (records may be true for EITHER row to be displayed). If additional rows of criteria are added, the number of records displayed will increase since the record needs to be true for the criteria in only ONE of the rows to be displayed!

Filters

Filters

Filters

CAN be used to select a subset of records in a datasheet. Also resulting datasheet can be used to enter and edit data. And resulting datasheet can be used to sort, filter, and find records. QUERIES can do all this too.

>

>=

<

<=

<>

Queries

They ask "questions" about data. They present the answer in a datasheet, which you can sort, filter, and format. They can be used multiple times. Each time it is opened, it displays a current view of the latest updated to the database.