Changing Values

Learning Outcomes

  • Change values in datasheets

Changing values in datasheets is very straightforward. In this example, the phone number of Supplier 11 is being changed. The pencil icon appears to the far left of the record being edited.

There is an “Undo” in the toolbar that will roll back changes made to a record. However, after a second record is modified, Access will not allow changes to be undone to the prior saved record.

Microsoft Access spreadsheet "Supplier List". Row 11 Column "Business Phone" is selected and being edited. A pencil icon is to the left of the row ID, indicating that row 11 is being edited.

Practice Question