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 order lines, but only one customer. An orderline has only one product and belongs to one order, but a product can be on multiple orderliness. The relationships are already established in the starting database (HW4. Customer. Sales)

Question

Computers and Technology

Spencer Owens

21 September, 19:49

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 order lines, but only one customer. An orderline has only one product and belongs to one order, but a product can be on multiple orderliness. The relationships are already established in the starting database (HW4. Customer. Sales)

+1

Answers (1)

Know the Answer?

Darien Bass · Answer 1

Answer:A chart is a graphic that displays numeric data in a compact, visual layout and that reveals essential data relationships. You can add a chart to a form/report to visualize your data and make informed decisions. You can bind the chart to a table or query and customize the chart with a variety of properties. You can even make the chart interactive. For example, if you select a different category field on a form or report filter, you see different chart values. In Access, you can create column, line, bar, pie, and combo charts.