Query+Types



****
Microsoft Access supports many types of queries. Here is a description of the major categories: > Retrieve records or summaries (totals) across records. Also includes cross-tabulations. > Similar to Select queries but results are placed in a new table. > Similar to Select queries but results are added to an existing table. > Modify data in the records. > Records are deleted from a table. Select queries are the most common queries and can be used for viewing and a data source for forms, reports, controls, and other queries. The other queries create or change data and are known collectively as Action queries.
 * **Select Queries**
 * **Make Table Queries**
 * **Append Queries**
 * **Update Queries**
 * **Delete Queries**