$$ Begin by downloading the Excel file for this project $($Internet Kitchen Sales and Profits$)$

$$ Import the database into Access and Create a new file with the naming convention of JSmith$\_$Week$8\_$FinalProject.

$$ Create all four queries asked for in Tasks $1,2,3,$ &$4($see below$).$ You may use either $($a$)$ the Create $$Query Design$$ dropdown tab to design your queries from scratch, or $($b$)$ the Query Wizard which will walk your way through the process. You will be creating $$Summarized Queries$$ that provide the data in a table form that summarizes the $$fields$$ you are interested in$.$ All of the reports you generate from these queries will look like a table that sums and averages all orders for the period.$$ The first table you build for Job $1$ in Access should look approximately like the following table:

$$

$$ Table $1.$ Example of Access Generated Table for Task $1,2,3$

Agent

Sum of Total Sales

Average of Total Sales

Sum of Total Profits

Average of Total Profits

Tony

$$

$$

$$

$$

Susan

$$

$$

$$

$$

Karen

$$

$$

$$

$$

Connie

$$

$$

$$

$$

Bart

$$

$$

$$

$$

Total

$$

$$

$$

$$

$$

$$ Each table in the subsequent Tasks will have similar columns except for the first column. The first column heading $($and rows below$)$ will change depending on whether you are analyzing by agent, by product, or by customer. You are not required to import these tables in to this Word document, these tables are for your use in analyzing the data.

$$ Once you have completed all four queries, create Access Reports from each query.$$ Add page numbers, a report title, the company name, and one other modification that you decide to use to $$dress up$$ your report.

$$ After completing all the queries $($tables$)$ and reports, you have all the information you need to provide a short synopsis of the findings, your conclusions, and your thoughts for improving your business in the coming year.$$ Make note of all of this in the space provided under each task$$s instructions in the following pages.

$$ Once you have completed your work in Access and completed your analysis of the data findings, drawn your conclusions and made recommendations in each of the tasks below, submit both the Access and Word files in the Week $8$ Assignments section.

$$

$$

$$

$$

$$

Task $1$: In Access, create one Query and then a report that summarizes the sales and profits by Agent $($Susan$,$ Karen, Bart, Connie, and Tony$).$ Insure that all the following information is included in the Access Report:

$$ Total Sales for all orders placed during the period for each agent

$$ Average of all total sales for all orders placed during the period for each agent

$$ Total Profit for all orders placed during the period for each agent

$$ Average Profit of all orders placed during the period for each agent

You do not need to copy the query generated summary table from Access to this word file, simply use the information to develop an analysis of the data by agent.$$ In the area directly below provide a one or two paragraph analysis of the report by agent.$$ Include a summary of your findings, conclusions, and any recommendations you may have for how to grow profits.$$

$$

Task $2$: In Access, create a Query and then a report that provides the following information by Product $($Juicer$,$ Toaster, Microwave, Can opener, Mixer, Blender$).$ Insure that all the following information is included in the Access Report:

$$ Sum of all Quantities sold by product

$$ Total Sales for all orders placed during the period for each product

$$ Average of all total sales for all orders placed during the period for each product

$$ Total Profit for all orders placed during the period for each product

$$ Average Profit of all orders placed during the period for each product

In the example table above the first column will include a title for $$Products$,$ all other columns will remain the same.$$ You do not need to copy this table to this word file, simply use the information to develop an analysis of the data by agent.$$ In the area directly below provide one or two paragraph analyses of the report by product.$$ Include a summary of your findings, conclusions, and any recommendations you may have for how to grow profits.$$

$$

$$