Home | Syllabus | Access | Excel | Visual Basic | Research
Access
| Car Brand | Car Modle | Dealer's Last Name | Dealer's Frist Name | Color | Plate # | Price | In Stock | Dealer # |
|---|---|---|---|---|---|---|---|---|
| Honda | Civic Si | Chen | Andy | Black | Cjk 623 | $10,000.00 | Yes | B100 |
| Lexus | IS350 | Zheng | Yu | Red | dgd 396 | $35,000.00 | Yes | B104 |
| Jeep | compass | Zheng | Yu | Black | dsg 265 | $9,000.00 | Yes | B104 |
| Acura | MDX | Philies | John | Siler | hdg 362 | $25,000.00 | Yes | B102 |
| Honda | Civic Si | Chen | Andy | White | Jih 253 | $90,000.00 | Yes | B100 |
| Lexus | IS350 | Philies | John | White | Lik 256 | $30,000.00 | Yes | B102 |
| BMW | 325 i | Chen | Andy | Red | PHJ 625 | $25,000.00 | Yes | B100 |
| Dealer's Last Name | Dealer # | Address | City | State | Zip |
|---|---|---|---|---|---|
| Chen | B100 | 185 Haravrd Streest | Boston | MA | 35674 |
| Philies | B102 | 533 Vice Blvd | Santa Monica | CA | 98989 |
| Zheng | B104 | 85 Wall Street | New York | NY | 12000 |
| Car Brand | Horse Power | Invoice | Engine | Fuel Econ |
|---|---|---|---|---|
| Acura | 300 | $40,000.00 | 3.0L | 20/30 mpg |
| BMW | 250 | $32,000.00 | 3.0L | 19/29 mpg |
| Honda | 160 | $21,000.00 | 2.0 L | 25/30 mpg |
| Jeep | 172 | $14,000.00 | 2.4L | 20/30 mpg |
| Lexus | 200 | $31,000.00 | 3.0L | 21/28 mpg |
