- A method of selecting or organizing records in a database.
A simple query might sort records into alphabetic or numeric order
based on one or more fields. Another simple query filters the
records to show only those that match certain criteria, like LastName = Smith or NumberSold > 25.
The Design View shows a grid with columns for each field in the
query results. The Datasheet View is shows records in rows. Only
the chosen fields for the records that match the query's criteria
appear in the datasheet.
- Query Builder
- A design window for queries that opens from the Record Source
property in the Properties dialog for a form or report. The query
constructed can be saved as a new query or just saved as an SQL
statement with the form or report.