Computer science Beginner Lab
levb92
cs1100.a2.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 |
| LineItemID | OrdID | ProdID | Quantity | UnitPrice |
|---|---|---|---|---|
| 1 | 1 | 13 | 1 | ¤ 23.00 |
| 2 | 1 | 14 | 4 | ¤ 9.99 |
| 3 | 1 | 27 | 1 | ¤ 115.95 |
| 4 | 2 | 1 | 1 | ¤ 1,899.00 |
| 5 | 2 | 6 | 1 | ¤ 499.00 |
| 6 | 2 | 20 | 1 | ¤ 189.95 |
| 7 | 2 | 22 | 1 | ¤ 1,395.00 |
| 8 | 3 | 5 | 1 | ¤ 2,599.00 |
| 9 | 3 | 20 | 1 | ¤ 189.95 |
| 10 | 3 | 22 | 1 | ¤ 1,395.00 |
| 11 | 4 | 3 | 1 | ¤ 2,099.00 |
| 12 | 4 | 10 | 1 | ¤ 799.00 |
| 13 | 4 | 22 | 2 | ¤ 1,395.00 |
| 14 | 5 | 3 | 2 | ¤ 2,099.00 |
| 15 | 5 | 12 | 2 | ¤ 249.00 |
| 16 | 5 | 16 | 2 | ¤ 179.95 |
| 17 | 6 | 7 | 1 | ¤ 899.00 |
| 18 | 6 | 14 | 10 | ¤ 9.99 |
| 19 | 7 | 28 | 1 | ¤ 29.95 |
| 20 | 7 | 30 | 3 | ¤ 59.95 |
| 21 | 8 | 1 | 1 | ¤ 1,599.00 |
| 22 | 8 | 4 | 3 | ¤ 2,299.00 |
| 23 | 8 | 8 | 4 | ¤ 1,599.00 |
| 24 | 8 | 11 | 2 | ¤ 1,245.00 |
| 25 | 8 | 12 | 1 | ¤ 249.00 |
| 26 | 9 | 6 | 1 | ¤ 499.00 |
| 27 | 10 | 2 | 2 | ¤ 1,999.00 |
| 28 | 10 | 22 | 1 | ¤ 1,395.00 |
| 29 | 10 | 23 | 1 | ¤ 249.95 |
| 30 | 11 | 16 | 2 | ¤ 179.95 |
| 31 | 11 | 20 | 2 | ¤ 189.95 |
| 32 | 12 | 21 | 10 | ¤ 65.95 |
| 33 | 12 | 29 | 10 | ¤ 129.95 |
| 34 | 12 | 30 | 10 | ¤ 59.95 |
| 35 | 13 | 9 | 4 | ¤ 399.00 |
| 36 | 13 | 16 | 10 | ¤ 179.95 |
| 37 | 13 | 24 | 2 | ¤ 569.95 |
| 38 | 14 | 19 | 2 | ¤ 39.95 |
| 39 | 14 | 28 | 1 | ¤ 29.95 |
| 40 | 15 | 18 | 1 | ¤ 59.95 |
| 41 | 15 | 20 | 1 | ¤ 189.95 |
| 42 | 16 | 29 | 2 | ¤ 129.95 |
| 43 | 17 | 19 | 2 | ¤ 39.95 |
| 44 | 18 | 9 | 1 | ¤ 399.00 |
| 45 | 18 | 25 | 2 | ¤ 95.95 |
| 46 | 18 | 26 | 2 | ¤ 75.95 |
| 47 | 19 | 14 | 25 | ¤ 9.99 |
| 48 | 20 | 24 | 1 | ¤ 569.95 |
| 49 | 21 | 4 | 1 | ¤ 2,299.00 |
| 50 | 22 | 27 | 1 | ¤ 115.95 |
| 51 | 23 | 21 | 1 | ¤ 65.95 |
| 52 | 23 | 28 | 1 | ¤ 29.95 |
| 53 | 23 | 29 | 1 | ¤ 129.95 |
| 54 | 24 | 7 | 1 | ¤ 899.00 |
| 55 | 24 | 13 | 5 | ¤ 23.00 |
| 56 | 24 | 14 | 3 | ¤ 9.99 |
| 57 | 24 | 16 | 1 | ¤ 179.95 |
| 58 | 25 | 12 | 2 | ¤ 249.00 |
| 59 | 25 | 29 | 2 | ¤ 129.95 |
| 60 | 26 | 4 | 1 | ¤ 2,299.00 |
| 61 | 26 | 7 | 1 | ¤ 899.00 |
| 62 | 26 | 27 | 1 | ¤ 115.95 |
| 63 | 27 | 16 | 1 | ¤ 179.95 |
| 64 | 27 | 23 | 1 | ¤ 249.95 |
| 65 | 28 | 8 | 1 | ¤ 1,599.00 |
| 66 | 28 | 11 | 1 | ¤ 1,245.00 |
| 67 | 28 | 12 | 1 | ¤ 249.00 |
| 68 | 29 | 26 | 1 | ¤ 75.95 |
| 69 | 29 | 27 | 1 | ¤ 115.95 |
| 70 | 30 | 4 | 1 | ¤ 2,299.00 |
| 71 | 30 | 7 | 1 | ¤ 899.00 |
| 72 | 30 | 11 | 1 | ¤ 1,245.00 |
| 73 | 31 | 5 | 12 | ¤ 2,599.00 |
| 74 | 32 | 2 | 2 | ¤ 1,999.00 |
| 75 | 32 | 6 | 2 | ¤ 499.00 |
| 76 | 32 | 12 | 2 | ¤ 249.00 |
| 77 | 33 | 5 | 1 | ¤ 2,599.00 |
| 78 | 34 | 14 | 12 | ¤ 9.99 |
| 79 | 35 | 15 | 12 | ¤ 14.79 |
| 80 | 36 | 8 | 2 | ¤ 1,599.00 |
| 81 | 38 | 32 | 1 | ¤ 356.00 |
| 82 | 38 | 33 | 2 | ¤ 450.00 |
| 83 | 39 | 33 | 1 | ¤ 450.00 |
| 84 | 40 | 32 | 2 | ¤ 356.00 |
| 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 | Current Unit Price | 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 |
| 33063 | Margate | FL |
| 33065 | Coral Springs | FL |
| 33070 | Coral Springs | FL |
| 33120 | Coconut Grove | FL |
| 33131 | Miami | FL |
| 33139 | Miami Beach | FL |
| 33146 | Coral Gables | FL |
| 33186 | Miami | FL |
| 33221 | Cleveland | OH |
| 33340 | Tallahassee | FL |
| 44101 | Cleaveland | OH |
| 44104 | Cleaveland | OH |
| 45501 | Springfield | OH |
| 55356 | Warwick | MN |
| 60098 | Cheswick | NC |
| 70342 | Patrick | KA |
| 85003 | Pheonix | AZ |
| 86002 | Flagstaff | AZ |
| 90210 | Beverly Hills | CA |
| 99801 | Juneau | AK |
