Find and Edit Records in Access

When a table in databases contains large volumes of data, searching for a data value might take a long time. For example, you might want to find a specific value in a field of a table containing information about 500 employees.

Finding and Replacing values

  1. Open your database in Datasheet view
  2. Place the insertion point in the field that you want to performa find.
  3. Click the Find Button on the toolbar (looks like binoculars).
  4. In the Find What box, enter the text you want to find
  5. In the Look in list, verify that the name of the field is selected.
  6. In the Match list, verify that Whole Field is selected
  7. Click Find Next
  8. Click the Replace tab
  9. In the Replace With box, enter the text you want to replace
  10. Click Replace or Replace All if you want to replace all found text to the new text