The following are the minimal requirements to complete each homework assignment.

• Required course textbook
• Microsoft Office Suite 2013 (PC) or 2011 (Mac) software or more recent
• Windows Operating System: Windows 7 or more recent is recommended

Complete the weekly homework based on the following:

1. Complete the On Your Own project according to the project instructions and submit your assignment through the online course shell.Note: It is important to note that some On Your Own projects request a printed or self-submitted document.Students completing this course online or in a physical classroom must submit the assignment through the online course shell regardless of the textbook submission instructions.
2. Submit your assignment in the appropriate MS Office application using the filename “Last name_First initial_OYO#.htm”.For example:if your name is Mary Smith, the file for the On Your Own project 9-1 should be saved as Smith_M_9-1.docx
3. Include a footer, which indicates the date and your course section.
4. Include a title page, which indicates your name, course section, professor name, and title of assignment.
5. Write a short answer for each On Your Own project. Submit the written portion in the text box located in the assignment submission link. In your written portion, you must respond to the following:

a. Summarize the technical experiences in completing the On Your Own project in two to three (2-3) sentences.
b. Identify the greatest skill learned in the assignment and how it will benefit you in the real world in two to three (2-3) sentences.
c. Provide general comments on the overall assignment experience in two to three (2-3) sentences.CMPTR2 Chapter 22: Integrating Word, Excel, Access, and PowerPoint On Your Own
On Your Own 22-1
1. Open the Excel data file
ZooNumbers located in the Chapter located in the Chapter 22\On Your 22\On Your Own folder. Save the Own folder. Save the document as workbook as Zoo Visitor Numbers. Zoo Customer Letter. 2. Open the PowerPoint data file 8. In the Excel file Zoo Visitor ZooPresentation located in the Numbers, copy the column chart to Chapter 22\On Your Own folder. the Clipboard. Add your name as the subtitle, and 9. In the Word document Zoo then save the presentation as Zoo Customer Letter, delete the yellow Slide Show. highlighted text, and then link the 3. In the Excel file Zoo Visitor copied chart to the document using Numbers, copy the column chart to the destination theme. Resize the the Clipboard. chart so that it is approximately 2.5 4. Link the copied chart to Slide 2
(“Number of Visitors”) using the
destination theme. Resize the chart
object to fill the slide.
5. In the Excel file Zoo Visitor inches high and the same width as
the paragraphs.
10. In the Excel file Zoo Visitor
Numbers, change the number of
Adult visitors in 2015 to 710 and Numbers, add the following data as then change the number of the number of visitors in 2015: 648, Children who visited in 2015 to 1411, 173, and 80. 1500. Save the file. 6. Save the changes to the Excel file 1 7. Open the Word data file ZooLetter 11. Open the Excel data file Zoo Visitor Numbers, and then ZooAnimals located in the Chapter update the chart in the PowerPoint 22\On Your Own folder. Save the file Zoo Slide Show if needed. workbook as Zoo Animals by Type. On Your Own 22-1 CMPTR2 Chapter 22: Integrating Word, Excel, Access, and PowerPoint 12. Prepare the Excel file Zoo Animals
by Type file for importing into
Access. Add Species as the column
A label. Save and close the file.
13. Create a new Access database
named ZooData. Import the Excel the Access file ZooVisitors as the
data source.
18. Edit the recipient list by sorting the
customers alphabetically by last
name.
19. Insert the Address Block and file Zoo Animals by Type to a new Greeting Line merge fields, table named Animals. matching fields if necessary. In the 14. Create four queries, each listing all Greeting Line merge field, change the animals in one species. Do not the form of the name to the first show the Species field. Save each name, and change the form of query with the name of the species greeting line for records with an included. Resize columns as invalid recipient name to Dear needed in the query results. Guest,. 15. Open the Office Clipboard, and 20. In the body of the letter, replace the then copy the query results for each green highlighted text with the of the four queries to the Office Date_Visited merge field. Clipboard.
16. Paste each query into the
appropriate slide in the PowerPoint
file Zoo Slide Show using the Text
Only paste option. (Hint: Select the 21. Preview the merged document, and
then correct any spacing issues.
22. In the closing, replace Karl Croston
with your name.
23. Turn the preview off, merge only Keep Text Only option after you the first and second letter of the paste the objects. On each slide, mail merge to a new document, and delete the Type bulleted item, then save the new document as Zoo increase the size of the items in the Letters. list to 24 points, and left-align the
list text box with the title text box. 24. Close all open documents, saving
when prompted. 17. Use the Word file Zoo Customer
Letter to create a form letter using 2 On Your Own 22-1 CMPTR2 3 Chapter 22: Integrating Word, Excel, Access, and PowerPoint On Your Own 22-1CMPTR2 Chapter 22: Integrating Word, Excel, Access, and PowerPoint On Your Own
On Your Own 22-1
1. Open the Excel data file
ZooNumbers located in the Chapter located in the Chapter 22\On Your 22\On Your Own folder. Save the Own folder. Save the document as workbook as Zoo Visitor Numbers. Zoo Customer Letter. 2. Open the PowerPoint data file 8. In the Excel file Zoo Visitor ZooPresentation located in the Numbers, copy the column chart to Chapter 22\On Your Own folder. the Clipboard. Add your name as the subtitle, and 9. In the Word document Zoo then save the presentation as Zoo Customer Letter, delete the yellow Slide Show. highlighted text, and then link the 3. In the Excel file Zoo Visitor copied chart to the document using Numbers, copy the column chart to the destination theme. Resize the the Clipboard. chart so that it is approximately 2.5 4. Link the copied chart to Slide 2
(“Number of Visitors”) using the
destination theme. Resize the chart
object to fill the slide.
5. In the Excel file Zoo Visitor inches high and the same width as
the paragraphs.
10. In the Excel file Zoo Visitor
Numbers, change the number of
Adult visitors in 2015 to 710 and Numbers, add the following data as then change the number of the number of visitors in 2015: 648, Children who visited in 2015 to 1411, 173, and 80. 1500. Save the file. 6. Save the changes to the Excel file 1 7. Open the Word data file ZooLetter 11. Open the Excel data file Zoo Visitor Numbers, and then ZooAnimals located in the Chapter update the chart in the PowerPoint 22\On Your Own folder. Save the file Zoo Slide Show if needed. workbook as Zoo Animals by Type. On Your Own 22-1 CMPTR2 Chapter 22: Integrating Word, Excel, Access, and PowerPoint 12. Prepare the Excel file Zoo Animals
by Type file for importing into
Access. Add Species as the column
A label. Save and close the file.
13. Create a new Access database
named ZooData. Import the Excel the Access file ZooVisitors as the
data source.
18. Edit the recipient list by sorting the
customers alphabetically by last
name.
19. Insert the Address Block and file Zoo Animals by Type to a new Greeting Line merge fields, table named Animals. matching fields if necessary. In the 14. Create four queries, each listing all Greeting Line merge field, change the animals in one species. Do not the form of the name to the first show the Species field. Save each name, and change the form of query with the name of the species greeting line for records with an included. Resize columns as invalid recipient name to Dear needed in the query results. Guest,. 15. Open the Office Clipboard, and 20. In the body of the letter, replace the then copy the query results for each green highlighted text with the of the four queries to the Office Date_Visited merge field. Clipboard.
16. Paste each query into the
appropriate slide in the PowerPoint
file Zoo Slide Show using the Text
Only paste option. (Hint: Select the 21. Preview the merged document, and
then correct any spacing issues.
22. In the closing, replace Karl Croston
with your name.
23. Turn the preview off, merge only Keep Text Only option after you the first and second letter of the paste the objects. On each slide, mail merge to a new document, and delete the Type bulleted item, then save the new document as Zoo increase the size of the items in the Letters. list to 24 points, and left-align the
list text box with the title text box. 24. Close all open documents, saving
when prompted. 17. Use the Word file Zoo Customer
Letter to create a form letter using 2 On Your Own 22-1 CMPTR2 3 Chapter 22: Integrating Word, Excel, Access, and PowerPoint On Your Own 22-1

• 1493783418-Contacts19.accdb

ComputerScienceExpert

(11)

Status NEW Posted 03 May 2017 03:05 AM My Price 11.00

-----------

Attachments

file 1493783420-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer