To create an UPDATE statement:
On the Start page, click Update.
On the Tables page, select the table in which you want to change a row.
On the Update page, enter column values for the row that will be updated. If you do not want to change a particular column value, leave the Value field for that column blank.
On the Conditions page, specify the search conditions that indicate which rows will be updated.
On the Review page, verify the statement that was created.