Delete a Record

Delete a Record Manually:

• In Datasheet view, open, the table or query that contains the data that you want to delete.
• Locate the record (the row) that you want to delete, and then click the Select All button — the square located at the left or right end of the record. You can select individual rows, or click and drag to select a contiguous set of rows, or press CTRL and click the mouse button to select multiple non-contiguous rows.Access places a border around the entire record (the entire row) or block of selected records.
• Press DELETE.-or-

  On the Home tab, in the Records group, click Delete.

  

  -or-

  Right-click the Select All button and click Delete Record.

  If you can’t click the Select All button, position the cursor in a field in the record. Then, on the Home tab, in the Records group, click the down arrow next to Delete and click Delete Record.

• When Access prompts you to confirm the deletion, click Yes.