• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 1: Learning Access Fundamentals > Sorting, Finding, and Filtering Data in ...

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 is the subject of the next chapter.

Access's sorting, filtering, searching, and replacing features actually are implemented by behind-the-scenes queries that Access creates for you. When you reach Part II of this book, which deals exclusively with queries, you'll probably choose to implement these features with Access's graphical query-by-example (QBE) methods. Learning the fundamentals of these operations with tables, however, makes understanding queries easier. You also can apply filters to query result sets, use the find feature with queries in Datasheet view, and use search and replace on the result sets of updatable queries. If you're an xBase user or know SQL, statements in these two languages equivalent to the operation being performed are given where applicable.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint