Future articles will consider cases where more than one table may be involved.
you will get another message from the program letting you know how many rows are going to be modified as shown.Now when you click on the Yes button one more time the changes will be made to the table as shown in the next picture.Test Product Qry The above query was run which created the Test Products table.After the table was created a primary key was added so that a form and data access page based update can be described. If you right click the little black rectangle at the top left corner, you can access the form’s properties as shown.The modification takes place immediately so that you can come back and verify.
Based on the form you may also create a data access page as shown, using which you can update as well. It is clear that the data is updatable; the recordset is an updatable snapshot.
The value that exists before the Update Query is executed is shown in the next picture .
After making entries, when you try to close the query editor, you will be asked whether you want to save and you may give a name to the query.
Microsoft Access offers a variety of options for making updates to records.
Updating the data from a query in MS Access (MDB) may not always be possible.
This is especially true if there are two or more tables involved in the update process.