For this exercise there is an Exercise folder in your session ten sample files folder that contains three

workbooks: Customer$-1,$ Order$-1$ and Product$-1.$

$1$ Open a new blank workbook.

$2$ The Customer$-1$ workbook contains three tables called: FranceTable, UKTable and USATable. Create

three Connection only queries that return the data from each table.

$3$ Create a new Append query called AllCustomers that will combine all of the rows contained in the

other three queries into one query.

$4$ The Order$-1$ and Product$-1$ workbooks each contain a single table $($OrderTable and ProductTable$).$

Create two new Connection only queries that return the data from each table.

$5$ Add a Custom Column to the OrderTable query named Total Price that will calculate the total price of

each row using the formula: $[$Quantity$]*[$Unit Price$]$

$6$ Set the data type of the new Total Price column to: Currency.

$7$ Load the OrderTable query results directly into a pivot table.

$8$ Use the pivot table to show total sales by year and month for each Country.

$9$ Save your work as: Exercise $10-$End.

Customer$-1,$ Order$-1,$ Product$-1$