VIEW, then click OK. In the SHOW TABLE dialog box, click on PRODUCT table, then click
ADD, then click CLOSE. On the toolbar, click on the arrow on the QUERY TYPE button (see
diagram below)
The screen shot of the Update Query (in Design View) that will change/update all of the prices of records in the Product table where the price field is 7.99. It will change/update the 7.99 price to the new price of 8.49.
To create the update query, click on QUERY tab, then click NEW button,
then click DESIGN
VIEW, then click OK. In the SHOW TABLE dialog box, click on PRODUCT
table, then click
ADD, then click CLOSE. On the toolbar, click on the arrow on the QUERY
TYPE button (see
diagram below)
Click on the UPDATE QUERY option. Now your screen should look like the
one below. Enter
PRICE field, PRODUCT table, type in 8.49 in the UPDATE TO text area,
type in 7.99 in the
CRITERIA text area, then run the Query by clicking on the RED EXCLAMATION
POINT.
