Select query is common type of query that retrieves data from one or more tables and displays the result in a datasheet without changing the data. It can also be used to group records and calculate sums, counts and average, minimum, and maximum.
A select query can be used to:
- View subset of records.
- Retrieve data from one or more tables.
- Display the result in a datasheet.
- Update the records from within the datasheet.