2012

2 Select a cell in the new record and enter a value.
3 Repeat step 2 for any additional fields.
To delete a database record
■ In the Data View window, right-click a record header (the empty square
at the left of the row) of the record that you want to delete. Click Delete
Record.
To search the Data View window for a particular value
1 Right-click a cell in the column that you want to search. Click Find.
2 Enter a value to search for in Find What.
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.
2014 | Chapter 39 Access External Databases