Chapter 6. Finding and Filtering Data

Finding and Filtering Data

Access 2007 provides many ways of locating individual data records within your database. You learned in Chapter 2 about sorting a datasheet, one of the simplest methods of looking something up.

In this chapter, you will learn about two other ways: using the Find feature to find a text string and using the Filter feature to show only records that match criteria that you specify.

  • Understanding Find and Replace

  • Find Data Using Find and Replace

  • Replace Data Using Find and Replace

  • Filter to Show Only Blank or Nonblank Entries

  • Filter by Selection.

  • Filter for Multiple Values

  • Using Text Filters

  • Filter by Form

  • Save a Filter As ...

Get Teach Yourself VISUALLY™: Microsoft® Office Access™ 2007 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.

Start your free trial