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

Part VI: Tracking with Access 2002 > Retrieving Your Data

Hour 20. Retrieving Your Data

This hour teaches you about Access 2002 filters and queries. Although your database contains a lot of data, you rarely want to see all that data simultaneously. Generally, you want to see only data subsets. Filters and queries produce those subsets for you.

When you view data subsets, you prevent unwanted data from getting in the way of the information with which you need to work. The power of queries is that you can select records and fields from multiple tables and view that selected data subset from within a single Datasheet or Form view.

The highlights of this hour include the following:

  • What a filter is

  • Why you sometimes use Filter by Selection and sometimes use Filter by Form

  • When a filter limits you

  • Why queries are more robust than filters

  • How to use the query wizards

  • How to use the Query Design view to create and edit queries

  • Where to specify advanced selection criteria


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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