Add, Edit, and Delete Records

How to Add, Edit, and Delete Records in Access

Add, Edit, and Delete Records

Add a Record

  1. Click the New Record button on the Record Navigation bar.
  2. You can also add a new record by entering it in the New record row—the last row in the table.

    Add, Edit, and Delete Records
  3. Click the Delete button on the ribbon.
  4. Click a field value in the new record and enter data as desired.
  5. As you enter data, you don’t have to click a Save button to save the information—Access automatically saves the information as you enter it.

    Press Tab to move to the next field value in a record, or press Shift+ Tab to move back to the previous field value in a record.

    Add, Edit, and Delete Records

Edit a Record

You can also make changes to the records in a table at any time.

  1. Click the field value you want to edit and make the changes.
    Add, Edit, and Delete Records

Delete a Record

You can permanently delete records that you no longer need from a table.

  1. Click the record selector next to the record you want to delete.
  2. Click the Delete button on the ribbon.
  3. Click Yes to confirm the deletion.
  4. You can also delete a record by clicking the record selector next to the record you want to delete, pressing the Delete key, and clicking the Yes button.

    Add, Edit, and Delete Records

The record is deleted from the table.

FREE Quick Reference

Click to Download