Interactive Tutorial
How to Add, Edit, and Delete Records in Access
4.9 out of 5 on G2
Practice live in your browser. No software required.
5 Hour Course Certificate
Free quick tips and shortcuts to use and share.
Step-by-step instructions with screenshots.
You can also add a new record by entering it in the New record row—the last row in the table.
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.
You can also make changes to the records in a table at any time.
You can permanently delete records that you no longer need from a table.
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.
The record is deleted from the table.