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.
