Home | Syllabus | Access | Excel  | Visual Basic | Research

                                                                            

                             Access

Cars
Car Brand Car Model Dealer's Last Name Dealer's First 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
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
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

 

 

 

                                                               Query

 

 

Query1
Dealer's Last Name Car Brand Car Model Dealer's First 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

Query1
Dealer's Last Name Car Brand Car Model Dealer's First 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));

 

                                                                                                   Forms

cars
Car Brand Car Model Dealer's Last Name Dealer's First Name Color Plate # Price In Stock Dealer #
Honda Civic Si Chen Andy Black Cjk 623 $10,000.00 -1 B100
Lexus IS350 Zheng Yu Red dgd 396 $35,000.00 -1 B104
Jeep compass Zheng Yu Black dsg 265 $9,000.00 -1 B104
Acura MDX Philies John Siler hdg 362 $25,000.00 -1 B102
Honda Civic Si Chen Andy White Jih 253 $90,000.00 -1 B100
Lexus IS350 Philies John White Lik 256 $30,000.00 -1 B102
BMW 325 i Chen Andy Red PHJ 625 $25,000.00 -1 B100

 



 

Hosted by www.Geocities.ws

                                                        Reports

 

  Dealer1

  Dealer_Dealer's Last   Chen                                 State                          MA

  Dealer_Dealer #          B100                                 Zip                                         35674

  Address                     185 Haravrd Streest

  City                           Boston

                   Car Brand        Car Modle        cars_Dealer's  Dealer's Frist    Color               Plate #                          Price  In                    cars_Dealer #

                   Honda              Civic Si             Chen                Andy               Black               Cjk 623                    $10,000.00                   B100

                   BMW              325 i                Chen                Andy               Red                 PHJ 625                   $25,000.00                   B100

                   Honda              Civic Si             Chen                Andy               White               Jih 253                     $90,000.00                   B100

  Dealer_Dealer's Last   Philies                                State                          CA

  Dealer_Dealer #          B102                                 Zip                                         98989

  Address                     533 Vice Blvd

  City                           Santa Monica

                   Car Brand        Car Modle        cars_Dealer's  Dealer's Frist    Color               Plate #                          Price  In                    cars_Dealer #

                   Lexus               IS350               Philies              John                White               Lik 256                    $30,000.00                   B102

                   Acura               MDX               Philies              John                Siler                 hdg 362                    $25,000.00                   B102

  Wednesday, February 21, 2007                                                                                                                                Page 1 of 2


 

  Dealer_Dealer's Last   Zheng                                State                          NY

  Dealer_Dealer #          B104                                 Zip                                         12000

  Address                     85 Wall Street

  City                           New York

                   Car Brand        Car Modle        cars_Dealer's  Dealer's Frist    Color               Plate #                          Price  In                    cars_Dealer #

                   Lexus               IS350               Zheng               Yu                   Red                 dgd 396                    $35,000.00                   B104

                   Jeep                 compass            Zheng               Yu                   Black               dsg 265                      $9,000.00                   B104

 

 

 

1