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

Chapter 5. Locating Specific Information > Creating a Query in Design View

Creating a Query in Design View

When you want to work with more than one table, you need to move beyond filters and into the realm of queries. The most common type of query selects records that meet specific conditions, but there are several other types, as follows:


  • A select query retrieves data from one or more tables and displays the results in a datasheet. You can also use a select query to group records and calculate sums, counts, averages, and other types of totals. You can work with the results of a select query in Datasheet view to update records in one or more related tables at the same time.

    • A duplicate query is a form of select query that locates records that have the same information in one or more fields that you specify. The Find Duplicates Query Wizard guides you through the process of specifying the table and fields to use in the query.

    • An unmatched query is a form of select query that locates records in one table that don’t have related records in another table. For example, you could use this to locate people in the customer table who don’t have an order in the order table. The Find Unmatched Query Wizard guides you through the process of specifying the tables and fields to use in the query.

  • A parameter query prompts you for information to be used in the query—for example, a range of dates. This type of query is particularly useful if the query is the basis for a report that is run periodically.

  • A crosstab query calculates and restructures data for easier analysis. It can calculate a sum, average, count, or other type of total for data that is grouped by two types of information—one down the left side of the datasheet and one across the top. The cell at the junction of each row and column displays the results of the query’s calculation.

  • An action query updates or makes changes to multiple records in one operation. It is essentially a select query that performs an action on the results of the selection process. Four types of actions are available: delete queries, which delete records from one or more tables; update queries, which make changes to records in one or more tables; append queries, which add records from one or more tables to the end of one or more other tables; and make-table queries, which create a new table from all or part of the data in one or more tables.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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