Beginner Acces Lab 2
levb92
cs1100.a3.accdb| ContactID | FirstName | LastName | Address | ZipCode | PhoneNumber |
|---|---|---|---|---|---|
| 1 | Benjamin | Lee | 1000 Call Street | 45501 | 9043274124 |
| 2 | Eleanor | Milgrom | 7245 NW 8 Street | 33063 | 3059741234 |
| 3 | Neil | Goodman | 4215 South 81 Street | 33065 | 3054445555 |
| 4 | Nicholas | Colon | 9020 N.W. 75 Street | 33065 | 3057539887 |
| 5 | Michael | Ware | 276 Brickell Avenue | 33131 | 3054443980 |
| 6 | Jeffrey | Muddell | 9522 S.W. 142 Street | 33340 | 3052533909 |
| 7 | Ashley | Geoghegan | 7500 Center Lane | 33070 | 3057537830 |
| 8 | Serena | Sherard | 5000 Jefferson Lane | 32601 | 9043756442 |
| 9 | Luis | Couto | 455 Bargello Avenue | 33146 | 3056664801 |
| 10 | Derek | Anderson | 6000 Tigertail Avenue | 33120 | 3054468900 |
| 11 | Lauren | Center | 12380 S.W. 137 Avenue | 33186 | 3053854432 |
| 12 | Robert | Slane | 4508 N.W. 7 Street | 33131 | 3056353454 |
| 13 | Jake | Smith | 12 Main Street | 10009 | 2126554432 |
| 14 | Scott | Huyler | 9 Bell Drive | 02382 | 5084474332 |
| 15 | Jordon | Sullivan | 730 Dickey Lake Drive | 55356 | 9522213654 |
| 16 | Laurie | Pachucki | 5 King Arthur Drive | 03079 | 6035556789 |
| 17 | Gilberto | Fudge | 11 Spring Street | 19008 | 2079887896 |
| 18 | Michael | Lipton | 5986 Parker Street | 01930 | 9782221313 |
| 19 | Ronald | McWilliams | 5921 North Anders Drive | 01765 | 9783347654 |
| 20 | Paul | Greenson | 133 Beechtree Road | 33139 | 3054412656 |
| 21 | Christopher | Columbus | 1492 LandFall Lane | 60098 | 3453321234 |
| 22 | Peter | TheGreat | 1785 The Castle | 01112 | 2211235432 |
| 23 | Alan | Turing | 5861 North Bennett St | 33065 | 3052341234 |
| 24 | Giancarlo | Peano | 15 Salem St | 02115 | 6174352333 |
| 25 | Franklin | Ben | 231 Freshman Lane | 44101 | 3054678907 |
| OrdID | ProdID | Quantity | UnitPrice | LineItemID |
|---|---|---|---|---|
| 1 | 13 | 1 | ¤ 23.00 | 1 |
| 1 | 14 | 4 | ¤ 9.99 | 2 |
| 1 | 27 | 1 | ¤ 115.95 | 3 |
| 2 | 1 | 1 | ¤ 1,899.00 | 4 |
| 2 | 6 | 1 | ¤ 499.00 | 5 |
| 2 | 20 | 1 | ¤ 189.95 | 6 |
| 2 | 22 | 1 | ¤ 1,395.00 | 7 |
| 3 | 5 | 1 | ¤ 2,599.00 | 8 |
| 3 | 20 | 1 | ¤ 189.95 | 9 |
| 3 | 22 | 1 | ¤ 1,395.00 | 10 |
| 4 | 3 | 1 | ¤ 2,099.00 | 11 |
| 4 | 10 | 1 | ¤ 799.00 | 12 |
| 4 | 22 | 2 | ¤ 1,395.00 | 13 |
| 5 | 3 | 2 | ¤ 2,099.00 | 14 |
| 5 | 12 | 2 | ¤ 249.00 | 15 |
| 5 | 16 | 2 | ¤ 179.95 | 16 |
| 6 | 7 | 1 | ¤ 899.00 | 17 |
| 6 | 14 | 10 | ¤ 9.99 | 18 |
| 7 | 28 | 1 | ¤ 29.95 | 19 |
| 7 | 30 | 3 | ¤ 59.95 | 20 |
| 8 | 1 | 1 | ¤ 1,599.00 | 21 |
| 8 | 4 | 3 | ¤ 2,299.00 | 22 |
| 8 | 8 | 4 | ¤ 1,599.00 | 23 |
| 8 | 11 | 2 | ¤ 1,245.00 | 24 |
| 8 | 12 | 1 | ¤ 249.00 | 25 |
| 9 | 6 | 1 | ¤ 499.00 | 26 |
| 10 | 2 | 2 | ¤ 1,999.00 | 27 |
| 10 | 22 | 1 | ¤ 1,395.00 | 28 |
| 10 | 23 | 1 | ¤ 249.95 | 29 |
| 11 | 16 | 2 | ¤ 179.95 | 30 |
| 11 | 20 | 2 | ¤ 189.95 | 31 |
| 12 | 21 | 10 | ¤ 65.95 | 32 |
| 12 | 29 | 10 | ¤ 129.95 | 33 |
| 12 | 30 | 10 | ¤ 59.95 | 34 |
| 13 | 9 | 4 | ¤ 399.00 | 35 |
| 13 | 16 | 10 | ¤ 179.95 | 36 |
| 13 | 24 | 2 | ¤ 569.95 | 37 |
| 14 | 19 | 2 | ¤ 39.95 | 38 |
| 14 | 28 | 1 | ¤ 29.95 | 39 |
| 15 | 18 | 1 | ¤ 59.95 | 40 |
| 15 | 20 | 1 | ¤ 189.95 | 41 |
| 16 | 29 | 2 | ¤ 129.95 | 42 |
| 17 | 19 | 2 | ¤ 39.95 | 43 |
| 18 | 9 | 1 | ¤ 399.00 | 44 |
| 18 | 25 | 2 | ¤ 95.95 | 45 |
| 18 | 26 | 2 | ¤ 75.95 | 46 |
| 19 | 14 | 25 | ¤ 9.99 | 47 |
| 20 | 24 | 1 | ¤ 569.95 | 48 |
| 21 | 4 | 1 | ¤ 2,299.00 | 49 |
| 22 | 27 | 1 | ¤ 115.95 | 50 |
| 23 | 21 | 1 | ¤ 65.95 | 51 |
| 23 | 28 | 1 | ¤ 29.95 | 52 |
| 23 | 29 | 1 | ¤ 129.95 | 53 |
| 24 | 7 | 1 | ¤ 899.00 | 54 |
| 24 | 13 | 5 | ¤ 23.00 | 55 |
| 24 | 14 | 3 | ¤ 9.99 | 56 |
| 24 | 16 | 1 | ¤ 179.95 | 57 |
| 25 | 12 | 2 | ¤ 249.00 | 58 |
| 25 | 29 | 2 | ¤ 129.95 | 59 |
| 26 | 4 | 1 | ¤ 2,299.00 | 60 |
| 26 | 7 | 1 | ¤ 899.00 | 61 |
| 26 | 27 | 1 | ¤ 115.95 | 62 |
| 27 | 16 | 1 | ¤ 179.95 | 63 |
| 27 | 23 | 1 | ¤ 249.95 | 64 |
| 28 | 8 | 1 | ¤ 1,599.00 | 65 |
| 28 | 11 | 1 | ¤ 1,245.00 | 66 |
| 28 | 12 | 1 | ¤ 249.00 | 67 |
| 29 | 26 | 1 | ¤ 75.95 | 68 |
| 29 | 27 | 1 | ¤ 115.95 | 69 |
| 30 | 4 | 1 | ¤ 2,299.00 | 70 |
| 30 | 7 | 1 | ¤ 899.00 | 71 |
| 30 | 11 | 1 | ¤ 1,245.00 | 72 |
| 31 | 5 | 12 | ¤ 2,599.00 | 73 |
| 32 | 2 | 2 | ¤ 1,999.00 | 74 |
| 32 | 6 | 2 | ¤ 499.00 | 75 |
| 32 | 12 | 2 | ¤ 249.00 | 76 |
| 33 | 5 | 1 | ¤ 2,599.00 | 77 |
| 34 | 14 | 12 | ¤ 9.99 | 78 |
| 35 | 15 | 12 | ¤ 14.79 | 79 |
| 36 | 8 | 2 | ¤ 1,599.00 | 80 |
| 38 | 32 | 1 | ¤ 356.00 | 81 |
| 38 | 33 | 2 | ¤ 450.00 | 82 |
| 39 | 33 | 1 | ¤ 450.00 | 83 |
| 40 | 32 | 2 | ¤ 356.00 | 84 |
| OrderID | ContactID | OrderDate |
|---|---|---|
| 1 | 4 | 4/15/99 |
| 2 | 3 | 4/18/99 |
| 3 | 6 | 4/18/99 |
| 4 | 7 | 4/18/99 |
| 5 | 1 | 4/20/99 |
| 6 | 1 | 4/21/99 |
| 7 | 2 | 4/21/99 |
| 8 | 2 | 4/22/99 |
| 9 | 1 | 4/22/99 |
| 10 | 2 | 4/22/99 |
| 11 | 1 | 4/24/99 |
| 12 | 7 | 4/24/99 |
| 13 | 4 | 4/24/99 |
| 14 | 6 | 4/25/99 |
| 15 | 9 | 4/25/99 |
| 16 | 6 | 4/26/99 |
| 17 | 11 | 4/26/99 |
| 18 | 11 | 4/26/99 |
| 19 | 12 | 4/27/99 |
| 20 | 12 | 4/28/99 |
| 21 | 10 | 4/29/99 |
| 22 | 10 | 4/29/99 |
| 23 | 8 | 4/30/99 |
| 24 | 6 | 5/1/99 |
| 25 | 6 | 5/1/99 |
| 26 | 18 | 2/2/00 |
| 27 | 13 | 3/15/01 |
| 28 | 14 | 4/21/01 |
| 29 | 14 | 5/30/01 |
| 30 | 15 | 5/2/99 |
| 31 | 16 | 8/21/01 |
| 32 | 16 | 12/15/01 |
| 33 | 17 | 3/12/02 |
| 34 | 19 | 4/23/02 |
| 35 | 20 | 9/2/02 |
| 36 | 2 | 9/15/02 |
| 38 | 23 | 2/4/98 |
| 39 | 23 | 2/4/98 |
| 40 | 24 | 3/15/99 |
| ProductID | ProductName | RetailPrice | UnitsInStock | Width | Height | Depth | Weight |
|---|---|---|---|---|---|---|---|
| 1 | Pentium II/300 MHz | ¤ 1,899.00 | 50 | 21 | 5 | 14 | 12 |
| 2 | Pentium II/350 MHz | ¤ 1,999.00 | 25 | 21 | 6 | 17 | 16 |
| 3 | Pentium II/400 MHz | ¤ 2,099.00 | 80 | 21 | 8 | 17 | 23 |
| 4 | Pentium II/450 MHz | ¤ 2,299.00 | 90 | 21 | 3 | 14 | 11 |
| 5 | Pentium II laptop/266MHz | ¤ 2,599.00 | 35 | 13 | 2 | 12 | 4 |
| 6 | 15" SVGA Monitor | ¤ 499.00 | 50 | 20 | 24 | 21 | 26 |
| 7 | 17" SVGA Monitor | ¤ 899.00 | 30 | 30 | 30 | 24 | 35 |
| 8 | 20" Multisync Monitor | ¤ 1,599.00 | 40 | 40 | 45 | 23 | 45 |
| 9 | 2.5 GB IDE Hard Drive | ¤ 399.00 | 17 | 3 | 1 | 4 | 1 |
| 10 | 2 GB SCSI Hard Drive | ¤ 799.00 | 18 | 3 | 1 | 4 | 1 |
| 11 | 4 GB SCSI Hard Drive | ¤ 1,245.00 | 19 | 3 | 1 | 4 | 1 |
| 12 | CD-ROM: 32X | ¤ 249.00 | 20 | 6 | 2 | 6 | 2 |
| 13 | DVD Disks | ¤ 23.00 | 100 | 5 | 1 | 5 | 1 |
| 14 | HD Floppy Disks | ¤ 9.99 | 100 | 5 | 1 | 5 | 1 |
| 15 | Zip Cartridges | ¤ 14.79 | 34 | 3 | 1 | 3 | 1 |
| 16 | Internal Zip Drive | ¤ 179.95 | 35 | 6 | 1 | 6 | 1 |
| 17 | Serial Mouse | ¤ 69.95 | 36 | 2 | 1 | 3 | 1 |
| 18 | Trackball | ¤ 59.95 | 37 | 4 | 2 | 4 | 2 |
| 19 | Joystick | ¤ 39.95 | 38 | 2 | 6 | 2 | 3 |
| 20 | Fax/Modem 56 Kbps | ¤ 189.95 | 220 | 5 | 1 | 6 | 2 |
| 21 | Fax/Modem 33.6 Kbps | ¤ 65.95 | 13 | 5 | 1 | 6 | 2 |
| 22 | Laser Printer (network) | ¤ 1,395.00 | 78 | 24 | 15 | 28 | 40 |
| 23 | Ink Jet Printer | ¤ 249.95 | 20 | 24 | 12 | 26 | 12 |
| 24 | Laser Printer (personal) | ¤ 569.95 | 80 | 24 | 12 | 26 | 12 |
| 25 | Windows 95 | ¤ 95.95 | 20 | 5 | 1 | 5 | 1 |
| 26 | Windows 98 | ¤ 75.95 | 100 | 5 | 1 | 5 | 1 |
| 27 | Norton Anti-Virus | ¤ 115.95 | 250 | 5 | 1 | 5 | 1 |
| 28 | Microsoft Scenes Screen Saver | ¤ 29.95 | 35 | 5 | 1 | 5 | 1 |
| 29 | Microsoft Bookshelf | ¤ 129.95 | 36 | 5 | 1 | 5 | 1 |
| 30 | Microsoft Cinemania | ¤ 59.95 | 37 | 5 | 1 | 5 | 1 |
| 31 | Professional Photos on CD-ROM | ¤ 45.95 | 38 | 5 | 1 | 5 | 1 |
| 32 | 21" Flat Panel Monitor | ¤ 356.00 | 39 | 29 | 29 | 29 | 6 |
| 33 | 24" Flat Panel Monitor | ¤ 450.00 | 40 | 36 | 34 | 36 | 8 |
| ZipCode | City | State |
|---|---|---|
| 01112 | Norsk | ME |
| 01765 | Andover | MA |
| 01930 | Gloucester | MA |
| 02115 | Boston | MA |
| 02382 | Whitman | MA |
| 03079 | Salem | NH |
| 10009 | New York | NY |
| 19008 | Broomall | PA |
| 32601 | Gainesville | FL |
| 33065 | Coral Springs | FL |
| 86002 | Flagstaff | AZ |
| 85003 | Pheonix | AZ |
| 33063 | Margate | FL |
| 33070 | Coral Springs | FL |
| 33120 | Coconut Grove | FL |
| 33131 | Miami | FL |
| 44101 | Cleaveland | OH |
| 33139 | Miami Beach | FL |
| 33146 | Coral Gables | FL |
| 45501 | Springfield | OH |
| 33186 | Miami | FL |
| 33221 | Cleveland | OH |
| 33340 | Tallahassee | FL |
| 55356 | Warwick | MN |
| 60098 | Cheswick | NC |
| 90210 | Beverly Hills | CA |
| 99801 | Juneau | AK |
| 44104 | Cleaveland | OH |
| 70342 | Patrick | KA |
