Add or edit data

Add or edit data in a datasheet or form

Open a datasheet, or open a form in Form view.
Do one of the following:
To add a new record, click New Record on the toolbar, type the data, and then press TAB to go to the next field. At the end of the record, press TAB to go to the next record.
To edit data within a field, click in the field you want to edit, and then type the data.
To replace the entire value, move the pointer to the leftmost part of the field until it changes into the plus pointer , and then click. Type the data.

Notes

To correct a typing mistake, press BACKSPACE. To cancel your changes in the current field, press ESC. To cancel your changes in the entire record, press ESC again before you move out of the field.
When you move to another record, Microsoft Access saves your changes.

Add new data in a data access page

On the record navigation toolbar, click New .
Note If you don't see the New button, it means one of the following:
- The page does not support data entry.
- The designer of the page has customized the button. Look for custom instructions on how to use the page, or contact the designer.
Type the data you want in the first field, and then press TAB to go to the next field.
When you are finished adding data to each field, save the record.

Note If you make a typing mistake, press BACKSPACE. To cancel your changes in the current field, press ESC. To cancel your changes to the entire record, click Undo on the record navigation toolbar.

Edit data in a data access page

Click in the field you want to edit.
Note You cannot edit group fields and calculated fields. If you can't insert the input cursor inside any of the fields in the page, the page does not support edits.
Type the text you want to insert.
Save the record.