Editing and Deleting Table Records
Information in a record is likely to change over time, when someone moves from one address to another, or when someone else changes his or her phone number. Information can be changed in any field of any table record.
Sometimes you will need to change the entire contents of a field, like if someone has a new address. In Access, you can select an entire field for editing:
Warning! When attempting to edit an entire field, be careful not to move the mouse pointer so far to the left that you click on the Record Selector (the pointer will change to an arrow pointing right) and select the entire record. In Access, you cannot edit fields when the entire record is selected.
Saving your work: Unlike Word, Excel, and PowerPoint applications, you will not be prompted to save the data you entered when you exit the screen or close the application. In Access, each record is saved automatically when you move to another record.