Log In

Interactive Tutorial

How to Add a New Record in Access

Easily enter and save new records using forms or datasheets in Access

  • Learn by Doing

  • LMS Ready

  • Earn Certificates

Users love us
4.9 stars out of 5 on G2

4.9 rating out of 5 on G2

Try this Course with a Free Trial

Interactive Tutorial

Practice live in your browser. No software required.

Try It Now

Access Basic to Advanced Course

5 Hour Course Certificate

View Course
How to Add a New Record in Access

Add a Record

  1. Click the New Record button on the Record Navigation bar.

    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
  2. Click the Delete button on the ribbon.
  3. Click a field value in the new record and enter data as desired.

    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.

    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.