Editing and Deleting Table Records

In Access XP editing table records is easy. In Access XP deleting table records is simple as well. Just follow these directions.

Deleting table records

One or more table records can be deleted from an Access table at any time while in Datasheet view.

To delete a table record:

  • Locate the record to be deleted.
  • Click the Record Selector to the left of the record's first field to select the entire record.

    Selected Record
  • Press the Delete key or click the Delete Record button on the toolbar.
  • A dialog box is displayed to confirm that the record is to be deleted. Click Yes to complete the delete operation.

    Confirm Delete Notification