A
bit about Microsoft Access
A
select query is the most common type of query.
You use it to:
Retrieve
data from one or more tables by using criteria
you specify and then display the data in the
order you want.
Update
records in the datasheet of a select query
(with some restrictions).
Group
records and calculate sums, counts, averages,
and other types of totals.