Special Edition Using Microsoft® Office Access 2003

Chapter 7. Sorting, Finding, and Filtering Data

In this chapter

• Understanding the Role of Sorting and Filtering

• Sorting Table Data

• Finding Matching Records in a Table

• Replacing Matched Field Values Automatically

• Filtering Table Data

• Applying Advanced Filters and Sort Orders

• Customizing Table Datasheet View

• Copying, Exporting, and Mailing Sorted and Filtered Data

• Troubleshooting

• In the Real World—Computer-Based Sorting and Searching

Understanding the Role of Sorting and Filtering

Microsoft Access provides a variety of sorting and filtering features that make customizing the display data in Table Datasheet view a quick and simple process. Sorting and filtering records in tables is useful when you use data to create a mailing list or print a particular set of ...