Editing Records in a Table


Everyone makes mistakes when entering data. Sometimes data will change. You can always go back and edit records. In this task, we'll locate a specific record number and edit the data.



To edit records in a table:

  1. With the table open in Datasheet View, go to the record you want to enter.
  2. If you are changing data in a text field, select the text. Type the new text to overwrite the old entry. Press Tab or Enter to accept the new data.
  3. If you want to change just part of the entry, click with the mouse to place your cursor where you want to start typing.
    1. Use the Backspace key to delete characters to the left of the cursor.
    2. Use the Delete key to delete characters to the right of the cursor.
  4. You can also change data in fields that use Lookup lists. Click the field and make a new selection from the list.


Use these same techniques to edit records in a form.

If you use Enter or Tab to move between fields, the entire contents of the field will be selected automatically. You don't have to reselect the contents to overwrite the old data. Just start typing, and you'll see that the old data is deleted automatically.