Chapter 6. Sorting, Finding, and Filtering Data in Tables

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 quite useful when you use data in a table to create a mailing list or print a particular set of records.

Access also includes versatile search-and-replace facilities that enable you to locate every record that matches a value you specify and then, optionally, change that value. If you have a large table, Access's find facility enables you to quickly locate the needles in the haystacks. Search and replace often is needed when you import data from another database or a worksheet, which ...

Get Special Edition Using Access 97, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.