Queries   -    Types of queries

Tables   Queries     What is a query?     Types of queries     Query design     Tutorial  Forms  Reports  Macros  Modules

Data can be displayed in so many various ways to illustrate the relevant information that is needed to be seen. Access has different types of queries that allow you to present your data the way you want it to look. Below is a table of the basic types of queries, including their more specific listing, and a brief description of each. Query Types and Descriptions Select Pulled data is from one or more tables and is displayed in tabular form. One or more fields are required. Crosstab Data from one or more tables that is pulled and summarized in a spreadsheet-like format. This type is good for the creation of charts and graphs. A minimum of three fields are required. Action Data is added or deleted from a table or the data is used to create a new table Make Table Table is created with the selected field data for query. New table name and one or more fields are required. Append Adds rows to the ends of tables. The table with the intended row additions as well as the field's criteria are required. Delete Removes row entries that meet the described criteria. Table name with the intended row entries to be deleted along with the field's criteria are required. Parameter Any query developed with the idea that the criteria may vary from run-to-run of the query. Requirements depend upon the type of query being run.

Access is a copyright of Microsoft, Inc. No infringement of those rights is intended. Questions or comments -- Contact the author