Save the query as OldBayMDQuery and then close the query. (Hint: There should be 8 records in the query results.) Return to Query Design view and hide the ItemName and State fields in the query results. 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 November 6, 2016. 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. (Hint: After the import, there should be 234 records in the OnlineSales table.) In the OnlineSales table, rename the ID field: SaleID Create query to display sales of Old Bay flavored popcorn from buyers in Maryland and then export the query results to an Excel file. (Downloaded from the Resources link.) Import records from the Excel file Nov4-10Sales (located with the data files for this project) and append a copy of the records to the OnlineSales table. Open the Top't Corn Sales Database Access file from the location where you saved the data files for this project. 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. Change the font to and left align the text. Select the title placeholder on Slide 2 (the placeholder with the word Overview). Verify that the title font on the imported slides appears to be an Orange Red color. Verify that the Heading 1 style items from the Word file appear as the titles, Heading 2 style items appear in the body. If it does not, your project will not grade properly and you may lose a significant number of points. Note: When you are finished with this step, your presentation should contain 10 slides. option to import the Top't Corn Outline for Import file. Return to the PowerPoint presentation you downloaded from Import the Top't Corn Outline for Import Word file into OF2016-Integrated-Project1 presentation. Save the document with the name Top't Corn Outline for Import. Change the color theme of the document to Orange Red. Apply the Heading 2 style to the lettered items in the list. (Downloaded from the Resources link.) Apply the Heading 1 style to numbered items in the list.
#INTEGRATION PROJECT OFFICE 2016 ANSWERS DOWNLOAD#
1 | Page Last Modified: 2/26/18 Word, Excel, Access, and PowerPoint Integrated Project 1 Download Resources Open the Top't Corn Outline Word document from the location where you saved the data files for this project. Change the project file name if directed to do so your instructor, and save it. The file will be renamed automatically to include your name. If the document opens in Protected View, click the Enable Editing button in the Message Bar at the top of the document so you can modify it. Open the start file OF2016-Integrated-Project1. Please visit Instant Help for step- by-step instructions. Be sure to extract the file after downloading the resources zipped folder. Apply a chart style Step 1 Download start file IMPORTANT: Download the resource file needed for this project from the Resources link.Create PivotTable using a Recommended PivotTable.Use an absolute reference in a formula.Export data from a query to Excel Excel Skills.Create simple select query to combine fields from multiple tables.Add records to a table by importing from Excel.Skills needed to complete the project: Word Skills Apply heading styles,Change the font theme, PowerPoint Skills,Import slides from a Word outline,Change the font,Align text,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, Access Skills Finally, you will copy and paste the chart and table data from Excel into your PowerPoint presentation. You will export the query results to a new Excel workbook where you will add formulas and create table and a chart. Next, you will import data from Excel into an Access database and then create two queries based on that imported data. You will format the look of the text before and after importing and use Format Painter to copy and paste formatting between slides. First, you will format an outline in Word so it can be imported as slides and content for the presentation. Office 2016 Integrated Applications - Project 1 Creating a Company's Presentation Word, Excel, Access, and PowerPoint Integrated Project 1 In this project, you will create presentation for the Top't Corn popcorn company using resources from a Word document, an Access database, and two Excel files.