Deleting Records in a Table
You can delete records that are out-of-date or no longer needed. It is good practice to periodically purge your database of obsolete records.
To delete records in a table:
- With the table open in Datasheet View, select the record or records you want to delete.
- Click the Delete Record toolbar button.
- Access will warn you that you are about to delete a record and you won't be able to undo the action.
- Click Yes to finish deleting the record.
If you have an entire record selected and use the
+
command to cut the record, you are actually deleting the record. You won't be able to undo the operation or use the
Paste command to paste the record back into the table.