Add or edit data

Microsoft Office Access 2003

ShowAdd or edit data in a datasheet or form

  1. Open a datasheet, or open a form in Form view.
  2. Do one of the following:

    To add a new record, click New Record Button image 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 Button image, 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.

ShowAdd new data in a data access page

  1. On the record navigation toolbar, click New Button image.

    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.
  2. Type the data you want in the first field, and then press TAB to go to the next field.
  3. 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 Button image on the record navigation toolbar.

ShowEdit data in a data access page

  1. 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.

  2. Type the text you want to insert.
  3. 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 Button image on the record navigation toolbar.