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

Chapter 5. Working with Queries

Chapter 5. Working with Queries

Queries are tools built from fields in your tables or in other existing queries that you can use to ask questions about the contents of your database. You can use queries to find records within a single table, and also to combine the contents of several related tables into a single, easy-to-read object.

You can do more than simple record-finding with queries, including performing calculations like finding sums, averages, and even standard deviations in your queries. These calculations can make your results more meaningful and easier to read.

The results of a query are called a dynaset, short for "dynamic set" of records. The collection is dynamic because it changes when the query changes—such as when you pull data from different fields or perform different calculations on your results. These changes, however radical, don't affect the data in the source tables or queries.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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