Page 3 of 9PREVNEXT

Queries I: Get started with queries

Types of queries you can create in Access


Access provides several types of queries.

Callout 1 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.
Callout 2 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.
Callout 3 A cross-tab query uses row headings and column headings so you can see your data in terms of two categories at once.
Callout 4 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.
Callout 5 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.

Page 3 of 9PREVNEXT