Acces lab quiz
levb92
acces_quiz_file.accdb| ContactID | FirstName | LastName | Address | ZipCode | PhoneNumber |
|---|---|---|---|---|---|
| 1 | Benjamin | Leeroy | 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 | Calister | 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 | Jeffrey | 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 | Klausur | 11 Spring Street | 19008 | 2079887896 |
| 18 | Michael | Lipton | 5986 Parker Street | 01930 | 9782221313 |
| 19 | Ronald | McWilliams | 5921 North Anders Drive | 01765 | 9783347654 |
| 20 | Paul | Greenspan | 133 Beechtree Road | 33139 | 3054412656 |
| 21 | Christopher | Columbus | 1492 LandFall Lane | 60098 | 3453321234 |
| 22 | Peter | McDonald | 1785 Thyne Avenue | 01112 | 2211235432 |
| 23 | Alan | Turing | 5861 North Bennett St | 33065 | 3052341234 |
| 24 | Giancarlo | Peano | 15 Salem St | 02115 | 6174352333 |
| 25 | Franklin | Benudja | 231 Freshman Lane | 44101 | 3054678907 |
| OrdID | ProdID | Quantity | UnitPrice | LineItemID |
|---|---|---|---|---|
| 1 | 13 | 1 | ¤ 15.99 | 1 |
| 1 | 14 | 4 | ¤ 31.99 | 2 |
| 1 | 27 | 1 | ¤ 39.99 | 3 |
| 2 | 1 | 1 | ¤ 745.99 | 4 |
| 2 | 6 | 1 | ¤ 69.99 | 5 |
| 2 | 20 | 1 | ¤ 129.99 | 6 |
| 2 | 22 | 1 | ¤ 429.99 | 7 |
| 3 | 5 | 1 | ¤ 931.19 | 8 |
| 3 | 20 | 1 | ¤ 129.99 | 9 |
| 3 | 22 | 1 | ¤ 429.99 | 10 |
| 4 | 3 | 1 | ¤ 674.99 | 11 |
| 4 | 10 | 1 | ¤ 99.99 | 12 |
| 4 | 22 | 2 | ¤ 429.99 | 13 |
| 5 | 3 | 2 | ¤ 674.99 | 14 |
| 5 | 12 | 2 | ¤ 18.99 | 15 |
| 5 | 16 | 2 | ¤ 44.99 | 16 |
| 6 | 7 | 1 | ¤ 95.72 | 17 |
| 6 | 14 | 10 | ¤ 31.99 | 18 |
| 7 | 28 | 1 | ¤ 252.50 | 19 |
| 7 | 30 | 3 | ¤ 79.99 | 20 |
| 8 | 1 | 1 | ¤ 745.99 | 21 |
| 8 | 4 | 3 | ¤ 999.99 | 22 |
| 8 | 8 | 4 | ¤ 149.90 | 23 |
| 8 | 11 | 2 | ¤ 69.99 | 24 |
| 8 | 12 | 1 | ¤ 18.99 | 25 |
| 9 | 6 | 1 | ¤ 69.99 | 26 |
| 10 | 2 | 2 | ¤ 899.98 | 27 |
| 10 | 22 | 1 | ¤ 429.99 | 28 |
| 10 | 23 | 1 | ¤ 129.99 | 29 |
| 11 | 16 | 2 | ¤ 44.99 | 30 |
| 11 | 20 | 2 | ¤ 129.99 | 31 |
| 12 | 21 | 10 | ¤ 52.99 | 32 |
| 12 | 29 | 10 | ¤ 29.99 | 33 |
| 12 | 30 | 10 | ¤ 79.99 | 34 |
| 13 | 9 | 4 | ¤ 139.99 | 35 |
| 13 | 16 | 10 | ¤ 40.99 | 36 |
| 13 | 24 | 2 | ¤ 179.99 | 37 |
| 14 | 19 | 2 | ¤ 59.99 | 38 |
| 14 | 28 | 1 | ¤ 252.50 | 39 |
| 15 | 18 | 1 | ¤ 59.95 | 40 |
| 15 | 20 | 1 | ¤ 129.99 | 41 |
| 16 | 29 | 2 | ¤ 29.99 | 42 |
| 17 | 19 | 2 | ¤ 59.99 | 43 |
| 18 | 9 | 1 | ¤ 139.99 | 44 |
| 18 | 25 | 2 | ¤ 139.99 | 45 |
| 18 | 26 | 2 | ¤ 94.99 | 46 |
| 19 | 14 | 25 | ¤ 30.00 | 47 |
| 20 | 24 | 1 | ¤ 179.99 | 48 |
| 21 | 4 | 1 | ¤ 999.99 | 49 |
| 22 | 27 | 1 | ¤ 39.99 | 50 |
| 23 | 21 | 1 | ¤ 52.99 | 51 |
| 23 | 28 | 1 | ¤ 252.50 | 52 |
| 23 | 29 | 1 | ¤ 29.99 | 53 |
| 24 | 7 | 1 | ¤ 95.72 | 54 |
| 24 | 13 | 5 | ¤ 14.00 | 55 |
| 24 | 14 | 3 | ¤ 31.99 | 56 |
| 24 | 16 | 1 | ¤ 44.99 | 57 |
| 25 | 12 | 2 | ¤ 18.99 | 58 |
| 25 | 29 | 2 | ¤ 29.99 | 59 |
| 26 | 4 | 1 | ¤ 999.99 | 60 |
| 26 | 7 | 1 | ¤ 95.72 | 61 |
| 26 | 27 | 1 | ¤ 39.99 | 62 |
| 27 | 16 | 1 | ¤ 44.99 | 63 |
| 27 | 23 | 1 | ¤ 129.99 | 64 |
| 28 | 8 | 1 | ¤ 149.90 | 65 |
| 28 | 11 | 1 | ¤ 69.99 | 66 |
| 28 | 12 | 1 | ¤ 18.99 | 67 |
| 29 | 26 | 1 | ¤ 94.99 | 68 |
| 29 | 27 | 1 | ¤ 39.99 | 69 |
| 30 | 4 | 1 | ¤ 999.99 | 70 |
| 30 | 7 | 1 | ¤ 95.72 | 71 |
| 30 | 11 | 5 | ¤ 68.92 | 72 |
| 31 | 5 | 12 | ¤ 931.19 | 73 |
| 32 | 2 | 2 | ¤ 899.98 | 74 |
| 32 | 6 | 2 | ¤ 69.99 | 75 |
| 32 | 12 | 2 | ¤ 18.99 | 76 |
| 33 | 5 | 1 | ¤ 931.19 | 77 |
| 34 | 14 | 12 | ¤ 31.99 | 78 |
| 35 | 15 | 12 | ¤ 19.99 | 79 |
| 36 | 8 | 2 | ¤ 145.00 | 80 |
| 38 | 32 | 1 | ¤ 299.00 | 81 |
| 38 | 33 | 2 | ¤ 628.54 | 82 |
| 39 | 33 | 1 | ¤ 628.54 | 83 |
| 40 | 32 | 2 | ¤ 299.00 | 84 |
| 39 | 32 | 1 | ¤ 299.00 | 85 |
| OrderID | ContactID | OrderDate |
|---|---|---|
| 1 | 4 | 4/15/11 |
| 2 | 3 | 4/18/11 |
| 3 | 6 | 4/18/11 |
| 4 | 7 | 4/18/11 |
| 5 | 1 | 4/20/11 |
| 6 | 1 | 4/21/11 |
| 7 | 2 | 4/21/11 |
| 8 | 2 | 4/22/11 |
| 9 | 1 | 4/29/11 |
| 10 | 2 | 4/22/11 |
| 11 | 1 | 4/24/11 |
| 12 | 7 | 4/24/11 |
| 13 | 4 | 4/24/11 |
| 14 | 6 | 4/26/11 |
| 15 | 9 | 4/25/11 |
| 16 | 6 | 3/30/11 |
| 17 | 11 | 4/26/11 |
| 18 | 11 | 4/26/11 |
| 19 | 12 | 4/27/11 |
| 20 | 12 | 4/28/11 |
| 21 | 10 | 4/29/11 |
| 22 | 10 | 4/29/11 |
| 23 | 8 | 4/20/11 |
| 24 | 6 | 5/1/11 |
| 25 | 6 | 5/1/11 |
| 26 | 18 | 2/2/09 |
| 27 | 13 | 8/5/10 |
| 28 | 14 | 4/21/10 |
| 29 | 14 | 7/8/10 |
| 30 | 15 | 5/2/10 |
| 31 | 16 | 9/3/11 |
| 32 | 16 | 12/15/11 |
| 33 | 17 | 3/21/09 |
| 34 | 19 | 4/23/09 |
| 35 | 20 | 9/2/09 |
| 36 | 2 | 9/15/10 |
| 38 | 23 | 2/4/10 |
| 39 | 23 | 2/2/09 |
| 40 | 24 | 11/14/11 |
| ProductID | ProductName | Current Unit Price | UnitsInStock | Width | Height | Depth | Weight |
|---|---|---|---|---|---|---|---|
| 1 | M90 Sff Tower | ¤ 745.99 | 51 | 21 | 5 | 14 | 12 |
| 2 | Sony Vaio VPC-J113FX/B | ¤ 899.98 | 25 | 21 | 6 | 17 | 16 |
| 3 | HP Pavillion p6730f PC | ¤ 674.99 | 39 | 21 | 8 | 17 | 22 |
| 4 | HP 600C All-In-One Desktop | ¤ 999.99 | 90 | 21 | 3 | 14 | 11 |
| 5 | Lenovo ThinkPad SL510 | ¤ 931.19 | 35 | 13 | 2 | 12 | 4 |
| 6 | IK141ABB 14" LCD Widescreen | ¤ 69.99 | 50 | 20 | 24 | 21 | 26 |
| 7 | Acer V173 17" LCD Widescreen | ¤ 95.72 | 30 | 30 | 30 | 24 | 35 |
| 8 | ViewSonic VX2250 22" LED | ¤ 149.90 | 40 | 40 | 45 | 23 | 45 |
| 9 | Seagate GoFlex 1.5TB | ¤ 139.99 | 17 | 3 | 1 | 4 | 1 |
| 10 | Western Digital SE 1TB | ¤ 99.99 | 18 | 3 | 1 | 4 | 1 |
| 11 | Hitachi XL 1TB | ¤ 69.99 | 19 | 3 | 1 | 4 | 1 |
| 12 | Samsung DVD-R Burner | ¤ 18.99 | 20 | 6 | 2 | 6 | 2 |
| 13 | Verbatim DVD-RW Disks 50pk | ¤ 15.99 | 394 | 5 | 1 | 5 | 1 |
| 14 | Targus CD/DVD Case 240pk | ¤ 31.99 | 98 | 5 | 1 | 5 | 1 |
| 15 | USB Memory Stick 8GB | ¤ 19.99 | 34 | 3 | 1 | 3 | 1 |
| 16 | SD 32GB Flash Card | ¤ 44.99 | 35 | 6 | 1 | 6 | 1 |
| 17 | Logitech Laser Mouse | ¤ 53.99 | 36 | 2 | 1 | 3 | 1 |
| 18 | Logitech Trackball | ¤ 59.95 | 37 | 4 | 2 | 4 | 2 |
| 19 | Microsoft LifeCam Cinema | ¤ 59.99 | 38 | 2 | 6 | 2 | 3 |
| 20 | Razer Cordless USB Keyboard | ¤ 129.99 | 99 | 5 | 1 | 6 | 2 |
| 21 | D-Link 150Mbps Lite N Router | ¤ 52.99 | 13 | 5 | 1 | 6 | 2 |
| 22 | Fujitsu ScanSnap All-In-One | ¤ 429.99 | 78 | 24 | 15 | 28 | 39 |
| 23 | Canon Monochrome Laser Printer | ¤ 129.99 | 20 | 24 | 12 | 26 | 12 |
| 24 | Brother HL-5370DW Workgroup Printer | ¤ 179.99 | 80 | 24 | 12 | 26 | 12 |
| 25 | Windows 7 Home (32 bit) | ¤ 139.99 | 20 | 5 | 1 | 5 | 1 |
| 26 | Windows 7 Home OEM (32 bit) | ¤ 94.99 | 65 | 5 | 1 | 5 | 1 |
| 27 | Norton Anti-Virus | ¤ 39.99 | 247 | 5 | 1 | 5 | 1 |
| 28 | Microsoft MapPoint | ¤ 252.50 | 35 | 5 | 1 | 5 | 1 |
| 29 | Microsoft Encore High School | ¤ 29.99 | 36 | 5 | 1 | 5 | 1 |
| 30 | Nuance DragonSpeak | ¤ 79.99 | 37 | 5 | 1 | 5 | 1 |
| 31 | Rosetta Stone Demo Pak | ¤ 0.99 | 38 | 5 | 1 | 5 | 1 |
| 32 | Archo 10.1" Android Tablet | ¤ 299.00 | 39 | 29 | 29 | 29 | 6 |
| 33 | Apple iPad 64GB WiFi | ¤ 628.54 | 18 | 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 |
