2011

3 Select a direction to search the Data View window:
■ Up. Searches the column records from the selected cell through the
first record.
■ Down. Searches the column records from the selected cell through
the last record.
4 Click Find Next.
5 Repeat step 4 to find additional occurrences of the specified value.
NOTE The Find option limits its search to records contained in the same column
as the currently selected cell. There is no way to issue a global Find 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 Find.
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:
■ Click Replace to replace the current occurrence of the search value.
■ Click Replace All to replace all occurrences of the search value.
6 Repeat steps 4 and 5 to replace additional occurrences of the value you're
searching for.
NOTE The 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.
To commit Data View window editing
■ In the Data View window, right-click the empty, top-left square of the
database table. Click Commit.
Edit Data in a Database Table | 1879