GCFLearnFree.org

Great information, simple language, and all for free.”

Online Learner

GCFGlobal.org
Creating Opportunities For A Better Life.®
  • All Topics
  • Access XP
  • Finding Records

Access XP

Single page view print copy

Finding Records

Performing a Simple Find

When you have an extremely large database consisting of thousands of records, you may need to quickly locate one of them. Access provides an easy way to find individual records: the Find function.

To use the Find Function:

  • Click anywhere in the field that contains the data you want to search (e.g., Last Name).
  • Choose EditFind on the menu bar or click the Find button on the toolbar to open the Find and Replace dialog box.
  • In the Find What field, type the information you want to search. It may be a last name (e.g., Manning) or a portion of the last name (e.g., Man).

    Find and Replace Dialog Box
  • The Look In drop-down box defaults to the field or column where the cursor was positioned when the Find was initiated. You can leave the definition as is if you know the information is contained in this field, or you can select search the entire table from the drop-down menu list.

    Look In Field
  • In the Match field, Access defaults to Whole Field but you can optionally select either Any Part of Field or Start of Field.

    Match Field
  • Click the Find Next button to search for the first occurrence of a record that matches the search.

    Found Record
previous next
previous 1 2 3 4 5 next
Terms Of Use

©1998-2014 Goodwill Community Foundation, Inc. All rights reserved.

Cancel