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

Chapter 8. Using Query by Example > Creating Other Types of Queries

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 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 are not 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