In Access tables are arguably the most important object. Use tables in Access to store all of your data to run queries and reports.
To quickly edit any record within a table, you can click it and type your changes. However, Access offers you the ability to find and replace a word within multiple records and delete records entirely.
To replace a word within a record:
You can edit multiple occurrences of the same word by using Find and Replace, which searches for a term and replaces it with another term.
- Select the Home tab, and locate the Find group.
- Select the Replace command. The Find and Replace dialog box will appear.
- In the Find What: field, type the word you want to find, then in the Replace With: field type the word you want to replace the original word. In our example, we'll find instances of the word Fall and replace it with Autumn.
- Click the Look In: drop-down arrow to select the area you want to search. Select Current Field to limit your search to the currently selected field. Select Current Document to search within the entire table.
- Click the Match: drop-down arrow to select how closely you'd like results to match your search. Select Any Part of Field to search for your search term in any part of a cell. Select Whole Field to search only for cells that match your search term exactly. Select Beginning of Field to search only for cells that start with your search term.
- Click Find Next. If the text is found, it will be selected.
- Review the text to make sure you want to replace it. Click Replace to replace the original word with the new one.
- Access will move to the next instance of the text in the object. When you are finished replacing text, click Cancel to close the dialog box.
The Replace All option is powerful, but it may actually change some things you don't want to change. In the example below, the word fall did not refer to the season, so replacing it with Autumn would be incorrect. Using the normal Replace option allows you check each instance before replacing the text. You can click Find Next to skip to the next instance without replacing the text.
To delete a record:
- Select the entire record by clicking the gray border on the left side of the record.
- Select the Home tab and locate the Records group.
- Click the Delete command.
- A dialog box will appear. Click Yes.
- The record will be permanently deleted.
The ID numbers assigned to records stay the same even after you delete a record. For example, if you delete the 205th record in a table, the sequence of record ID numbers will read ... 204, 206, 207 ... rather than ... 204, 205, 206, 207 ...