O'Reilly logo

Special Edition Using Access 97, Second Edition by Roger Jennings

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required