MS Access Update Query


MS Access Update Query

 

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.

 

MS Access Update Query

 

In the Tables tab, on the Show Table dialog box, double-click Contact Table, and then close the dialog box.

 

MS Access Update Query

 

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".

 

MS Access Update Query

 

MS Access Update Query

 

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.

 

MS Access Update Query

 

Click Yes and go to Datasheet View and you will see the first record — Company is updated to “e-siksha” now.

 

MS Access Update Query

 

Read Also:

How to Create a Table in Datasheet View

How to Create a Table in Design View