Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Office 2016 integrated applications project 2 word access excel

22/10/2021 Client: muhammad11 Deadline: 2 Day

Office 2016 Integrated Applications – Project 2 Creating a Company Report In this project, you will create a company report for the Top’t Corn popcorn company using resources an Access

database and two Excel files. First, you will format the Word document, applying a theme, applying styles and text

formatting, formatting a table, and applying list formats. You will enter document information and add a cover page.

Next, you will add a header and add page numbers to the report using Word’s built-in building blocks. 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 Word document.

Skills needed to complete this project:

Word Skills

• Change the theme and color theme

• Apply heading styles

• Apply character formatting

• Create numbered and bulleted lists

• Display text in columns

• Add a row to a table

• Enter data in a table

• Apply a table Quick style

• Change document information

• Insert a cover page

• Add a header

• Add page numbers

• Paste data from Excel

• Change font color

• Paste a chart from Excel

Access Skills

• 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

Excel Skills

• 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

• AutoFit columns

• Create a PivotTable using a Recommended PivotTable

• Create a pie chart

• Hide the chart title

• Apply a chart style

• Display chart data labels

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.

1. Open the start file OF2016-Integrated-Project2. 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.

2. The file will be renamed automatically to include your name. Change the project file name if directed to do

so by your instructor, and save it.

Step 1

Download start file

SIMnet 2016: Word, Excel, and Access Integrated Project 2

2 | P a g e Last Modified: 9/27/17

3. Apply and theme and change theme colors.

a. Apply the Slice theme to the document.

b. Change the color theme to the Orange Red theme.

c. Change the font theme to the Calibri theme.

4. Format text in the document.

a. Apply the Heading 1 style to the Overview and Goals headings on the first page of the document.

b. Apply the Heading 2 style to the Brick and Mortar Stores and the Food Truck Locations headings on page 2

of the document.

c. Scroll to the Our Top’t 4 Sellers section and bold the following words at the beginning of each line:

Original Blend, Old Bay, Sea Salt and Caramel, and Truffle.

d. Convert the four items in the Our Top’t 4 Sellers section into a numbered list using the 1), 2), 3) format.

e. Scroll to the Future Flavors section and bold the following words at the beginning of each line: Choco

Mocha, Raspberry Delight, Key Lime, and Spicy Buffalo.

f. Convert the four items in the Future Flavors section into a bulleted list using the four diamond format.

g. Select the text below the Brick and Mortar Stores heading (from Montgomery Mall to M&T Bank Stadium)

and change the text so it appears in two columns.

h. Select the text below the Food Truck Locations heading (from Farragut Square to National Mall West) and

change the text so it appears in two columns.

5. Work with a table in the document.

a. Navigate to the table in the Pricing section.

b. Add a row to the end of the table.

c. Type Gift Packaging in the first cell of the new row.

d. Type $2 in the second cell of the new row.

e. Change the Table Quick Style options to only show Quick Styles with a header row. Apply a Grid Table

4 - Accent 1 Quick Style to the table. It is in the Grid Styles section of the gallery.

6. Add document information and insert a cover page.

a. Display the Info page in Backstage view and add The Top’t Corn Report as the title of

the document.

b. Add Top’t Corn Company as the company.

c. Add Poppy Cunningham as the author.

d. Return to the document and place the cursor at the beginning of the Overview heading.

e. Insert a cover page using the Austin option.

f. Delete the abstract control at the top of the page (the text control beginning with Draw you reader in…).

g. Click the Document Subtitle control and type Gourmet Popcorn with Capitol

Toppings

SIMnet 2016: Word, Excel, and Access Integrated Project 2

3 | P a g e Last Modified: 9/27/17

7. Add a header and page numbers to the document.

a. Place the cursor at the beginning of the Overview heading.

b. Add a header using the Sideline option.

c. Add page numbers to the bottom of the document using the Accent Bar 3 option.

d. Verify that the header and footer text does not appear on the cover page.

e. Close the Header and Footer view when you are done.

8. 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.)

a. Import records from the Excel file Nov4Sales (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 133 records in

the OnlineSales table.)

b. In the OnlineSales table, rename the ID field: OnlineSaleID

9. 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.

a. Include the following fields in this order: OnlineSaleID, Date, Quantity, and State fields from the

OnlineSales table and the ItemName field from the Items table.

b. 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 1, 2016. Run the query to check your work.

(Hint: There should be 8 records in the query results.)

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

d. Run the query again to check your work.

e. Save the query as OldBayMDQry and then close the query.

f. Export the results of the OldBayMDQry 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.

10. Create a query to display sales of truffle flavored popcorn with a quantity greater than six from the

OnlineSales table.

a. Include the following fields in this order: State and Quantity from the OnlineSales table and

ItemName field from the Items table.

b. Add criteria to the query to limit the results to records where the Item Name is Truffle and the

Quantity is greater than 4.

c. 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 17 records in the query results.)

d. Save the query as HighQuantityTruffleQry and close it.

SIMnet 2016: Word, Excel, and Access Integrated Project 2

4 | P a g e Last Modified: 9/27/17

e. 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.

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

11. Open the OldBayMdSales Excel file you just created and create a table to copy into Word.

a. In cell D1, type: Total Sale

b. In cell A11, type: Price per Box

c. In cell B11, type: $9.00

d. In cell D2, enter a formula to calculate the total sale. Multiple the quantity sold (cell C2) by the price per

box (cell B11). You are going to copy this formula to cells D3:D9, so use relative and absolute references

as appropriate.

e. Copy the formula in cell D2 to cells D3:D9.

f. Format the data in cells A1:D9 as a table using any style.

g. Sort the table data by quantity so the largest value is at the top.

h. In cell A12, type: Average Quantity

i. Enter a formula in cell B12 to calculate the average of cells C2:C9.

j. In cell A13, type: Total Sales

k. Enter a formula in cell B13 to calculate the sum of cells D2:D9.

l. Apply the Currency number format to cell B13.

m. Select cells A1:D9 and change the font size to 14.

n. Autofit all columns so the data are completely visible.

o. Save Excel file.

p. Copy cells A1:D13. Do not close the Excel file.

12. Return to the Word document and use the Paste Special command to paste data.

a. Place the cursor in the blank line under the first paragraph in the Maryland Sales of Old Bay Flavor section.

b. Paste the copied Excel data using Keep Source Formatting option into the document.

c. Return to Excel and close the OldBayMdSales file.

13. Open the HighQuantityTruffleSales Excel file you created in step 10. e. and create a chart from the data.

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

by State.

b. Create a 2-D pie chart from the PivotTable data.

c. Hide the chart title.

d. Apply the chart Quick Style Style 4.

e. Display chart data labels using the inside end option.

SIMnet 2016: Word, Excel, and Access Integrated Project 2

5 | P a g e Last Modified: 9/27/17

f. Save the file.

g. Copy the chart. Do not close the Excel file.

14. Return to the Word document and paste the chart.

a. Place the cursor in the blank line under the first paragraph in the Sales by State for Truffle section.

b. Paste the chart you copied from Excel into the document. Use the Keep Source Formatting &

Embed Workbook paste option.

IMPORTANT: If you receive an error message similar to "Word cannot obtain the data for the {00020830-

0000-C000-000000000046} link.", make sure that you have extracted the HighQuantityTruffleSales Excel

workbook from the resources zip folder and open the workbook from the extracted folder, save your Word file,

and then try again.

c. Save and close the document.

d. Return to Excel and close the HighQuantityTruffleSales file.

15. Upload and save your project file.

16. Submit project for grading. Step 2 Upload & Save

Step 3

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Smart Homework Helper
Unique Academic Solutions
Financial Analyst
Exam Attempter
Top Quality Assignments
A+GRADE HELPER
Writer Writer Name Offer Chat
Smart Homework Helper

ONLINE

Smart Homework Helper

After reading your project details, I feel myself as the best option for you to fulfill this project with 100 percent perfection.

$18 Chat With Writer
Unique Academic Solutions

ONLINE

Unique Academic Solutions

I can assist you in plagiarism free writing as I have already done several related projects of writing. I have a master qualification with 5 years’ experience in; Essay Writing, Case Study Writing, Report Writing.

$35 Chat With Writer
Financial Analyst

ONLINE

Financial Analyst

I have written research reports, assignments, thesis, research proposals, and dissertations for different level students and on different subjects.

$41 Chat With Writer
Exam Attempter

ONLINE

Exam Attempter

I will be delighted to work on your project. As an experienced writer, I can provide you top quality, well researched, concise and error-free work within your provided deadline at very reasonable prices.

$45 Chat With Writer
Top Quality Assignments

ONLINE

Top Quality Assignments

As per my knowledge I can assist you in writing a perfect Planning, Marketing Research, Business Pitches, Business Proposals, Business Feasibility Reports and Content within your given deadline and budget.

$36 Chat With Writer
A+GRADE HELPER

ONLINE

A+GRADE HELPER

This project is my strength and I can fulfill your requirements properly within your given deadline. I always give plagiarism-free work to my clients at very competitive prices.

$29 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Cpa plus network complaints - Cultural web analysis of samsung - POWER POINT - Ncr country club dues - Chcprp001 - Tv edwards mile end - Absolute location of cape town south africa - Implement financial management approaches - Econometrics HW - Summary of major counseling theories - Hillhead high school teachers - Calculate the missing amounts in the following table - Barrier Analysis Worksheet Project - Advanced Industrial Hygiene - Stocks vs mutual funds venn diagram chapter 8 answer key - New York City Challenges - Mile one seating chart hey rosetta - Discussion(Responses) 2. 3 & 4 - 593 boat harbour drive urangan qld - Vce statement of marks - History assignments - THIS IS UNDENIABLE HEALTH O835179056 SAFE ABORTION CLINIC//PILLS IN DURBAN STANGER PMB QWAQWA ESHOWE ESTCOURT UMLAZI PINETOWN - Defusement - 8 7 7 7 ielts score meaning - QA and EC paper - Mcgill vision research unit - There is a longing chief dan george poem - 6. 7 Discussion 3: International Trade --econ discussion - How customers think gerald zaltman - Health promotion - Example of entertainment speech - Terms and conditions may apply film - Farah chatelier - Uipath latest version 2020 - Jones electrical distribution case solution excel - Equations - Psychotherapy with individual - Sample space diagram worksheet - N492 Discussion Mod 2: - Animal farm chapter 1 questions and answers - Strong pressures for local responsiveness emerge when - Nursing - Migrant information centre ringwood - Ids 100 presentation learning disabilities - Unchopping a tree question answer - How to calculate productivity in nursing - Joinder of claims and parties - How do i make a brochure in word - Informative speech on food allergies - Macroeconomics multiple choice questions and answers 2012 - What is the purpose of simple staining - Assumptions of capital structure theories - Case study on csr of tata - Morgan county jail indiana - Close reading strategies for high school - The rainbow fish questions and answers - 8500: Discussion 1-2 - Po box 6431 alexandria nsw - Pestle analysis of healthcare industry in usa - Quantitative Design - Boston public schools managerial tier c - 2.00 a day chapter summaries - Epidemiology for public health practice 5th edition test bank - Rewrite in professional way - Malapropism much ado about nothing - Project - Message of truman show - Calculate the length of ac - 4036 w lane ave phoenix az 85051 - Etsy business model and revenue model - Blood test riverside ipswich - Q - Dia construction security plan worksheet - Learn labview in 6 hours - Bus 475 week 3 individual assignment - Joseph juran definition of quality - Assignmenttt - Sample syllabus for art appreciation - What is document conventions in srs - Norman walker juice book pdf - Identifying Value and Assessing Confidence - Knock knock by daniel beaty answers - Ernie owns a water pump - Electric field mapping lab report theory - Race one motors is an indonesian car manufacturer - Ken whisson australian artist - Toll priority alice springs - The pediatrician described jason's pharynx - 4360 risk management standard - Factor tree of 30 - Unit VII Schorlaly Act Amer Hys - What is srs in statistics - Sample bar mitzvah invitation wording - Features of a dystopia - Analyze OD consultant job description - Jdsu hst 3000 t1 testing - Costco wholesale corporation case study - Itw patent society - 5 PAGes ESSAY - Socio-Economic and Legal Environment