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

Chapter 6. Locating Specific Information... > Understanding Types of Queries

Understanding Types of Queries

Access offers several types of queries that help you retrieve the information you need—select queries, crosstab queries, action queries, and parameter queries.

  • A select query retrieves and displays records in the Table window in Datasheet view.

  • A crosstab query displays summarized values (sums, counts, and averages) from one field in a table, and groups them by one set of fields listed down the left side of the datasheet and by another set of fields listed across the top of the datasheet.

  • An action query performs operations on the records that match your criteria. There are four kinds of action queries that you can perform on one or more tables: delete queries delete matching records; update queries make changes to matching records; append queries add new records to the end of a table; and make-table queries create new tables based on matching records.

  • A parameter query allows you to prompt for a single piece of information to use as selection criteria in the query. For example, instead of creating separate queries to retrieve customer information for each state in which you do business, you could create a parameter query that prompts the user to enter the name of a state, and then continues to retrieve those specific records from that state.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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