Microsoft® Access® 2010 In Depth

7. Sorting, Finding, and Filtering Data

Microsoft Access 2010 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 especially useful when you use the data to create a mailing list or print a particular set of records.

Access also includes versatile search-and-replace facilities that let you locate every record with a value that matches a value you specify and then, optionally, change that value. Using the Search features, you can quickly locate values even in large tables. Search and replace often is needed when you import data from another database or a worksheet, which is the primary subject of the next chapter. ...