Open the Top't Corn Sales Database Access file from the location where you saved the data files

for this project. $($Downloaded from the Resources link.$)$

Import records from the Excel file DEC$3-9$Sales $($located with the data files for this project$)$ and append a copy of the records to the OnlineSales table. $($Hint: After the import, there should be $229$ records in the OnlineSales table.$)$

In the OnlineSales table, rename the ID field: SaleID

Create a query to display sales of Old Bay flavored popcorn from buyers in Maryland and then export the query results to an Excel file.

Include the following fields in this order: SaleID, Date, Quantity, and State fields from the OnlineSales table and the ItemName field from the Items table.

Add criteria to the query to limit the results to records where the Item Name is Old Bay, the State is MD$,$ and the Date is greater than or equal to December $5,2022.$ Run the query to check your work. $($Hint: There should be $15$ records in the query results.$)$

Return to Query Design view and hide the ItemName and State fields in the query results.

Run the query again to check your work.

Save the query as OldBayMDQuery and then close the query.

Export the results of the OldBayMDQuery to a new Excel file named: OldBayMDSales Do not export the data with formatting and layout. Save the file with the other resources for this project.Save the query as HighQuantityTruffleQry and close it$.$

Export the results of the HighQuantityTruffleQry to a new Excel file named: HighQuantityTruffleSales. Do not export the data with formatting and layout. Save the file with the other resources for this project.

Close any open database objects and then close the database and exit Access.

Open the OldBayMDSales Excel file you just created and create a table to copy into PowerPoint.

In cell D$1,$ type: Total Sale

In cell F$1,$ type: Price per Box

In cell G$1,$ type: $$12\mathrm{.}00$

In cell D$2,$ enter a formula to calculate the total sale. Multiply the quantity sold $($cell C$2)$ by the price per box $($cell G$1).$ You are going to copy this formula to cells D$3$:D$16,$ so use relative and absolute references as appropriate.

Copy the formula in cell D$2$ to cells D$3$:D$16.$

Format the data in cells A$1$:D$16$ as a table using any style.

If necessary, Autofit Column B so the dates are completely visible.

Sort the table data by the quantity so the smallest number of sales is at the top.

In cell F$3,$ type: Average Quantity

Enter a formula in cell G$3$ to calculate the average of cells C$2$:C$16.$

In cell F$4,$ type: Total Sales

Enter a formula in cell G$4$ to calculate the sum of cells D$2$:D$16.$

Apply the Currency number format to cell G$4,$ if necessary.

Select cells A$1$:G$16$ and change the font size to $14.$

Autofit all columns so the data are completely visible.

Copy cells A$1$:G$16.$

Return to the PowerPoint presentation and navigate to Slide $9.$

Change the layout for Slide $9$ to Title and Content.

Add a table to the slide with seven columns and sixteen rows.

Paste the data you copied from Excel into the table, and select Use Destination Style paste option.

Resize the height of the table so all the rows display on the slide. The table should be approximately $3\mathrm{.}8$ inches tall.

Where necessary, change the text in the header row to bold, White, Background $1($the first color in the first row of theme colors$).$

Center align the text in the all the cells in the table.

Return to the OldBayMDSales file and save and close the Excel file.

Open the HighQuantityTruffleSales Excel file you created in step $7.$ e$.,$ and create a chart from the data.

Create a PivotTable from the data. Use the first $($only$)$ recommended PivotTable $$ Sum of Quantity by State.

Create a $3-$D pie chart from the PivotTable data. Move the chart to the right of the PivotTable.

Apply the chart Quick Style Style $2.$

Hide the chart title.

Copy the chart.

Save and close the Excel file.

Return to the PowerPoint presentation and navigate to Slide $8.$

Change the layout for Slide $8$ to Title Only.

Paste the chart you copied from Excel into the slide. Use the Keep Source Formatting and Embed Workbook paste option.

Drag the chart down so it is positioned in the middle of the slide.

Save and close the presentation.

Upload and save your project file.

Submit project for grading.