You can use an MS Access Update Query to change data in your tables, and you can use an update query to enter criteria to specify which rows should be updated. Update query gives you an opportunity to review the updated data before updating.
Let's go back to the Create tab in Microsoft Access and click on Query Design.
In the Tables tab, on the Show Table dialog box,
double-click Contact Table, and then close the dialog box.
On the Design tab, in the Query Type group, click
Update and double-click the field in which you want to update the value. Let's say we want to update the Company of "e-siksha" to "tycto".
In the Update row of the Design grid, enter the updated value, and in the Criteria row add the original value you want to update and run the query. It will display the confirmation message.
Click Yes and go to Datasheet View and you will see the first record — Company is updated to