Create a query to display sales of old bay

Assignment Help Other Subject

Reference no: EM133795565

Question: Open the Top't Corn Outline Word document from the location where you saved the data files for this project. (Downloaded from the Resources link.)
Apply the Heading 1 style to numbered items in the list.
· Apply the Heading 2 style to the lettered items in the list.
· Change the color theme of the document to Red Orange.
· Save the document with the name Top't Corn Outline for Import. Close the document.
· Return to the PowerPoint presentation you downloaded from SIMnet.
Import the Top't Corn Outline for Import Word file into OF2021-Integrated-Project1 presentation.
Use Slides from Outline... option to import the Top't Corn Outline for Import file.
Note: When you are finished with this step, your presentation should contain 10 slides. If it does not, your project will not grade properly and you may lose a significant number of points. Check your work carefully. Book your online tutor now!
· Verify that the Heading 1 style items from the Word file appear as the titles, Heading 2 style items appear in the body.
· Verify that the title font on the imported slides appears to be a Red color.
· Select the title placeholder on Slide 2 (the placeholder with the word Overview). Change the font to Calibri and left align the text.
· With the title placeholder still selected, use Format Painter to copy the formatting and paste the formatting each of the title placeholders on Slides 3 through 10.
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 DEC3-9Sales (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.
Create a query to display sales of truffle flavored popcorn with a quantity greater than ten from the OnlineSales table.
Include the following fields in this order: State and Quantity from the OnlineSales table and ItemName field from the Items table.
· Add criteria to the query to limit the results to records where the Item Name is Truffle and the Quantity is greater than 10.
· Specify the sort order in the query, so the results are sorted alphabetically by state. Run the query to check your work. (Hint: There should be 20 records in the query results.)
· 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 D1, type: Total Sale
· In cell F1, type: Price per Box
· In cell G1, type: $12.00
· In cell D2, enter a formula to calculate the total sale. Multiply the quantity sold (cell C2) by the price per box (cell G1). You are going to copy this formula to cells D3:D16, so use relative and absolute references as appropriate.
· Copy the formula in cell D2 to cells D3:D16.
· Format the data in cells A1:D16 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 F3, type: Average Quantity
· Enter a formula in cell G3 to calculate the average of cells C2:C16.
· In cell F4, type: Total Sales
· Enter a formula in cell G4 to calculate the sum of cells D2:D16.
· Apply the Currency number format to cell G4, if necessary.
· Select cells A1:G16 and change the font size to 14.
· Autofit all columns so the data are completely visible.
· Copy cells A1:G16.
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.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.

Reference no: EM133795565

Questions Cloud

What are you trying to discover or uncover : Statement of the Problem, why it is important to study, and the Purpose of the study. (at least 2.5 pages) What is the social problem or topic?

Why is your topic an important part of risk management : Before writing, organize your thoughts. For example, why is your topic an important part of risk management?

How an organization or community can prepare : Discuss how an organization or community can prepare for an attack from the weapon How can an organization or community prevent the use of such a weapon

Discussing dietary issues with client : A nurse is discussing dietary issues with a client in the clinic. The client states,

Create a query to display sales of old bay : Create a chart from the data and Create a PivotTable from the data. Use the first (only) recommended PivotTable - Sum of Quantity by State

Clinic with acute change in facial symmetry : A patient who presents to your clinic with an acute change in facial symmetry, inability to speak clearly and unilateral muscular weakness

Preparation for conducting research study : A nurse researcher develops a foreground question in preparation for conducting a research study.

Improve the outcome of children and families : Providing recommendations for additional suggestions or actions to improve the outcome of children and families. To extend their learning, challenge them

Define each of four major components of holistic marketing : Define holistic marketing. Define each of the four major components of holistic marketing (p. 12-16). Search for information about Coca-Cola.

User Account

All Pages