Access 2010 In Pictures

Create Update queries

1 Open the Products table.

Note the price (to customers) of French Truffles ($8.99) and Blue Mountain Coffee ($9.99).

Note the cost (to the store) of French Truffles ($6.15) and Blue Mountain Coffee ($8.00).

2 Close the Products table.

3 Make sure the Create tab is selected.

In the Ribbon, click Query Design.