Updating fields in access
To avoid being prompted when you run such queries, on the Tools menu, click Options, then click the Edit/Find tab. Then do one or more of the following: To see which fields will be updated by the query, see the names in the Field row in the design grid.The Table row shows the name of the table that contains the field.Using the procedure discussed in the tutorial, a Test Product Qry was created using the following SQL View of the Make Table query.Test Product Qry The above query was run which created the Test Products table.This tutorial shows various ways you can update the record in a single table.
Creating the table used in the tutorial In a previous article on action queries, the Make Table query was discussed.You may run the Update Query you created by double clicking its icon.This immediately brings up the message window, letting you know about the changes that are going to be made.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).
The modification takes place immediately so that you can come back and verify.
The displayed data access page is shown in the next picture. Action queries are used to make changes to a large number of records with a single click.