• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 9. Designing Queries for Jet Dat... > Creating Other Types of Queries

Creating Other Types of Queries

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

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

  • 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 queries create new database tables from query tables or make major alterations to a table. Such queries let you add or delete records from a table or make changes to records based on expressions that you enter in a query design.

  • Parameter queries repeatedly use a query and make only simple changes to its criteria. The mailing list query that you created earlier is an excellent candidate for a parameter query because you can change the criterion of the Region field for mailings to different groups of customers. When you run a parameter query, Access displays a dialog to prompt you for the new criterion. Parameter queries aren't actually a separate query type because you can add the parameter function to select, crosstab, and action queries.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint