how to save a record on the access database with out using marco?

Answer 1

Using Access open a Table and view it, note the last row in the display has an asterisk (*). Enter your data into this row placing valid data into each required field (column). To save this information just click or arrow to a different row. The information is saved to the database the moment the new row looses focus. There isn't a specific save button to press.

This saving of data also goes for updating of data, the changes are preserved (saved) the moment that data row looses focus.

To abort adding a new row you must press the ESC key BEFORE you move out of that row otherwise you will have to delete the row in the usual manner. Also edits may be aborted the same way (ESC key) before loosing focus.

Once you move to a different row the adds or changes are preserved.