Hello,
Please help me with Questions 1-3 or more if you can!
Merging Access and Excel
Please give me the Steps.
Thank You!
Assignment:
Excel:
Access:
Question 1.) Product Table
Question 2.) SalesPerCustomer
Ok. This is the Additional Information.
Access:
Product:
(What Needs To Be Imported From Excel)
Order:
Order Line:
You must import data into the provided Access Database, run a provided query, export the query results to Excel, and then perform the requested analysis/graphing in Excel. Two starting files are provided: 1. HW4.Customer. Sales - starting Access DB. 2. HW4.product.import - Excel file containing information to be imported into Access. The database is being used to track customers, orders, and products. The database has 4 tables - Customer, Product, Order, and Orderline. A customer can have multiple orders, but an order can only have one customer. An order can have multiple orderlines, but only one customer. An orderline has only one product and belongs to one order, but a product can be on multiple orderlines. The relationships are already established in the starting database (HW4.Customer. Sales) 1. The database user wishes to add an additional set of products into the database. The list of products is contained in a provided Excel Spreadsheet (HW4.product.import). Import the list of new products into the existing Product Table in Access. 2. Run the provided query "SalesPerCustomer" in the Access DB. Export the results to an Excel file named "SalesPerCustomer". Make sure you check "Export data with formatting and layout". 3. In the Excel File "SalesPerCustomer", add a pie chart to the spreadsheet that shows the sales amount (S) per customer. The chart can be inserted on the same worksheet as the data. (pie charts can be found in the same area of Excel as the line chart we did in Lab 9). 4. In the same Excel File "SalesPerCustomer, add a bar chart that shows the OrderCount per Customer. The chart can be inserted on the same worksheet as the data (bar charts can be found in F UnitsinStock 26 2 3 4 5 95 7 8 9 10 11 12 10 65 20 13 14 15 115 21 36 16 17 18 19 20 21 22 ProductName Jack's New England Clam Chowder Singaporean Hokkien Fried Mee Ipoh Coffee Gula Malacca Rgede sild Spegesild Zaanse koeken Chocolade Maxilaku Valkoinen suklaa Manjimup Dried Apples Filo Mix Perth Pasties Tourtire Pat chinois Gnocchi di nonna Alice Ravioli Angelo Escargots de Bourgogne Raclette Courdavault Camembert Pierrot Sirop d'rable Tarte au sucre Vegie-spread Wimmers gute Semmelkndel Louisiana Fiery Hot Pepper Sauce Louisiana Hot Spiced Okra Laughing Lumberjack Lager Scottish Longbreads Gudbrandsdalsost Outback Lager Fltemysost Mozzarella di Giovanni Rd Kaviar Longlife Tofu Rhnbrau Klosterbier Lakkalikri Original Frankfurter grne Soe Unit Price $9.65 $14.00 $46.00 $19.45 $9.50 $12.00 $9.50 $12.75 $20.00 $16.25 $53.00 $7.00 $32.80 $7.45 $24.00 $38.00 $19.50 $13.25 $55.00 $34.00 $28.50 $49.30 $43.90 $33.25 $21.05 $17.00 $14.00 $12.50 $36.00 $15.00 $21.50 $34.80 $15.00 $10.00 $7.75 $18.00 $13.00 Unit Cost $4.25 $6.60 $20.95 $8.80 $4.75 $3.00 $4.35 $5.50 $8.80 $7.85 $23.00 $2.00 $11.00 $3.40 $11.75 $21.00 $12.80 $6.70 $28.95 $17.00 $12.75 $28.55 $23.30 $14.90 $9.00 $7.70 $6.65 $5.90 $16.98 $7.00 $11.70 $15.55 $6.90 $4.50 $3.85 $8.00 $7.75 79 113 76 26 15 26 14 101 125 38 32 All Delete - More SEO - Records Find Customer x Products UnitsInStock - Click to Add- Clipboard All Access Ob... Tables Customer Order B orderline Product Queries SalesPerCustomer spectie Productsales Sort & Filter H Product ProductNam. 23 Tunnbrd 24 Guaran Fanta: 25 NuNuCa NuB-N 26 Gumbr Gumm 27 Schoggi Schoko 28 Rssle Sauerkr 29 Thringer Rosti 30 Nord-Ost Matje 31 Gorgonzola Tel 32 Mascarpone Fa 33 Geitost 34 Sasquatch Ale 35 Steeleye Stout 36 Inlagd Sill 37 Gravad lax 38 Cte de Blaye 39 Chartreuse vert 40 Boston Crab Me 152 Jack's New Engl 153 Singaporean He 154 Ipoh Coffee 155 Gula Malacca UnitPrice - $9.00 $4.50 $14.00 $31.23 $43.90 $45.60 $123.79 $25.89 $12.50 $32.00 $2.50 $14.00 $18.00 $19.00 $26.00 $263.50 $18.00 $18.40 $9.65 $14.00 $46.00 $19.45 UnitCost $3.00 $2.00 $7.90 $18.00 $28.80 $22.00 $73.00 $9.40 $4.80 $18.00 $0.80 $6.00 $7.80 $8.30 $10.50 $128.00 $4.90 $5.50 $4.25 $6.60 $20.95 $8.80 112 111 20 17 123 Sort & Filter Records Find I Customer ProductID UnitCost - UnitsinStock - Click to Add- $4.75 Clipboard All Access Ob... Tables Customer Order Orderline 2 Product Queries SalesPerCustomer Specific Product Sales - ProductNam. UnitPrice 156 Rgede sild $9.50 157 Spegesild $12.00 158 Zaanse koeken $9.50 159 Chocolade $12.75 160 Maxilaku $20.00 161 Valkoinen sukla $16.25 162 Manjimup Drie $53.00 163 Filo Mix $7.00 164 Perth Pasties $32.80 165 Tourtire $7.45 166 Pt chinois $24.00 167 Gnocchi di non $38.00 168 Ravioli Angelo $19.50 169 Escargots de BC $13.25 170 Raclette Courdi $55.00 171 Camembert Pie $34.00 172 Sirop d'rable $28.50 173 Tarte au sucre $49.30 174 Vegie-spread $43.90 175 Wimmers fute $33.25 176 Louisiana Fiery $21.05 177 Louisiana Hot 5 $17.00 $3.00 $4.35 $5.50 $8.80 $7.85 $23.00 $2.00 $11.00 $3.40 $11.75 $21.00 $12.80 $6.70 $28.95 $17.00 $12.75 $28.55 $23.30 $14.90 $9.00 57.70 AN ALLE MORE card Sort & Filter Records Find Unitsin Stock - Click to Add- 52 Customer X ProductX Products ProductNam UnitPrice 178 Laughing Lumb $14.00 179 Scottish Longbr $12.50 180 Gudbrandsdals $36.00 181 Outback Lager $15.00 182 Fltemysost $21.50 183 Mozzarella di G $34.80 184 Rod Kaviar $15.00 185 Longlife Tofu $10.00 186 Rhnbru Klost $7.75 187 Lakkalikri $18.00 188 Original Frankfu (New) UnitCost $6.65 $5.90 $16.98 $7.00 $11.70 $15.55 $6.90 $4.50 $3.85 $8.00 $7.75 mer uct Sales $13.00 Customer X Product X Company Name B's Beverages Eastern Connection Hungry Coyote Import Store Lazy K Kountry Store Lonesome Pine Restaurant North/South Old World Delicatessen Rattlesnake Canyon Grocery Save-a-lot Markets Seven Seas Imports Split Rail Beer & Ale The Big Cheese The Cracker Box SalesPerCustomer X - OrderCount - SalesAmoun - 11 $2,770.50 $8,813.20 $2,237.75 $394.00 $2,100.20 $144.00 12 $11,229.60 $32,164.67 $59,872.65 16 $12,690.60 10 $10,769.72 5 $3,129.90 5 $1,640.74 57 Order CCH HIN Product SalesPerCustomer SpecificProduct Sales OrderiD - CustomerID , Order Date - Click to Add- 10271 75 12/23/2010 10272 65 10/22/2009 10289 11 4/20/2010 10294 65 12/24/2009 10305 3/29/2010 10307 6/23/2009 10310 6/9/2009 10314 6/17/2009 10316 2/9/2010 10317 11/14/2008 10324 4/21/2009 10329 1/21/2010 10338 4/6/2010 10346 5/5/2010 10349 9/1/2008 10359 4/16/2010 10364 12/11/2008 10369 8/13/2009 10375 8/5/2009 10377 2/9/2010 10385 12/21/2009 10388 2/24/2009 Order Customer X Product SalesPerCustomer X SpecificProduct Sales OrderiD CustomerID - Order Date - Click to Add- 10364 19 12/11/2008 10369 75 8/13/2009 10375 8/5/2009 10377 2/9/2010 10385 12/21/2009 10388 2/24/2009 10393 2/15/2010 10394 2/15/2010 10398 5/11/2010 10400 3/30/2010 10401 1/1/2009 10415 2/4/2009 10432 9/1/2009 10440 6/30/2009 10441 7/27/2009 10452 4/28/2009 10471 5/7/2010 10472 4/29/2009 10479 65 5/14/2010 10482 3/1/2010 10484 5/26/2010 10510 71 4/8/2010 FIFA Customer x .Product SalesPerCustomer X SpecificProduct Sales OrderlD - CustomerlD - Order Date - Click to Add- 10471 5/7/2010 10472 4/29/2009 10479 5/14/2010 10482 3/1/2010 10484 5/26/2010 10510 4/8/2010 10517 5/25/2010 10523 10/12/2009 10532 3/26/2010 10538 3/5/2010 10539 4/23/2010 10544 8/1/2008 10545 10/1/2009 10547 7/23/2009 10555 4/12/2010 10564 5/24/2010 10569 11/25/2008 10578 3/31/2010 10594 9/28/2009 10598 3/2/2010 10599 4/8/2010 10600 8/29/2008 OrderiD | CustomerID - OrderDate - Click to Add - 10603 1 9/7/2009 10607 | 11/13/2008 10612 5/15/2009 10624 7/17/2009 10627 3/10/2010 10657 10/2/2009 10660) 14/27/2009 10662. 8/25/2009 10665 | 1/1/2010 10678 4/15/2010 10680 | 1/9/2009 10700) 1/28/2009 10706 5/20/2010 10708 12/15/2009) 10711 71 10/14/2009 10713 | 1/21/2009) 10714 | 4/6/2010 10722 14/6/2009) 10726 8/14/2008) 10748 1/30/2009 10752 2/25/2010 10756 | 1/12/2010 HB889 SUFICI RE Or * Product x OrderiD - CustomerID 10757 10761 10775 10800 10804 10805 10808 10815 10820 10821 10847 10852 10855 10867 10869 10882 10883 10889 10894 10941 10943 10947 SalesPerCustomer x SpecificProduct Sales OrderDate - Click to Add- 71 10/7/2008 65 11/17/2009 78 4/16/2009 72 2/11/2010 12/16/2009 5/6/2010 5/6/2010 2/5/2010 5/26/2009 1/15/2009 3/22/2010 3/18/2009 9/5/2008 10/9/2008 11/20/2008 3/30/2010 5/11/2010 3/30/2010 1/1/2009 11/13/2009 6/24/2009 11 9/22/2009 ALL 55 Customer X Product X SalesPerCustomer X SpecificProductsal OrderID - CustomerID - OrderDate r Click to Add r 10965 | 4/15/2010 10974 1- 6/1/2010 10983 8/4/2009 10984 2/23/2010 10987 3/16/2009 10988 65 5/27/2009 10992. 77 3/12/2010 11000 2/18/2010 11002. 9/24/2008 11003) 78 3/25/2011 11018. 7/3/2009 11023 16/4/2009 11024 11/18/2008 11030 | 12/2/2009 11031 12/8/2009 11034 4/13/2009 11047 4/13/2010) 11056 | 7/9/2009 11057 | 6/2/2010) 11064 12/8/2008 11077 65 12/30/2009 SULOL FC ALLURUS SpecificProduct Sales Customer x OrderlD SalesPerCustomer X - Quantit - Click to Add- E Product ProductID 11003 40 10748 40 10607 40 10484 40 10482 40 11077 39 10377 39 10305 39 10889 38 10805 38 10479 38 10329 38 10847 37 10523 37 10984 36 10756 36 10708 36 10612 36 10547 36 11002 35 10821 35 10578 35 Customer SalesPerCustomer' SpecificProd - Quantit - Click to Add , OrderID Product x ProductID 10400 35 10398 35 10324 35 10805 34 10757 34 10700 34 11024 33 10815 33 10678 33 10607 33 10539 33 10415 33 10271 33 11077 32 10547 32 10314 32 10941 31 10855 31 10722 31 10680 31 10569 31 10564 31 SUIL Filter Records Customer x OrderID SalesPerCustomer' x SpecificProducts - Quantit - Click to Add- 32 Product x ProductID 10393 31 10359 31 10272 31 10532 30 10401 30 10338 30 10329 30 11030 29 1062429 10510 29 10440 29 10400 29 10369 29 10305 29 10804 28 10624 28 10544 28 10452 28 10377 28 10598 27 10441 27 11024 26 Customer x OrderID SalesPerCustomer x SpecificProdu + Quantit - Click to Add- Product ProductID 10272 20 10847 19 10711 19 10555 19 10329 19 11018 18 10756 18 10305 18 11064 17 10852 17 10714 17 10607 17 10564 17 10523 17 10415 17 10346 17 10338 17 10294 17 11077 16 10984 16 10855 16 10706 16 Customer X OrderID SalesPerCustomer X SpecificProduct Sales - Quantit - Click to Add- B Product X ProductID 10680 16 10440 16 10359 16 10324 16 10310 16 10657 15 11077 14 10555 14 10393 14 10375 14 11077 13 11031 13 11002 13 10983 13 10943 13 10894 13 10539 13 10394 13 11077 12 11018 12 10678 12 10889 11 100 SpecificProduds 1 Customer x Ordered SalesPerCustomer * - Quantit - Click to Add- Product x - ProductID 10869 11 10800 11 10726 11 10545 11 11077 10 10804 10 10775 10 10713 10 10612 10 110778 11077 7 11056 7 110237 10988 7 10987 7 10607 7 10471 7 10385 7 11077 6 110475 110305 10708 5 Customer X OrderlD SalesPerCustomer x SpecificPro - Quantit - Click to Add , 100 Product * ProductID 11077 4 11000 4 107264 110773 10289 3 110772 11030 2 108522 107222 107142 10440 2 103932 11047 1 11031 1 11003 1 10869 1 10847 1 10752 1 10700 1 103171 102941 Orderine Customer Product ProductD - ProductNam - (New) SalesPerCustomer UnitPrice - X SpecificProduct Sales Order UnitCost Unitsin Stock - Click to Add- You must import data into the provided Access Database, run a provided query, export the query results to Excel, and then perform the requested analysis/graphing in Excel. Two starting files are provided: 1. HW4.Customer. Sales - starting Access DB. 2. HW4.product.import - Excel file containing information to be imported into Access. The database is being used to track customers, orders, and products. The database has 4 tables - Customer, Product, Order, and Orderline. A customer can have multiple orders, but an order can only have one customer. An order can have multiple orderlines, but only one customer. An orderline has only one product and belongs to one order, but a product can be on multiple orderlines. The relationships are already established in the starting database (HW4.Customer. Sales) 1. The database user wishes to add an additional set of products into the database. The list of products is contained in a provided Excel Spreadsheet (HW4.product.import). Import the list of new products into the existing Product Table in Access. 2. Run the provided query "SalesPerCustomer" in the Access DB. Export the results to an Excel file named "SalesPerCustomer". Make sure you check "Export data with formatting and layout". 3. In the Excel File "SalesPerCustomer", add a pie chart to the spreadsheet that shows the sales amount (S) per customer. The chart can be inserted on the same worksheet as the data. (pie charts can be found in the same area of Excel as the line chart we did in Lab 9). 4. In the same Excel File "SalesPerCustomer, add a bar chart that shows the OrderCount per Customer. The chart can be inserted on the same worksheet as the data (bar charts can be found in F UnitsinStock 26 2 3 4 5 95 7 8 9 10 11 12 10 65 20 13 14 15 115 21 36 16 17 18 19 20 21 22 ProductName Jack's New England Clam Chowder Singaporean Hokkien Fried Mee Ipoh Coffee Gula Malacca Rgede sild Spegesild Zaanse koeken Chocolade Maxilaku Valkoinen suklaa Manjimup Dried Apples Filo Mix Perth Pasties Tourtire Pat chinois Gnocchi di nonna Alice Ravioli Angelo Escargots de Bourgogne Raclette Courdavault Camembert Pierrot Sirop d'rable Tarte au sucre Vegie-spread Wimmers gute Semmelkndel Louisiana Fiery Hot Pepper Sauce Louisiana Hot Spiced Okra Laughing Lumberjack Lager Scottish Longbreads Gudbrandsdalsost Outback Lager Fltemysost Mozzarella di Giovanni Rd Kaviar Longlife Tofu Rhnbrau Klosterbier Lakkalikri Original Frankfurter grne Soe Unit Price $9.65 $14.00 $46.00 $19.45 $9.50 $12.00 $9.50 $12.75 $20.00 $16.25 $53.00 $7.00 $32.80 $7.45 $24.00 $38.00 $19.50 $13.25 $55.00 $34.00 $28.50 $49.30 $43.90 $33.25 $21.05 $17.00 $14.00 $12.50 $36.00 $15.00 $21.50 $34.80 $15.00 $10.00 $7.75 $18.00 $13.00 Unit Cost $4.25 $6.60 $20.95 $8.80 $4.75 $3.00 $4.35 $5.50 $8.80 $7.85 $23.00 $2.00 $11.00 $3.40 $11.75 $21.00 $12.80 $6.70 $28.95 $17.00 $12.75 $28.55 $23.30 $14.90 $9.00 $7.70 $6.65 $5.90 $16.98 $7.00 $11.70 $15.55 $6.90 $4.50 $3.85 $8.00 $7.75 79 113 76 26 15 26 14 101 125 38 32 All Delete - More SEO - Records Find Customer x Products UnitsInStock - Click to Add- Clipboard All Access Ob... Tables Customer Order B orderline Product Queries SalesPerCustomer spectie Productsales Sort & Filter H Product ProductNam. 23 Tunnbrd 24 Guaran Fanta: 25 NuNuCa NuB-N 26 Gumbr Gumm 27 Schoggi Schoko 28 Rssle Sauerkr 29 Thringer Rosti 30 Nord-Ost Matje 31 Gorgonzola Tel 32 Mascarpone Fa 33 Geitost 34 Sasquatch Ale 35 Steeleye Stout 36 Inlagd Sill 37 Gravad lax 38 Cte de Blaye 39 Chartreuse vert 40 Boston Crab Me 152 Jack's New Engl 153 Singaporean He 154 Ipoh Coffee 155 Gula Malacca UnitPrice - $9.00 $4.50 $14.00 $31.23 $43.90 $45.60 $123.79 $25.89 $12.50 $32.00 $2.50 $14.00 $18.00 $19.00 $26.00 $263.50 $18.00 $18.40 $9.65 $14.00 $46.00 $19.45 UnitCost $3.00 $2.00 $7.90 $18.00 $28.80 $22.00 $73.00 $9.40 $4.80 $18.00 $0.80 $6.00 $7.80 $8.30 $10.50 $128.00 $4.90 $5.50 $4.25 $6.60 $20.95 $8.80 112 111 20 17 123 Sort & Filter Records Find I Customer ProductID UnitCost - UnitsinStock - Click to Add- $4.75 Clipboard All Access Ob... Tables Customer Order Orderline 2 Product Queries SalesPerCustomer Specific Product Sales - ProductNam. UnitPrice 156 Rgede sild $9.50 157 Spegesild $12.00 158 Zaanse koeken $9.50 159 Chocolade $12.75 160 Maxilaku $20.00 161 Valkoinen sukla $16.25 162 Manjimup Drie $53.00 163 Filo Mix $7.00 164 Perth Pasties $32.80 165 Tourtire $7.45 166 Pt chinois $24.00 167 Gnocchi di non $38.00 168 Ravioli Angelo $19.50 169 Escargots de BC $13.25 170 Raclette Courdi $55.00 171 Camembert Pie $34.00 172 Sirop d'rable $28.50 173 Tarte au sucre $49.30 174 Vegie-spread $43.90 175 Wimmers fute $33.25 176 Louisiana Fiery $21.05 177 Louisiana Hot 5 $17.00 $3.00 $4.35 $5.50 $8.80 $7.85 $23.00 $2.00 $11.00 $3.40 $11.75 $21.00 $12.80 $6.70 $28.95 $17.00 $12.75 $28.55 $23.30 $14.90 $9.00 57.70 AN ALLE MORE card Sort & Filter Records Find Unitsin Stock - Click to Add- 52 Customer X ProductX Products ProductNam UnitPrice 178 Laughing Lumb $14.00 179 Scottish Longbr $12.50 180 Gudbrandsdals $36.00 181 Outback Lager $15.00 182 Fltemysost $21.50 183 Mozzarella di G $34.80 184 Rod Kaviar $15.00 185 Longlife Tofu $10.00 186 Rhnbru Klost $7.75 187 Lakkalikri $18.00 188 Original Frankfu (New) UnitCost $6.65 $5.90 $16.98 $7.00 $11.70 $15.55 $6.90 $4.50 $3.85 $8.00 $7.75 mer uct Sales $13.00 Customer X Product X Company Name B's Beverages Eastern Connection Hungry Coyote Import Store Lazy K Kountry Store Lonesome Pine Restaurant North/South Old World Delicatessen Rattlesnake Canyon Grocery Save-a-lot Markets Seven Seas Imports Split Rail Beer & Ale The Big Cheese The Cracker Box SalesPerCustomer X - OrderCount - SalesAmoun - 11 $2,770.50 $8,813.20 $2,237.75 $394.00 $2,100.20 $144.00 12 $11,229.60 $32,164.67 $59,872.65 16 $12,690.60 10 $10,769.72 5 $3,129.90 5 $1,640.74 57 Order CCH HIN Product SalesPerCustomer SpecificProduct Sales OrderiD - CustomerID , Order Date - Click to Add- 10271 75 12/23/2010 10272 65 10/22/2009 10289 11 4/20/2010 10294 65 12/24/2009 10305 3/29/2010 10307 6/23/2009 10310 6/9/2009 10314 6/17/2009 10316 2/9/2010 10317 11/14/2008 10324 4/21/2009 10329 1/21/2010 10338 4/6/2010 10346 5/5/2010 10349 9/1/2008 10359 4/16/2010 10364 12/11/2008 10369 8/13/2009 10375 8/5/2009 10377 2/9/2010 10385 12/21/2009 10388 2/24/2009 Order Customer X Product SalesPerCustomer X SpecificProduct Sales OrderiD CustomerID - Order Date - Click to Add- 10364 19 12/11/2008 10369 75 8/13/2009 10375 8/5/2009 10377 2/9/2010 10385 12/21/2009 10388 2/24/2009 10393 2/15/2010 10394 2/15/2010 10398 5/11/2010 10400 3/30/2010 10401 1/1/2009 10415 2/4/2009 10432 9/1/2009 10440 6/30/2009 10441 7/27/2009 10452 4/28/2009 10471 5/7/2010 10472 4/29/2009 10479 65 5/14/2010 10482 3/1/2010 10484 5/26/2010 10510 71 4/8/2010 FIFA Customer x .Product SalesPerCustomer X SpecificProduct Sales OrderlD - CustomerlD - Order Date - Click to Add- 10471 5/7/2010 10472 4/29/2009 10479 5/14/2010 10482 3/1/2010 10484 5/26/2010 10510 4/8/2010 10517 5/25/2010 10523 10/12/2009 10532 3/26/2010 10538 3/5/2010 10539 4/23/2010 10544 8/1/2008 10545 10/1/2009 10547 7/23/2009 10555 4/12/2010 10564 5/24/2010 10569 11/25/2008 10578 3/31/2010 10594 9/28/2009 10598 3/2/2010 10599 4/8/2010 10600 8/29/2008 OrderiD | CustomerID - OrderDate - Click to Add - 10603 1 9/7/2009 10607 | 11/13/2008 10612 5/15/2009 10624 7/17/2009 10627 3/10/2010 10657 10/2/2009 10660) 14/27/2009 10662. 8/25/2009 10665 | 1/1/2010 10678 4/15/2010 10680 | 1/9/2009 10700) 1/28/2009 10706 5/20/2010 10708 12/15/2009) 10711 71 10/14/2009 10713 | 1/21/2009) 10714 | 4/6/2010 10722 14/6/2009) 10726 8/14/2008) 10748 1/30/2009 10752 2/25/2010 10756 | 1/12/2010 HB889 SUFICI RE Or * Product x OrderiD - CustomerID 10757 10761 10775 10800 10804 10805 10808 10815 10820 10821 10847 10852 10855 10867 10869 10882 10883 10889 10894 10941 10943 10947 SalesPerCustomer x SpecificProduct Sales OrderDate - Click to Add- 71 10/7/2008 65 11/17/2009 78 4/16/2009 72 2/11/2010 12/16/2009 5/6/2010 5/6/2010 2/5/2010 5/26/2009 1/15/2009 3/22/2010 3/18/2009 9/5/2008 10/9/2008 11/20/2008 3/30/2010 5/11/2010 3/30/2010 1/1/2009 11/13/2009 6/24/2009 11 9/22/2009 ALL 55 Customer X Product X SalesPerCustomer X SpecificProductsal OrderID - CustomerID - OrderDate r Click to Add r 10965 | 4/15/2010 10974 1- 6/1/2010 10983 8/4/2009 10984 2/23/2010 10987 3/16/2009 10988 65 5/27/2009 10992. 77 3/12/2010 11000 2/18/2010 11002. 9/24/2008 11003) 78 3/25/2011 11018. 7/3/2009 11023 16/4/2009 11024 11/18/2008 11030 | 12/2/2009 11031 12/8/2009 11034 4/13/2009 11047 4/13/2010) 11056 | 7/9/2009 11057 | 6/2/2010) 11064 12/8/2008 11077 65 12/30/2009 SULOL FC ALLURUS SpecificProduct Sales Customer x OrderlD SalesPerCustomer X - Quantit - Click to Add- E Product ProductID 11003 40 10748 40 10607 40 10484 40 10482 40 11077 39 10377 39 10305 39 10889 38 10805 38 10479 38 10329 38 10847 37 10523 37 10984 36 10756 36 10708 36 10612 36 10547 36 11002 35 10821 35 10578 35 Customer SalesPerCustomer' SpecificProd - Quantit - Click to Add , OrderID Product x ProductID 10400 35 10398 35 10324 35 10805 34 10757 34 10700 34 11024 33 10815 33 10678 33 10607 33 10539 33 10415 33 10271 33 11077 32 10547 32 10314 32 10941 31 10855 31 10722 31 10680 31 10569 31 10564 31 SUIL Filter Records Customer x OrderID SalesPerCustomer' x SpecificProducts - Quantit - Click to Add- 32 Product x ProductID 10393 31 10359 31 10272 31 10532 30 10401 30 10338 30 10329 30 11030 29 1062429 10510 29 10440 29 10400 29 10369 29 10305 29 10804 28 10624 28 10544 28 10452 28 10377 28 10598 27 10441 27 11024 26 Customer x OrderID SalesPerCustomer x SpecificProdu + Quantit - Click to Add- Product ProductID 10272 20 10847 19 10711 19 10555 19 10329 19 11018 18 10756 18 10305 18 11064 17 10852 17 10714 17 10607 17 10564 17 10523 17 10415 17 10346 17 10338 17 10294 17 11077 16 10984 16 10855 16 10706 16 Customer X OrderID SalesPerCustomer X SpecificProduct Sales - Quantit - Click to Add- B Product X ProductID 10680 16 10440 16 10359 16 10324 16 10310 16 10657 15 11077 14 10555 14 10393 14 10375 14 11077 13 11031 13 11002 13 10983 13 10943 13 10894 13 10539 13 10394 13 11077 12 11018 12 10678 12 10889 11 100 SpecificProduds 1 Customer x Ordered SalesPerCustomer * - Quantit - Click to Add- Product x - ProductID 10869 11 10800 11 10726 11 10545 11 11077 10 10804 10 10775 10 10713 10 10612 10 110778 11077 7 11056 7 110237 10988 7 10987 7 10607 7 10471 7 10385 7 11077 6 110475 110305 10708 5 Customer X OrderlD SalesPerCustomer x SpecificPro - Quantit - Click to Add , 100 Product * ProductID 11077 4 11000 4 107264 110773 10289 3 110772 11030 2 108522 107222 107142 10440 2 103932 11047 1 11031 1 11003 1 10869 1 10847 1 10752 1 10700 1 103171 102941 Orderine Customer Product ProductD - ProductNam - (New) SalesPerCustomer UnitPrice - X SpecificProduct Sales Order UnitCost Unitsin Stock - Click to Add
