- Opening and Closing a Table in Datasheet View
- Entering Data in a Table
- Displaying Records
- Creating a New Record
- Selecting an Entry
- Selecting Records and Columns
- Freezing and Unfreezing Columns
- Hiding and Unhiding Columns
- Resizing Columns
- Rearranging Columns
- Editing a Record
- Deleting a Record
- Copying an Entry
- Copying an Entire Record
- Sorting Records in Datasheet View
- Finding Data
- Replacing Data
- Formatting the Datasheet
- Changing the Font
- Checking Spelling
- Previewing and Printing a Table
Replacing Data
-
Click anywhere in the field, or column, that contains the entries you want to replace.
-
Open the Edit menu and choose Replace.
-
The Find and Replace dialog box opens with the Replace tab displayed. In the Find What field, type the entry you want to find.
-
In the Replace With field, type the entry to use as the replacement.
-
After you've made any necessary changes to the search options, click the Find Next button. (To learn more about the various search options, see the preceding task.)
-
Access locates and selects the record with the first matching entry. To replace it, click the Replace button.
-
The replacement is made. Access moves to the next match; continue making replacements as needed.
-
Access notifies you when no more matches are found. Click OK.