To add one record to a table, you must use the field list to define which fields to put the data in, and then you must supply the data itself in a value list. For example, the following statement will insert the values "1", "Kelly", and "Jill" into the Customer ID, Last Name, and First Name fields, respectively.
The UPDATE statement can modify one or more records and generally takes this form: To delete the data that is currently in a table, you use the DELETE statement, which is commonly referred to as a delete query. The DELETE statement can remove one or more records from a table and generally takes this form: The DELETE statement does not remove the table structure—only the data that is currently being held by the table structure.
I have been trying to learn about VBA, and SQL but I am out of time essentially.
Here's my question, does access have a way of adding/appending data from a query form to a table?
In general data may be updatable, updatable under certain conditions, or not updatable at all.
Please read the Microsoft KB article link provided at the conclusion of this tutorial.