COURSE OUTLINE
MICROSOFT ACCESS 2000 INTERMEDIATE
I.
RETRIEVING DATA
a. b. Sorting and Selecting Data—Page 164 Using the Sort Commands 1. Sorting a Table c. Filtering Your Data—Page 166 1. Using the Filter By Selection Method 2. Using the Filter By form Method 3. Selecting Records in Filter by Form 4. Filtering for Records that Meet One of Several Values 5. Filtering for Records that Meet Multiple Criteria 6. Using Filter For Input 7. Using Advanced Filter/Sort 8. Setting Up an Advanced Filter/Sort 9. Filtering Records within a Range d. Designing Basic Queries—Page 177 1. Setting Up a Simple Query 2. Using the Query Design 3. Modifying ans Saving a Query 4. Hiding the State Field and Naming the Query 5. Adding and Deleting Fields in Query Design View 6. Editing Data in a Query 7. Using Help: Learning about Other Types of Queries
03/05/2009
1
e.
Querying Multiple Tables—Page 183 1. Building a Multi-Table Query 2. Creating Selection Criteria from Two Tables 3. Querying for Blank Data
f. g.
Creating Hyperlinks—Page 188 Lesson Summary and Exercises
II.
Intermediate Evaluation
HANDS-ON—PROJECT IN PROGRESS
03/05/2009
2