The design view of the table Test Products along with the original table is shown in the next picture. Here have been turned off by setting their values to No.When you run the form you can change the values in the various columns except the primary key field. You will be able to type the change in the text box; after you have made your edits, you just need to move to another record (movement can be forward or backward).
This is especially true if there are two or more tables involved in the update process.In general data may be updatable, updatable under certain conditions, or not updatable at all.To preview the records that will be updated, click View on the toolbar.The data as it exists before the update operation will be displayed in Datasheet view.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.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.Updating the query requires the table, the criterion for which the changes have to be made and the changes themselves.You may also look at the SQL View of the query which is shown in the next paragraph.Often to satisfy business requirements there arises a need to change some value or values in a table or tables.