Now consider the following scenario example, that will illustrate the use of a Microsoft Access Update query: One of your product suppliers has decided to increase the price of their products by 3 percent (%) across the board.You have decided that you will use an Update Query to change all of the relevant records in your Products table. 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.In Microsoft Access 2007, I'm trying to update about 6000 records from one table with values from another table, but I'm having problems. When you have finished adding your tables, click on the Close button.Actually I am trying to update the Bot table MFG with the Big table MFG when Big. In this example, we've selected the Big and Bot tables.
It is possible to update records manually in a database table, either via a form or through the tables datasheet, however this may take a very long time.As long as you leave the Update To row blank for these columns, they will be used for their criteria only and will not be updated.Update queries are the most efficient way to make bulk changes to data; they are much more efficient than using a recordset in a VBA procedure.When the query is finished, open tbl Albums again—you should see that the Purchase Price field in this table has been updated based on the values in tbl Albums Updated (see Figure 1-18).You can use update queries in Access to update the values in a target table, and you can use another table to supply the values for the update.