Updating tables in access
When the Show Table window appears, select the tables that you wish to use in the query and click on the Add button.
You can select multiple tables by holding down the Update Query from the popup menu.
To add new records to a database you use an append query, and to delete whole records from a database you use a delete query.
Note: You cannot run an update query in a Web browser.
In turn, those design principles affect how you enter data.
To modify the data that is currently in a table, you use the UPDATE statement, which is commonly referred to as an update query.
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.
Read this section if you are new to Access or unfamiliar with the concepts behind relational databases.
Large updates become much easier to perform when you understand some of the basic principles of database design.