You must import data into the provided Access Database, run a provided query, export the query results to Excel, and the

[answerhappygod]

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:
The database file (HW5.Customer.Sales) tracks customers, orders,
and products. The database has 4 tables – Customer, Product, Order,
and Orderline with the following relationships already
established:
For 10 points of extra credit, write a query titled
CityAnalysis that extracts the correct data and then export this
data into a new Excel file (named "CityAnalysis") for further
processing in order to complete the following two
tasks:
Submit all completed files to Blackboard.
4. If you completed the extra credit tasks, also submit
the CityAnalysis Excel file that contains the data you transferred
from Access and clearly shows the answers to the questions in Item
1 above as well as the bar chart and pie chart described in Item
2.
Make sure you attach all files to your submission before you
click the submit button on Blackboard.