Update functions are used to add, change or delete records once the record has been displayed or selected on the form currently displayed.
A - Add - The Add function is used to add a record to the form displayed. Click the mouse on the Add button or type A on the keyboard. A blank form will display and the cursor will display in the first entry field. Enter the new record information and press Tab to move through the fields on the form. Press Enter and the new record will be added to the table.
C - Change - The Change function is used to change data for the record displayed. Click the mouse on the Change button or type C on the keyboard. The cursor will be placed under the first entry field. Press Tab to move through the fields and change the data. Press Enter and the record will be updated in the table. The option to "undo" any change can be used before Enter has been pressed. Press ESC and the original data will be displayed.
Note: The mouse can be used to position the cursor into the field to be changed by clicking on the field name on the form. Make the change(s) and press Enter or click on the Change button to update the record.
D - Delete - The Delete function is used to delete the record currently displayed. Select the record to delete. Click the mouse on the Delete button or type D on the keyboard. A message will display verifying the deletion of the current record. To delete the record click the mouse on the Yes button. Any reference to this record in any related table will display an error message and stop this record from being deleted.
NOTE: This is due to ACCESS enforcing referential integrity.