Common Types of Queries
Select queries are the most common, and you will use them to select or extract specified data from your tables.
A parameter query is a type of select query that asks you to input the criteria you want used to extract data.
A crosstab query summarizes data and presents it to you in an easy-to-read table format. If your data can be numerically summarized, then a crosstab query may be appropriate.