Excel Modules 9-16 SAM Capstone Project 1
triceyr
Support_IL_EX16_CS9-16a_Orders1.accdb
| OrderID | CustomerID | Region | OrderDate | Product | Quantity | UnitPrice |
| 1 | BR101 | Mountain | 1/2/20 | Light | 12 | ¤ 49.95 |
| 2 | BR204 | Pacific | 1/2/20 | Plug | 10 | ¤ 55.95 |
| 3 | BR204 | Pacific | 1/2/20 | Light | 5 | ¤ 49.95 |
| 4 | BR204 | Pacific | 1/2/20 | Thermostat | 5 | ¤ 169.00 |
| 5 | BR207 | Midwest | 1/3/20 | Thermostat | 5 | ¤ 169.00 |
| 6 | BR207 | Midwest | 1/3/20 | Thermostat | 5 | ¤ 189.00 |
| 7 | BR207 | Midwest | 1/3/20 | Thermostat | 5 | ¤ 219.00 |
| 8 | BR208 | New England | 1/4/20 | Lock | 10 | ¤ 119.00 |
| 9 | BR209 | South Atlantic | 1/4/20 | Plug | 8 | ¤ 55.95 |
| 10 | BR211 | Mid-Atlantic | 1/4/20 | Light | 8 | ¤ 49.95 |
| 11 | BR213 | Mid-Atlantic | 1/5/20 | Lock | 5 | ¤ 119.00 |
| 12 | BR216 | Mountain | 1/5/20 | Thermostat | 10 | ¤ 189.00 |
| 13 | BR101 | Mountain | 1/6/20 | Plug | 10 | ¤ 55.95 |
| 14 | BR101 | Mountain | 1/6/20 | Lock | 10 | ¤ 119.00 |
| 15 | BR217 | New England | 1/7/20 | Thermostat | 8 | ¤ 219.00 |
| 16 | BR217 | New England | 1/8/20 | Thermostat | 5 | ¤ 169.00 |
| 17 | BR204 | Pacific | 1/12/20 | Lock | 8 | ¤ 119.00 |
| 18 | BR209 | South Atlantic | 1/14/20 | Lock | 5 | ¤ 119.00 |
| 19 | BR220 | Midwest | 1/15/20 | Thermostat | 10 | ¤ 189.00 |
| 20 | BR220 | Midwest | 1/15/20 | Thermostat | 10 | ¤ 169.00 |
| 21 | BR220 | Midwest | 1/15/20 | Thermostat | 10 | ¤ 219.00 |
| 22 | BR208 | New England | 1/18/20 | Light | 3 | ¤ 49.95 |
| 23 | BR207 | Midwest | 1/20/20 | Lock | 10 | ¤ 119.00 |
| 24 | BR207 | Midwest | 1/23/20 | Plug | 5 | ¤ 55.95 |
| 25 | BR211 | Mid-Atlantic | 1/25/20 | Thermostat | 8 | ¤ 169.00 |
| 26 | BR101 | Mountain | 1/27/20 | Thermostat | 8 | ¤ 169.00 |
| 27 | BR108 | Pacific | 1/29/20 | Plug | 10 | ¤ 55.95 |
| 28 | BR105 | South Atlantic | 1/30/20 | Thermostat | 5 | ¤ 219.00 |
| 29 | BR110 | Mid-Atlantic | 2/1/20 | Lock | 8 | ¤ 119.00 |
| 30 | BR117 | Pacific | 2/2/20 | Plug | 12 | ¤ 55.95 |
| 31 | BR120 | South Atlantic | 2/3/20 | Thermostat | 8 | ¤ 169.00 |
| 32 | BR209 | South Atlantic | 2/14/20 | Lock | 5 | ¤ 119.00 |
| 33 | BR220 | Midwest | 2/15/20 | Thermostat | 10 | ¤ 189.00 |
| 34 | BR220 | Midwest | 2/15/20 | Thermostat | 10 | ¤ 169.00 |
| 35 | BR220 | Midwest | 2/15/20 | Thermostat | 10 | ¤ 219.00 |
| 36 | BR208 | New England | 2/18/20 | Light | 3 | ¤ 49.95 |
| 37 | BR207 | Midwest | 2/20/20 | Lock | 10 | ¤ 119.00 |
| 38 | BR207 | Midwest | 2/23/20 | Plug | 5 | ¤ 55.95 |
| 39 | BR211 | Mid-Atlantic | 2/25/20 | Thermostat | 8 | ¤ 169.00 |
| 40 | BR101 | Mountain | 2/27/20 | Thermostat | 8 | ¤ 169.00 |
| 41 | BR108 | Pacific | 2/29/20 | Plug | 10 | ¤ 55.95 |
| 42 | BR105 | South Atlantic | 3/1/20 | Thermostat | 5 | ¤ 219.00 |
| 43 | BR110 | Mid-Atlantic | 3/1/20 | Lock | 8 | ¤ 119.00 |
| 44 | BR117 | Pacific | 3/2/20 | Plug | 12 | ¤ 55.95 |
| 45 | BR120 | South Atlantic | 3/3/20 | Thermostat | 8 | ¤ 169.00 |
| 46 | BR101 | Mountain | 3/4/20 | Light | 12 | ¤ 49.95 |
| 47 | BR204 | Pacific | 3/5/20 | Plug | 10 | ¤ 55.95 |
| 48 | BR204 | Pacific | 3/5/20 | Light | 15 | ¤ 49.95 |
| 49 | BR204 | Pacific | 3/5/20 | Thermostat | 3 | ¤ 169.00 |
| 50 | BR207 | Midwest | 3/6/20 | Thermostat | 10 | ¤ 169.00 |
| 51 | BR207 | Midwest | 3/6/20 | Thermostat | 5 | ¤ 189.00 |
| 52 | BR207 | Midwest | 3/6/20 | Thermostat | 5 | ¤ 219.00 |
| 53 | BR208 | New England | 3/7/20 | Lock | 8 | ¤ 119.00 |
| 54 | BR209 | South Atlantic | 3/9/20 | Plug | 2 | ¤ 55.95 |
| 55 | BR211 | Mid-Atlantic | 3/10/20 | Light | 8 | ¤ 49.95 |
| 56 | BR213 | Mid-Atlantic | 3/15/20 | Lock | 5 | ¤ 119.00 |
| 57 | BR216 | Mountain | 3/15/20 | Thermostat | 5 | ¤ 189.00 |
| 58 | BR101 | Mountain | 3/16/20 | Plug | 5 | ¤ 55.95 |
| 59 | BR101 | Mountain | 3/16/20 | Lock | 12 | ¤ 119.00 |
| 60 | BR217 | New England | 3/17/20 | Thermostat | 4 | ¤ 219.00 |
| 61 | BR217 | New England | 3/18/20 | Thermostat | 10 | ¤ 169.00 |
| 62 | BR204 | Pacific | 3/22/20 | Lock | 8 | ¤ 119.00 |
| 63 | BR209 | South Atlantic | 3/24/20 | Lock | 5 | ¤ 119.00 |
