Creating Other Types of Queries

Access enables you to create the following four basic types of queries to achieve different objectives:

  • Select. Select queries extract data from one or more tables and display the data in tabular form.

  • Crosstab. Crosstab queries summarize data from one or more tables in the form of a spreadsheet. Such queries are useful for analyzing data and creating graphs or charts based on the sum of the numeric field values of many records.

  • Action. Action queries create new database tables from query tables or make major alterations to a table. Such queries enable you to add or delete records from a table or to make changes to records based on expressions that you enter in a query design.

  • Parameter. Parameter queries repeatedly ...

Get Special Edition Using Access 97, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.