Home | Syllabus | Access | Excel | Visual Basic | Research
Access
02-05-07
| Dealer's Last Name | Car Brand | Car Modle | Dealer's Frist Name | Color | Plate # | Price | In Stock | Dealer # |
|---|---|---|---|---|---|---|---|---|
| Chen | Honda | Civic Si | Andy | White | Jih 253 | $90,000.00 | Yes | B100 |
| Chen | BMW | 325 i | Andy | Red | PHJ 625 | $25,000.00 | Yes | B100 |
| Chen | Honda | Civic Si | Andy | Black | Cjk 623 | $10,000.00 | Yes | B100 |
Query 1: Select Query
SELECT cars.[Dealer's Last Name],
cars.[Car Brand], cars.[Car Modle], cars.[Dealer's Frist Name], cars.Color,
cars.[Plate #], cars.Price, cars.[In Stock], cars.[Dealer #]
FROM cars
WHERE (((cars.[Dealer's Last Name])=[Enter Dealer's Last Name]));
Sort Price > 10000
| Dealer's Last Name | Car Brand | Car Modle | Dealer's Frist Name | Color | Plate # | Price | In Stock | Dealer # |
|---|---|---|---|---|---|---|---|---|
| Chen | Honda | Civic Si | Andy | White | Jih 253 | $90,000.00 | Yes | B100 |
| Chen | BMW | 325 i | Andy | Red | PHJ 625 | $25,000.00 | Yes | B100 |
| Philies | Acura | MDX | John | Siler | hdg 362 | $25,000.00 | Yes | B102 |
| Philies | Lexus | IS350 | John | White | Lik 256 | $30,000.00 | Yes | B102 |
| Zheng | Lexus | IS350 | Yu | Red | dgd 396 | $35,000.00 | Yes | B104 |
Query 1: Select Query
SELECT cars.[Dealer's Last Name],
cars.[Car Brand], cars.[Car Modle], cars.[Dealer's Frist Name], cars.Color,
cars.[Plate #], cars.Price, cars.[In Stock], cars.[Dealer #]
FROM cars
WHERE (((cars.Price)>10000));