Totally free education on the Internet

Contact Us - Tell A Friend - Make a Donation - Free-Ed.Net Home

About this Course

IT_coverSm02.jpg (17849 bytes)

This course is intended for  both beginning and advanced Microsoft Office users. The free online textbook for this course is Sams Teach Yourself Microsoft® Office 2003 in 24 Hours. Read the Introduction.

offiste01.jpg (430 bytes) Indicates links that take you away from the Free-Ed.Net site. Use the links on these offsite pages carefully, and use the Back function on your browser to return to the assigments.

Lesson 19. Retrieving Your Data

In this lesson you will learn:

  • 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

offiste01.jpg (430 bytes) Introduction to the lesson

Reading Assignments

Read the following sections from your free online textbook:

offiste01.jpg (430 bytes) IUsing Data Filters
offiste01.jpg (430 bytes) IUsing Queries

Learning Activities

  1. Use this search box to refine and expand your understanding of new terms and concepts in the reading assignments.

Custom Search
  1. offiste01.jpg (430 bytes) Read the Summary of the lesson.
  2. offiste01.jpg (430 bytes) Test your understanding with the Q&A.


Web design and curriculum: David L. Heiserman

Copyright © 2005 SweetHaven Publishing Services
All Rights Reserved