how to use update command in query design view code example
Example: sql access UPDATE
UPDATE Orders SET OrderAmount = OrderAmount * 1.1, Freight = Freight * 1.03
WHERE ShipCountry = 'UK';
UPDATE Orders SET OrderAmount = OrderAmount * 1.1, Freight = Freight * 1.03
WHERE ShipCountry = 'UK';