In this project, you will create a presentation for the Top’t Corn popcorn company using resources from a Word document, an Access database, and two Excel files. First, you will format an outline in Word so it can be imported as slides and content for the presentation. You will format the look of the text before and after importing and use Format Painter to copy and paste formatting between slides. Next, you will import data from Excel into an Access database and then create two queries based on that imported data. You will export the query results to a new Excel workbook where you will add formulas and create a table and a chart. Finally, you will copy and paste the chart and table data from Excel into your PowerPoint presentation.
Skills needed to complete this project:
Apply heading styles
Change the font theme
Import slides from a Word outline
Change the font
Use Format Painter
Change slide layout
Add a table to a slide
Paste data from Excel
Change font color
Paste a chart from Excel
Move an object on a slide
Add records to a table by importing from Excel
Rename a field
Create a simple select query to combine fields from multiple tables
Add text criteria to a query
Add date criteria to a query
Apply multiple criteria to a query
Add numeric criteria to a query
Specify a sort order in a query
Export data from a query to Excel
Enter text and numbers in cells
Create a formula using multiplication
Use an absolute reference in a formula
Copy a formula
Format data as a table
Sort data in a table
Use the AVERAGE function in a formula
Use the SUM function in a formula
Apply a number format
Modify the font size
Create a PivotTable using a Recommended PivotTable
Create a pie chart
Hide the chart title
Apply a chart style
IMPORTANT: Download the resource file needed for this project from the Resources link. Be sure to extract the file after downloading the resources zipped folder. Please visit SIMnet Instant Help for step-by-step instructions.
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.)
Import the Top’t Corn Outline for Import Word file into OF2019-Integrated-Project1 presentation.
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.)
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.
Create a query to display sales of truffle flavored popcorn with a quantity greater than six from the OnlineSales table.
Open the OldBayMdSales Excel file you just created and create a table to copy into PowerPoint.
Return to the PowerPoint presentation and navigate to Slide 9.
Open the HighQuantityTruffleSales Excel file you created in step 7. e., and create a chart from the data.
Return to the PowerPoint presentation and navigate to Slide 8.