How It Works

In the preceding example, you created a new view by starting with a SQL statement. Microsoft Access then updated the designer to display the table and grid to graphically represent the SQL statement. The SQL statement selects the ProductName, ProductDesc, and UnitPrice fields from the tblProducts table.

Figure 9.23

vwProductPrice : View

Pro duct Name

ProductDesc

UnitPrice

A

ABC Co Wireless Spe

Indoor Outdoor wireless speakers s

$129.00

XYZCo Marble Table

Marble patio table 54 inches round

$1 350 00

=

XYZCo Umbrella

Umbrella for patio table creme cok

5199.50

' —

XYZCo Umbrella

Umbrella for patio table, yellow cok

$199 50

XYZCo Umbrella

Umbrella for patio table cireen cclo

$199.50

XYZ Co Patio Chair

Patio chair swivel

$399 99

-

Record: H \

i:_M!H >*| fcUl af'6

Figure 9.24

0 0

Post a comment