Access provides several types of queries.
A select query
retrieves data from one or more of the tables in your database, or other queries there, and displays the results in a datasheet. You can also use a select query to group data, and to calculate sums, averages, counts, and other types of totals.
A parameter query
is a type of select query that prompts you for input before it runs. The query then uses your input as criteria that control your results. For example, a typical parameter query asks you for starting high and low values, and only returns records that fall within those values.
A cross-tab query
uses row headings and column headings so you can see your data in terms of two categories at once.
An action query
alters your data or your database. For example, you can use an action query to create a new table, or add, delete, or change your data.
An SQL query
is a statement you write in Structured Query Language, or SQL. SQL is an advanced way to query, update, and manage relational databases. Access creates an SQL statement whenever you build a query. You can view that SQL code at any time, or write your own, and you'll get a chance to view some code during the practice.
For more information about crosstab, action, and SQL queries, see the links in the Quick Reference Card.