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

To delete multiple consecutive table records:

  • Click the Record Selector to the left of the first record to be deleted, then drag the cursor up or down across multiple Record Selectors to select consecutive records.

    OR
  • Hold the Shift key and click the Record Selector field in each consecutive record to be marked for deletion.

Multiple Records Selected

  • Press the Delete key to mark the records for delete, click the Delete Record button, or choose EditDelete from the menu bar.
  • A dialog box is displayed to confirm the record(s) to be deleted. Click Yes to complete the delete operation.

    Confirm Delete Notification

Deleting records is permanent. It cannot be reversed through an Undo operation. Use caution when the dialog box is displayed to confirm the record(s) to be deleted.