Synopsis
Access 2000 MOUS: Sorting and Filtering shows users how to find filter and sort records in Access 2000.

Audience
This course is for anyone preparing for the MOUS Access 2000 Core certification exam.

Time
3 hours

Product Code: A2KM04
After completing Access 2000 MOUS: Sorting and Filtering the user should be able to:

Sort records
Create advanced sorts
Search for records
Apply and remove filters

Sorting Records
Using the Sort feature
Freezing columns

Using Advanced Sorts
Creating advanced filters/sorts
Using the Advanced Filter/Sort window
Selecting sort fields
Applying advanced sorts

Finding Records
Using the Find feature
Using the Replace feature

Applying and Removing Filters
Filtering by selection
Filtering by form

This course has the following features:

Exercises that allow users to practice in Access 2000
A file containing the text of the exercises
Simulations that allow users to practice course skills even if they don't have access to Access 2000
A glossary
A Skill Assessment

Office 2000: Getting Started (O2KC01)
Office 2000: Editing Text and Printing (O2KC02)
Office 2000: Text and Document Formats (O2KC03)
Office 2000: Introduction to Access (O2KC08)
Access 2000 MOUS: Creating Databases (A2KM01)
Access 2000 MOUS: Building Tables (A2KM02)
Access 2000 MOUS: Modifying Tables (A2KM03)

Microsoft® is a registered trademark of Microsoft Corporation.

Access® is a registered trademark of Microsoft Corporation.

Microsoft and the Microsoft Office User Specialist logo are registered trademarks of Microsoft Corporation in the United States and other countries.