Updating ms access table
Forms can contain any number of controls such as lists, text boxes, and buttons.
In turn, each of the controls on the form either reads data from or writes data to an underlying table field.
This action query will take the Purchase Price values from tbl Albums Updated and copy it into the Purchase Price field in tbl Albums for each record where the two Album ID fields match and the price value in tbl Albums is currently null.
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).
Finally, you can delete a record when it is no longer relevant and to save space.
A Microsoft Access Update Query updates specified values in a table for all records or for those records that match a specified criteria.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.The trick is to join the two tables using a common field and to properly specify the name of the field from the source table in the Update To cell.You’ve imported a table that contains updated prices for some of the records in a table in your database.The data in all the other fields in the existing table is still correct.