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 Design View Query Datasheet View
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.