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.

« »