Edit Data in a Database Table
 
 
 

To search the Data View window for a particular value to replace

  1. Right-click a cell in the column that you want to search. Click Replace.
  2. Enter a value to search for in Find What.
  3. Enter a replacement value in Replace With.
  4. Click Find Next.
  5. Do one of the following:
  6. Repeat steps 4 and 5 to replace additional occurrences of the value you're searching for.
NoteThe Replace option limits its search to records contained in the same column as the currently selected cell. There is no way to issue a global Replace command that searches the entire database table for a specific value. You must select individual cells in any additional columns you want to search, and then click Replace again.