Microsoft Access Query Tips and Techniques
Query Types
Microsoft Access supports many types of queries. Here is a description of the major categories:
- Select Queries
Retrieve records or summaries (totals) across records. Also includes cross-tabulations. - Make Table Queries
Similar to Select queries but results are placed in a new table. - Append Queries
Similar to Select queries but results are added to an existing table. - Update Queries
Modify data in the records. - Delete Queries
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.
http://www.fmsinc.com/tpapers/queries/index.html#Query%20Types
Leave a Reply
You must be logged in to post a comment.