How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Steve Herrod Your Own Question

Steve Herrod
Steve Herrod, Masters Degree
Category: Homework
Satisfied Customers: 2495
Experience:  BA (Hons) & MA Qualifications
65126503
Type Your Homework Question Here...
Steve Herrod is online now
A new question is answered every 9 seconds

here are the others

Resolved Question:

here are the others
Submitted: 1 year ago.
Category: Homework
Expert:  Steve Herrod replied 1 year ago.

Steve Herrod :

Thanks, XXXXX XXXXX upload details and I can review when back in front of my laptop later today

Customer:

INTRODUCTION


Now that you’ve completed the Microsoft Access study unit,


you’re ready to complete your graded project. As you work


through this project, you’ll apply your recently learned


Access skills to create and use a home inventory database.


A home inventory database can serve many useful applications


in today’s society. It allows you to access important


information regarding your purchases without having to sort


through a paper file of merchant receipts. This will minimize


damage and loss of important receipts, which you may need


to produce to get warranty service. Keeping a copy of your


database offsite, such as in a safety-deposit box or with family


or friends, will allow you to hand a detailed printout of your


possessions to an insurance adjuster in case of theft, fire, or


other disaster. Over time, you may wish to add more tables


to the database for different purposes. For example, you may


use the Table Query function in Access to subdivide your


database by item category.


GRADED PROJECT


In this graded project, you’ll create a home inventory database


based upon fictitious information provided in this booklet.


Using this data, you’ll also perform queries and create reports.


Your Access project will consist of the following items:


1. Two data tables


2. Two data entry forms


3. Simple query and report


4. Multiple-table query and report


 


Creating a Database


Create and save a new blank database called Inventory.accdb


as shown in Figure 1. Then, use the following steps to work


with your database. (Your new database screen will appear


slightly different than the figure, depending on the files


Create the table “Inventory” in Design View with the


following data fields:


1. Item Number (auto-generated) (Figure 2)


2. Item Name (such as computer or washing machine)


3. Item Category (such as Appliances or Electronics)


4. Item Manufacturer


2 Micros


5. Item Model Number


6. Item Serial Number


7. Purchase Date


8. Purchase Price


9. Merchant ID


10. Online/Mail Order (Yes/No)


11. Credit Card Purchase (Yes/No)


12. Warranty Type (store, manufacturer, both)


13. Warranty Length


14. Repair (Yes/No)


15. Repair Date


16. Comments


• Set the Item Number field as the primary key


• Create a new form using the Form Wizard. The form is


based upon the Inventory table, titled “Inventory.” Use


all the fields from the Inventory table. The form should


possess the Columnar layout.


• Input the inventory information listed at the end of this


booklet into your database. Use the current year for


dates marked 20XX.


• Create the table “Merchants” with the following data


fields:


1. Merchant ID


2. Merchant Name


3. Merchant Address


4. Merchant City


5. Merchant State


6. Merchant ZIP


7. Merchant E-Mail


8. Merchant URL


9. Merchant Phone


10. Merchant Fax


• Set the Merchant ID field as the primary key.


• Create a new form using the Form Wizard and based


upon the Merchants table, titled “Merchants.” Use all


the fields from the Merchants table. The form should


possess the Columnar layout.


• Input the merchant information listed at the end of this


booklet into your database.


After you’ve entered all the information into your database


tables, save the Inventory.accdb file. If you have a printer,


print a hard copy of your inventory table and a copy of your


data entry form. Check your work for errors. Your project


grade will be based in part on the accuracy of your work.


Creating a Simple Database Query


Create a simple query on the Inventory table (Figure 4). The


query should include data entries only for items that have


been repaired. Include the following fields:


1. Item Number


2. Item Name


3. Item Category


4. Item Manufacturer


5. Purchase Date


6. Warranty Type


7. Warranty Length


8. Repair


9. Repair Date


10. Comments


The data within the query should be sorted alphabetically by


Item Category. Save the query as Repaired Items.


Microsoft Access


Based on the data contained in the query Repaired Items,


create a report with the Report Wizard using all the fields from


the query. No grouping levels are required in this report. Sort


in ascending order by Item Name (Figure 5). The report


should have the following format:


• Columnar layout


• Portrait orientation


Title the report Repaired Items List. Make sure all of the


fields show clearly in the report, including the field titles.


After you’ve completed the simple query and report, resave


the Inventory.accdb file onto the disk and your hard drive.


If you have a printer, print a hard copy of your simple query


and report. Again, check your work carefully for errors,


because the project grade will be based in part on the


accuracy of your work.


Creating a Multiple-Database Query


Create a multiple-table query on the Inventory and Merchants


tables. To create this query, you must establish a relationship


between the two tables (Figure 6). The common field between


the tables is Merchant ID. Both fields should be set to text in


their respective tables. Now you may begin to build your


query. Include the following fields from the Inventory table:


1. Item Name


2. Item Category


3. Item Manufacturer


4. Purchase Date


Graded


Include the following fields from the Merchants table:


1. Merchant Name


2. Merchant Address


3. Merchant City


4. Merchant State


5. Merchant ZIP


The data within the query should be sorted alphabetically by


Merchant Name. Set the criteria cell for the Item Category


field to search for “Appliances.” Save the query as Appliance


Store Purchases.


Based on the data contained in the Appliance Store


Purchases query, create a report with the Report Wizard


using the following fields from the query (Figure 7):


1. Item Name


2. Item Category


3. Item Manufacturer


4. Purchase Date


5. Merchant Name


6. Merchant Address


7. Merchant City


8. Merchant State


9. Merchant ZIP


8View the data by Merchants. No grouping levels are required


in this report. Sort detail records in ascending order by


Purchase Date. Format the report as follows:


• Stepped


• Landscape orientation


Title the report Appliance Store Purchases List. Make sure all


the fields show clearly in the report, including the field titles


After you’ve completed the multiple-table query and report,


resave the Inventory.accdb file onto the disk and your hard


drive. If you have a printer, print a hard copy of your simple


query and report. Again, check your work carefully for errors.


INFORMATION FOR YOUR GRADED PROJECT


Use the information listed below to create the Inventory database.


Item Number 1


Item Name: VCR


Item Category: Electronics


Item Manufacturer: Super


Item Model Number: VCR2000


Item Serial Number: XXXXXXXXXX /p>

Purchase Date: 02/01/20XX


Purchase Price: $199.95


Merchant ID: 1


Online/Mail Order: No


Credit Card Purchase: Yes


Warranty Type: Manufacturer


Warranty Length: 60 days parts/labor


Repair: No


Repair Date: (none)


Comments: (none)


Item Number: 2


Item Name: Television


Item Category: Electronics


Item Manufacturer: Telecom


Item Model Number: TV100


Item Serial Number: XXXXXXXXX /p>

Purchase Date: 02/14/20XX


Purchase Price: $299.95


Merchant ID: 1


Online/Mail Order: No


Credit Card Purchase: Yes


Warranty Type: Manufacturer


Warranty Length: 90 days parts/labor


Repair: Yes


Repair Date: 09/01/20XX


Comments: Remove candy from


controls


Item Number: 3


Item Name: Personal Computer


Item Category: Computers


Item Manufacturer: Deluxe


Item Model Number: PC1000


Item Serial Number: XXXXXXXXX /p>

Purchase Date: 02/01/20XX


Purchase Price: $1,299.95


Merchant ID: 6


Online/Mail Order: Yes


Credit Card Purchase: Yes


Warranty Type: Manufacturer


Warranty Length: 1 year parts/labor/tech


support


Repair: No


Repair Date: (none)


Comments: (none)


Item Number: 4


Item Name: CD-ROM Drive


Item Category: Computers


Item Manufacturer: Deluxe


Item Model Number: CD200


Item Serial Number: 11233211


Purchase Date: 01/02/20XX


Purchase Price: $199.95


Merchant ID: 6


Online/Mail Order: Yes


Credit Card Purchase: Yes


Warranty Type: Manufacturer


Warranty Length: 1 year parts/labor/tech


support


Repair: No


Repair Date: (none)


CoItem Number: 5


Item Name: Ink-Jet Printer


Item Category: Computers


Item Manufacturer: Stylus


Item Model Number: IJ750


Item Serial Number: XXXXXXXXX /p>

Purchase Date: 01/02/20XX


Purchase Price: $169.95


Merchant ID: 6


Online/Mail Order: Yes


Credit Card Purchase: Yes


Warranty Type: Manufacturer


Warranty Length: 90 days parts/labor/


tech support


Repair: Yes


Repair Date: 05/15/20XX


Comments: Replace defective print


head


Item Number: 6


Item Name: Refrigerator


Item Category: Appliances


Item Manufacturer: Wonderlux


Item Model Number: Deep Freeze 250


Item Serial Number:(NNN) NNN-NNNN/p>

Purchase Date: 04/01/20XX


Purchase Price: $750.00


Merchant ID: 2


Online/Mail Order: No


Credit Card Purchase: Yes


Warranty Type: Manufacturer/store


Warranty Length: 90 days/1 year


parts/labor


Repair: No


Repair Date: (none)


Comments: (none)


Item Number: 7


Item Name: Washing Machine


Item Category: Appliances


Item Manufacturer: General Appliance


Item Model Number: CL900


Item Serial Number: 90050221


Purchase Date: 12/19/20XX


Purchase Price: $450.00


Merchant ID: 2


Online/Mail Order: No


Credit Card Purchase: Yes


Warranty Type: Manufacturer


Warranty Length: 1 year parts/labor


Repair: No


Repair Date: (none)


Comments: (none)


Item Number: 8


Item Name: Clothes Dryer


Item Category: Appliances


Item Manufacturer: General Appliance


Item Model Number: DR199


Item Serial Number: XXXXXXXXX /p>

Purchase Date: 01/19/20XX


Purchase Price: $599.95


Merchant ID: 2


Online/Mail Order: No


Credit Card Purchase: Yes


Warranty Type: Manufacturer


Warranty Length: 1 year parts/labor


Repair: Yes


Repair Date: 06/09/20XX


CommeItem Number: 9


Item Name: Dishwasher


Item Category: Appliances


Item Manufacturer: Washmatic


Item Model Number: DW19


Item Serial Number: XXXXXXXXXXX /p>

Purchase Date: 08/12/20XX


Purchase Price: $275.00


Merchant ID: 3


Online/Mail Order: No


Credit Card Purchase: Yes


Warranty Type: Manufacturer


Warranty Length: 1 year parts/labor


Repair: No


Repair Date: (none)


Comments: (none)


Item Number: 10


Item Name: Digital Camera


Item Category: Computers


Item Manufacturer: Snapic


Item Model Number: Snap100


Item Serial Number:(NNN) NNN-NNNN/p>

Purchase Date: 01/02/20XX


Purchase Price: $225.00


Merchant ID: 4


Online/Mail Order: No


Credit Card Purchase: No


Warranty Type: Manufacturer


Warranty Length: 60 days parts/labor


Repair: No


Repair Date: (none)


Comments: (none)


Item Number: 11


Item Name: 35mm Camera


Item Category: Photo Equipment


Item Manufacturer: Camco


Item Model Number: SLR75


Item Serial Number: XXXXXXXXX /p>

Purchase Date: 05/20/20XX


Purchase Price: $199.95


Merchant ID: 4


Online/Mail Order: No


Credit Card Purchase: No


Warranty Type: Manufacturer


Warranty Length: 60 days parts/labor


Repair: No


Repair Date: (none)


Comments: (none)


Item Number: 12


Item Name: Zoom Lens


Item Category: Photo Equipment


Item Manufacturer: Camco


Item Model Number: Zoom10


Item Serial Number: 351


Purchase Date: 02/20/20XX


Purchase Price: $125.00


Merchant ID: 4


Online/Mail Order: No


Credit Card Purchase: No


Warranty Type: Manufacturer


Warranty Length: 30 days parts/labor


Repair: Yes


Repair Date: 03/10/20XX


Comments: Replaced defectints: Replaced gas nozzlemments: (none


Item Number: 13


Item Name: Gold Chain


Item Category: Jewelry


Item Manufacturer: Goldstuff


Item Model Number: n/a


Item Serial Number: n/a


Purchase Date: 02/12/20XX


Purchase Price: $500.00


Merchant ID: 5


Online/Mail Order: No


Credit Card Purchase: Yes


Warranty Type: n/a


Warranty Length: n/a


Repair: No


Repair Date: (none)


Comments: 24-karat gold, 24″ long,


serpentine links


Item Number: 14


Item Name: Engagement Ring


Item Category: Jewelry


Item Manufacturer: Jewelserv


Item Model Number: n/a


Item Serial Number: n/a


Purchase Date: 02/11/20XX


Purchase Price: $1,500.00


Merchant ID: 5


Online/Mail Order: No


Credit Card Purchase: Yes


Warranty Type: n/a


Warranty Length: n/a


Repair: No


Repair Date: (none)


Comments: 3/4-carat square cut


diamond in 18-karat


gold setting


Item Number: 15


Item Name: Lighter


Item Category: Collectibles


Item Manufacturer: ZIPpy


Item Model Number: 21BT200


Item Serial Number: n/a


Purchase Date: 09/25/20XX


Purchase Price: $100.00


Merchant ID: 7


Online/Mail Order: Yes


Credit Card Purchase: Yes


Warranty Type: n/a


Warranty Length: n/a


Repair: No


Repair Date: (none)


Comments: Original 1950


commemorative edition.


#200 of 500 made.


Appraised at $200.00.


Item Number: 16


Item Name: Candy Dish


Item Category: Collectibles


Item Manufacturer: Jones Glass


Item Category: n/a


Item Serial Number: n/a


Purchase Date: 12/20/20XX


Purchase Price: $250.00


Merchant ID: 7


Online/Mail Order: Yes


Credit Card Purchase: Yes


Warranty Type: n/a


Warranty Length: n/a


Repair: No


Repair Date: (none)


Comments: Cranberry Depression


glass candy dish.


Appraised at $500.00


Use the information listed below to create the Merchants database.


Graded Project 17


Merchant ID: 1


Merchant Name: Electronics Mart


Merchant Address:XXXXX


Merchant City: Blankston


Merchant State: PA


Merchant ZIP: 18454


Merchant E-mail:XXX@XXXXXX.XXX


Merchant URL: http://www.emart.com


Merchant Phone: (XXX) XXX-XXXX


Merchant Fax: (XXX) XXX-XXXX


Merchant ID: 2


Merchant Name: Appliances Inc.


Merchant Address:XXXXX/p>

Merchant City: Blankston


Merchant State: PA


Merchant ZIP: 18454


Merchant E-mail: n/a


Merchant URL: n/a


Merchant Phone: (XXX) XXX-XXXX


Merchant Fax: (XXX) XXX-XXXX


Merchant ID: 3


Merchant Name: Stuff Mart


Merchant Address:XXXXX


Merchant City: Shopville


Merchant State: NY


Merchant ZIP: 10022


Merchant E-mail:XXX@XXXXXX.XXX


Merchant URL: http://www.stuffmart.com


Merchant Phone: (XXX) XXX-XXXX


Merchant Fax: (XXX) XXX-XXXX


Merchant ID: 4


Merchant Name: Photo Barn


Merchant Address:XXXXX/p>

Merchant City: Klossville


Merchant State: PA


Merchant ZIP: 19019


Merchant E-mail:XXX@XXXXXX.XXX


Merchant E-mail:XXX@XXXXXX.XXX


Merchant URL: http://www.snapshot.com


/photobarn


Merchant Phone: (XXX) XXX-XXXX


Merchant Fax: (XXX) XXX-XXXX


Merchant ID: 5


Merchant Name: Jewelry Warehouse


Merchant Address:XXXXX


Merchant City: Platold


Merchant State: NJ


Merchant ZIP: 00050


Merchant E-mail:XXX@XXXXXX.XXX


Merchant URL: http://www.jewelware.com


Merchant Phone: (XXX) XXX-XXXX


Merchant Fax: (XXX) XXX-XXXX


Merchant ID: 6


Merchant Name: Crazy John’s Computers


Merchant Address:XXXXX


Merchant City: Wynnsville


Merchant State: CO


Merchant ZIP: 18888


Merchant E-mail:XXX@XXXXXX.XXX


Merchant URL: http://www.merchandizing


.net/crazy


Merchant Phone: (XXX) XXX-XXXX


Merchant Fax: (XXX) XXX-XXXX


Merchant ID: 7


Merchant Name: Collector’s Emporium


Merchant Address:XXXXX


Merchant City: Oldenburg


Merchant State: PA


Merchant ZIP: 18999


Merchant E-mail: n/a


Merchant URL: n/a


Merchant Phone: (XXX) XXX-XXXX


Merchant Fax: (XXX) XXX-XXXX


 


 


Integrated Projects


for Presentations


INTRODUCTION


Now that you’ve studied how to integrate PowerPoint with


Word and Excel, as well as how to convert presentations, it’s


time to put what you’ve learned into practice. You’ll use the


same concepts and skills featured in your studies to complete


this project, which will be graded by your instructor.


This project involves completing a fictional assignment as the


public relations director for an agency working toward overcoming


the causes of worldwide hunger. This agency, the


Food and Agriculture Organization (FAO) of the United


Nations, is determined to educate the public about the


causes of and solutions for famine. Your supervisor has asked


you to develop a short PowerPoint presentation on worldwide


hunger. Besides being used for group presentations, your


presentation will also be converted to a Web page and placed


on the FAO’s Internet website. The development of your presentation


will involve the following steps:


1. Creating an outline of your presentation


2. Sending this outline to PowerPoint


3. Modifying the design and content of the presentation


4. Generating a slide show


5. Converting the presentation into a video


For this project, you’ll use the Microsoft programs Word,


Excel, and PowerPoint. Detailed instructions for completing


this graded project follow.


1In Word, type the outline for your presentation as shown


in Figure 1. You can apply the outline’s heading styles to


the outline as you’re typing each entry, or you can wait


until after you’re finished typing to apply the styles to the


existing text.


2


FIGURE 1—Note the


different heading styles


that have been applied


to the outline. Apply


these same heading


styles to your outline


using Word’s Styles


found on the Home tab.


World Hunger


What Is Hunger?


Undernutrition


Undernourishment


Malnutrition


Effects of Hunger on Children


Worldwide Locations of Hunger


Locations within Countries


Rural Areas


Slums


Causes of Hunger


Poverty


Disasters


Natural


Caused by Humans


Solutions


Fight Poverty


Harvest and Store Properly


Cooperate


Apply Technology


How to Contact Us


Street Address


E-Mail Address


Follow the steps listed here to send the Word outline to


PowerPoint and save your presentation.


1. Click on the Send to Microsoft PowerPoint button in


the Quick Access toolbar on the upper left of your screen.


If PowerPoint isn’t already running, it will automatically


launch when you click to send your document to


PowerPoint.


2. Save your PowerPoint document as World Hunger.


As shown in Figure 2, each entry that had been formatted


with the Heading 1 style became the title of a new slide, each


entry formatted as Heading 2 became the first level of text on


the Applying a Design Template


So far, PowerPoint has used a very basic design to outline


your presentation. You may now enhance the look of the presentation


by applying a more appealing design to the slides.


PowerPoint’s built-in themes are made for this purpose.


Note that the first slide’s title is the title of the entire presentation.


When applying your design template, you may wish to


distinguish the title of your presentation from the smaller


titles of the remaining slides.


To apply a theme to your presentation, follow the steps


listed here.


1. Click the Design tab. The themes will appear below the


ribbon (Figure 3).


2. Scroll down to find the Parallax design and apply it toslide, and so on.


Adjusting the Title on the First Slide


After you’ve applied the Parallax design template, the first


slide should appear as shown in Figure 4. Note that


PowerPoint has automatically created a large text box to hold


the slide’s bulleted text. However, there will be no bulleted


text on this slide, since its sole function is to introduce the


main title. The title alone should be the focus of this slide.


Follow the steps listed here to bring the title of the introductory


slide to the forefront.


1. Click on the border around the large text box and


delete it.


2. After selecting the title text, enlarge its type size to


60 points.


5


FI3. Point to the border around the title’s text box until the


cursor changes to a four-point arrow. Then, click-anddrag


the text box to reposition it as shown in Figure 5.


Adding Images


Your version of the Clip Art gallery may differ somewhat from


the one used to create the figures in this booklet. However, if


you can’t find the same graphics featured in these examples,


you should be able to find suitable alternatives. Remember


also that you can alter an image’s color or size or crop out a


piece of the image if you choose to.


Now, let’s add some clip art to Slides 1, 5, and 7 of your


presentation. To add these three pieces of clip art, follow the


steps listed here.


1. With Slide 1 displayed in PowerPoint, open the Insert


Online Pictures task pane. Look for an image in Clip Art


suitable for illustrating the title of your presentation,


World Hunger.


2. Click to insert the clip art onto the slid


3. Resize, reposition, or crop the clip art as appropriate


(Figure 6).


• Resizing: When an image is selected, handles


appear on the image’s outer frame. The corner


handles let you expand or shrink the image proportionally.


The other handles let you compress or


elongate the image horizontally or vertically.


• Repositioning: When you hover the mouse pointer


over the image, the pointer changes to a four-point


arrow. Click-and-drag the clip art to reposition


it appropriately.


• Cropping: You can crop a clip art graphic using the


Cropping tool on the Picture toolbar. More information


about cropping is available in PowerPoint’s


Help menu.


4. Click on Slide 5.


5. Look in the Clip Art task pane for an image suitable for


illustrating the contents of Slide 5.


6. Click to insert the clip art.


Graded Project 7


FIGURE7. Resize, reposition, or crop the image appropriately


(Figure 7).


8. Click on Slide 7.


9. Find an image suitable for illustrating the contents of


Slide 7.


10. Click to insert the clip art.


11. Resize, reposition, or crop the clip art appropriately. In


the example shown in Figure 8, the graphic was resized


and moved closer to the “Apply Technology” bullet.


12. Save your changes.


8 Integrated Projects for Presentations


FIGURE 7—The image of a city skyline was used for this slide. Use this image or find another that’s


relevant to the theme of the slide. Remember that PowerPoint allows you to resize, reposition, or


crop clip art for maximum effect.


LINKING TO FILES


Using embedded files or linking to files created in other


programs can sometimes help you in editing and updating


a presentation’s data.


Embedding a Word Table


The following steps are guides to embed a Word file containing


data about the changing numbers of hungry people and


their locations1. Launch Word, and create a table similar to the one


shown in Figure 9.


• Apply the Grid Table 4—Accent 4 table design or


a similar design.


• Merge the top two cells, change the title to Heading 1,


and bold and center it.


• Add shading to the next row, change the text to


Heading 2, and bold it.


2. Save your Word document as Undernourished People.


Now, follow these steps to embed the Word document into


your presentation.


1. If it isn’t already running, launch PowerPoint and open


World Hunger.pptx.


2. Click on Slide 4, “Worldwide Locations of Hunger.”


3. Delete the text box that PowerPoint has added to worldwide.


4. Select Object from PowerPoint’s Insert tab; then select


Create from file in the Insert Object dialog box.


5. Browse until you find the Undernourished People.docx


file, and click OK to embed the document in the slide.


6. Resize and reposition the embedded table and heading


appropriately, as shown in Figure 10.


Linking to an Excel Pie Chart


Now, let’s link to an Excel pie chart to provide some content


for the third slide. This chart will show those areas of the


world afflicted with the most serious cases of undernourished


children, who suffer from a condition known as wasting.


First, follow these steps to create the Excel document.


1. Launch Excel and create the worksheet and pie chart


shown in Figure 11.


2. Save your Excel file as Wasting.


Now, follow these steps to link the pie chart to your


presentation.


1. Launch PowerPoint and click on Slide 3, “Effect of


Hunger on Children.”


2. Switch back to the file named Wasting.


3. Click on the pie chart to select it.


12 Integrated Projects for Presentations


FIGURE4. Right-click and select Copy.


5. Return to Slide 3 of your PowerPoint file and delete the


text box.


6. Using PowerPoint’s Edit menu, click on Paste special. Be


sure to check the Paste link box before you click OK.


7. Resize the frame for the linked pie chart until the image


fits on the slide, as shown in Figure 12.


Adding Hyperlinks


Follow the steps listed here to create hyperlinks for the


bulleted text on the last slide of your presentation.


1. Click on Slide 8 in your presentation.


2. On Slide 8, highlight the first bulleted blurb,


“Street Address.”


3. Click Hyperlink from the Insert tab. The Insert


Hyperlink dialog box appears.


Graded Project 13


FIGURE 12—Place the p4. In the Address field, enter the following URL:


http://coin.fao.org/cms/do/en/index.html as shown


in Figure 13. This is the Internet address for the online


listing of the FAO’s regional offices.


5. Click OK to insert the hyperlink and close the dialog


box. The highlighted text should change color and


become underlined, indicating that it’s a workable


hyperlink.


6. Now highlight the second bulleted blurb, “E-mail


Address.”


7. Insert your e-mail address as a hyperlink, and close the


Insert Hyperlink dialog box. Note in Figure 14 how the


address is preceded by “mailto.” You need that instruction


for the link to function as ADDING NOTES


Add the following as notes to the presentation’s slides.


(Slide 1) World hunger is a serious problem with no easy


solutions. Every evening, about 800 million people go to


bed hungry. Every day, people worldwide die from hunger


or the various problems caused by hunger.


(Slide 2) The phrase “world hunger” is often used when


referring to a number of conditions: undernutrition,


undernourishment, and malnutrition. In undernutrition,


the people aren’t getting enough nutritious food; in


undernourishment, people are getting less food less than


their energy requirements; and in malnutrition, the people


are eating, but their food isn’t providing the correct


nutrients. .


(Slide 3) Agencies working on solving world hunger often


classify the effects of hunger in children as stunting,


underweight, and wasting. Wasting is the most serious as


it’s a sign of chronic undernourishmean e-mail pathwayie chart onto Slide 3 of your presentation.


(Slide 4) Most hungry people are in India, China, and


other areas of Asia. The sub-Saharan regions of Africa


also have a substantial number of hungry.


(Slide 5) Hungry people can be found in the rural areas of


developing countries as well as in large city slums. Rural


people may have their crops wiped out by


a disaster, or the people may become displaced and prevented


from growing food. Some of these displaced


people move to the cities hoping for a better life with


more opportunity. Often, they end up in a slum where


they still go hungry.


(Slide 6) Worldwide, the greatest cause of hunger is


poverty. People lack the money to buy food and other


necessary provisions. Disasters are related to poverty.


They can plunge new communities into poverty and


worsen the conditions for anyone already existing at


or below the poverty level. Recovery from disasters is


nearly impossible without some financial support.


Natural disasters include floods, earthquakes, droughts,


and so on. Disasters caused by humans are those related


to environmental pollution, industrial accidents, and


wars.


(Slide 7) Finding ways for people to rise above the


poverty level is the best solution to the problem of


hunger. Also, teaching people to harvest and store food


properly can help extend food supplies. Cooperation


among people and governments is another part of the


global solution. Such cooperation can help prevent artificial


disasters and helps in the recovery from natural


catastrophes. Finally, science and technology, if properly


applied, can provide a more abundant and more consistent


food supply. For example, scientists are constantly


developing new and improved food-preservation techniques.


Progress is also being made in raising plant and


animal species that are more robust and produce higher


yields than those currently found in typical farms and


fields.


(Slide 8) Contact us if you would like to be involved. You


can use conventional mail or e-mail. Everyone can do


something to help fight world hunger.


SPECIFYING THE


SLIDE SHOW TRANSITIONS


You now have eight slides to present. From the Slide Sorter


view, specify the transition effects you would like placed


between the slides using the Animations tab (Figure 15).


Experiment with the various transition effects available. You


can try different effects by previewing your slide show.


SAVING THE PRESENTATION


AS A VIDEO


At this point, you’ve essentially completed your presentation.


Now you can save it so people can view it as a video on their


computer or on a website. Follow these steps to convert your


presentation to a video.


1. If it isn’t already running, launch the PowerPoint


program and open World Hunger.pptx.


2. Click Share from Power3. Click Create a Video in the left pane and then Create


Video in the right, as shown in Figure 16.


4. Keep the default options and click Save.


After the video is created, locate and double-click on the file


World Hunger (which is an MPEG-4 video) to view your


presentation (Figure 17). Feel free to change any of the features


of your presentation to better accommodate the way it’s


displayed. For example, you may want to try adding sounds


or altering your transitional effects.


Your video plays in a media player, such as Windows Media


Player.


18INSPECTING YOUR


COMPLETED FILES


Congratulations! You’re now ready to start integrating Office


programs in your own enterprises. In this project, all that’s


left for you to do is inspect your completed files and send


them to the school for grading.


Proofread your work. Check your files for errors. Your project


grade will be based on the accuracy with which you entered


and edited the information. Make sure your final presentation


is free of errors, and that you closely followed the instructions.


Make any necessary corrections, and save your corrected files.


 


 


 


Final Graded Project


Advanced PC


Applications


INTRODUCTION


Welcome to the final part of the course. Now that you’ve worked


with and integrated Microsoft Word, Excel, PowerPoint, and


Access, you’re going to use these skills in a final graded


project. You’ll use many of the concepts and techniques


featured in this course to complete this project, which


your instructor will grade.


Your project is divided into five parts:


1. Creating a database of names and addresses in


Microsoft Access


2. Creating worksheets with Microsoft Excel


3. Creating a presentation with Microsoft PowerPoint


(which includes Excel data) that you’ll prepare to be


shared on the Internet


4. Creating a letter with Microsoft Word


5. Merging your Access database contents with the Word


document


SCENARIO


You work for the marketing department of a store called


Nick’s Sporting Goods. Your boss is impressed with your


Office skills, especially how you can create Internet presentations.


She asks you to create a marketing letter introducing


your store to several potential retailers. The letter will include


a link to presentation to be viewed as a slide show. She’s handed


you a list of names and wants you to add them to a database


so you can easily keep track of these contacts and send


them letters. For the Internet presentation, she wants you


to include data introducing your company and its products,


highlight some best-selling items, and create an order form


for retailers who wish to carry your company’s products.


YOUR TASK


For this project, you’ll create a database using Microsoft


Access in which you’ll input the contact information of potential


customers. Then, you’ll create an order form in Microsoft


Excel. You’ll then create a Microsoft PowerPoint presentation


that will be accessible from your company’s Web site. Then,


you’ll create a marketing letter using Microsoft Word, which


includes the link to the PowerPoint presentation. Lastly, you’ll


merge your Access database contents with your Word letter.


PART 1: CREATING YOUR


ACCESS DATABASE


1. Open Microsoft Access and create a new database.


2. Save the new database as “Nick’s Contacts.”


3. Add the following fields and data types:


Last Name Short text


First Name Short text


Title Short text


Company Name Short text


Address Short text


City Short text


State/Province Short text


ZIP Code Number


Work Phone Number


E-mail Name Short textyour Web site, where you’ll upload a PowerPoint


Advanced PC Applications 3


4. Add contact information for at least five contacts to


your database.


5. Save and close your database (Figure 1).


PART 2: CREATING YOUR


EXCEL WORKSHEETS


1. Open Microsoft Excel and create a new worksheet


2. Save your worksheet as “Nick’s Order Form.”


3. Record the following macro and save it as “Nick”: Using


Arial 14 pt bold font, type “Nick’s Sporting Goods” in


cell A1.


4. Delete “Nick’s Sporting Goods” from cell A1 and then


run the Nick’s Sporting Goods macro to insert the title


back into cell A1.


5. Enter the data into your worksheet as shown in


Figure 2.


Make sure you set your columns to AutoFit so all the


data can be seen.


Enter the figures in columns C and D as currency.


6. In cell D9, create a formula that multiplies B9 by C9.


7. Copy this formula to cells D10–D16.


8. In cell D18, use a function or create a formula that adds


cells D9–D16.


FIGURE 1—Your database should include these fields.


9. In cell D19, use an IF function. The conditions are


• If the number in cell D18 is over 500, then insert 0.


• If the number in cell D18 is under 500, then insert


5% of the number in cell D18 (Hint: D18*.05).


10. In cell D22, use a function or create a formula that adds


cells D18 and D19.


11. Select cells A9–D16 and sort your products alphabetically


by name.


12. In cells E9–E16, use a function or create a formula that


calculates the percentage of sales.


13. Compare your worksheet to Figure 3.


14. SaTo use multiple worksheets, you should follow these steps:


1. With the Nick’s Sporting Goods Order Form Excel sheet still


open, rename the tab labeled Sheet 1 as “Order Form.”


2. Rename the tab labeled Sheet 2 as “Pie Chart.”


3. Press the Pie Chart tab to show this sheet.


4. Run the Nick macro to enter the title into cell A1.


5. In cell B1, type “Best-Sellers.”


6. Create a pie chart using the data from cells A9–A16 and


E9–E16 of your Order Form Worksheet.


• Be sure to choose a pie chart.


• Enter the title as “Best-Sellers.”


• Under Data Labels, include Category Name


and Value From Cells.ve your worksheet.


Hint: To select the data from the Order Form worksheet,


highlight the cells that contain the data when you’re selecting


the data range in your chart wizard as seen in Figure 4.


FIGURE 4—To select data from your Order Form worksheet, include it in the Data range


selection.


7. Enlarge your chart so you can view more of the data.


8. Change the font size to Arial 10 so you can read all the


product names.


9. Move the chart below the worksheet as shown in


Advanced PC Applications 7


PART 3: CREATING YOUR


POWERPOINT PRESENTATION


AND PREPARING IT FOR


THE INTERNET


1. Open Microsoft PowerPoint and create a


new presentation.


2. Save your document as “Nick’s Presentation.”


3. Choose a Design theme and apply it to your slides.


(Figure 6).


FIGURE 5—Your pie4. On your first slide, type Nick’s Sporting Goods, as in


Figure 7. Use Arial font, size 54. Be sure to add an image


representing sporting goods.


5. On your second slide, enter the data as seen in Figure 8. chart should appear similar to the one shown here.


 


 


10 Advanced PC Applications


Create a custom animation in which clip art of a ball


bounces in during the slide show.


9. Create your fifth slide with the text as seen in Figure 11.


Be sure to include your pie chart from the Excel worksheet


you created earlier in this graded project.


11. Create your sixth slide as seen in Figure 12. Be sure to


create a hyperlink to www.nickssportinggoods.com/


order.htm (not an existing site).


12. Save this presentation as a single file Web page that can


be uploaded to the World Wide Web as seen in Figure 13.


FIGURE 11—


Include your


Best-Sellers pie


chart in Slide 5.


FIGURE 12—Type


Slide 6 as you


see here.


 


 


Advanced PC Applications 11


PART 4: CREATING


YOUR LETTER


1. Open Microsoft Word and create a new document.


2. Save your document as “Nick’s Sporting Goods Letter.”


3. Type and format the rest of your letter as shown in


Figure 14. Be sure to


• Type the title “Nick’s Sporting Goods” in Arial font,


size 16.


• Center Nick’s Sporting Goods address information.


• Insert an image representing sporting goods.


• Insert the current date beneath the address. Make


sure you select the Update Automatically option


when inserting the date.


FIGURE 13—Save


your presentation


as a single file


Web page as


seen here.


 


PART 5: MERGING YOUR LETTER


WITH DATABASE DATA


1. Open your Nick’s Sporting Goods letter in Microsoft


Word, if it isn’t already open.


2. Walk through the steps in the Mail Merge Wizard to add


the contactsAdvanced PC Applications 13


3. Complete the merge and compare your letter to


Figure 16. Your letter will include the data from your


Access database.


FIGURE 15—Insert the Address Block and Greeting Line from the Mail Merge Wizard. from your Access database into this letter


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 

Steve Herrod :

Thanks

Steve Herrod :

This is the first file - Inventory Database

Steve Herrod :

Second assignment - World Hunger

Steve Herrod :

Presentation - https://app.box.com/s/posuhtybthzgz6lils1x

Steve Herrod :

Excel File - https://app.box.com/s/n0bzsj6gkb1rahiq1st5

Steve Herrod :

Third assignment - Nick's Sporting Goods

Steve Herrod :

Presentation - https://app.box.com/s/r1wp2juts4qgue72mp62

Steve Herrod :

Excel file - https://app.box.com/s/fwpnlf0n48xbujv53hle

Steve Herrod :

That should be all of them!

Steve Herrod :

Cheers

Steve Herrod :

Steve

Customer:

thank you!

Steve Herrod, Masters Degree
Category: Homework
Satisfied Customers: 2495
Experience: BA (Hons) & MA Qualifications
Steve Herrod and 8 other Homework Specialists are ready to help you

JustAnswer in the News:

 
 
 
Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.
 
 
 

What Customers are Saying:

 
 
 
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
< Last | Next >
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther Woodstock, NY
  • Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know. Robin Elkton, Maryland
  • He answered my question promptly and gave me accurate, detailed information. If all of your experts are half as good, you have a great thing going here. Diane Dallas, TX
 
 
 

Meet The Experts:

 
 
 
  • Manal Elkhoshkhany

    Tutor

    Satisfied Customers:

    4520
    More than 5000 online tutoring sessions.
< Last | Next >
  • http://ww2.justanswer.com/uploads/BU/BusinessTutor/2012-2-2_115741_Kouki2.64x64.jpg Manal Elkhoshkhany's Avatar

    Manal Elkhoshkhany

    Tutor

    Satisfied Customers:

    4520
    More than 5000 online tutoring sessions.
  • http://ww2.justanswer.com/uploads/LI/lindaus/2012-6-10_04811_IMG20120609164157.64x64.jpg Linda_us's Avatar

    Linda_us

    Finance, Accounts & Homework Tutor

    Satisfied Customers:

    3121
    Post Graduate Diploma in Management (MBA)
  • http://ww2.justanswer.com/uploads/ComputersGuru/2010-02-13_051118_Photo41.JPG LogicPro's Avatar

    LogicPro

    Engineer

    Satisfied Customers:

    3035
    Expert in Java C++ C C# VB Javascript Design SQL HTML
  • http://ww2.justanswer.com/uploads/lanis/2009-4-1_233717_phput9xef_c1pm.jpg Lani S.'s Avatar

    Lani S.

    Tutor

    Satisfied Customers:

    2457
    Registered Nurse, Internet Researcher, Private Tutor
  • http://ww2.justanswer.com/uploads/chooser77/2009-08-18_162025_Chris.jpg Chris M.'s Avatar

    Chris M.

    M.S.W. Social Work

    Satisfied Customers:

    2341
    Master's Degree, strong math and writing skills, experience in one-on-one tutoring (college English)
  • http://ww2.justanswer.com/uploads/JawaadAhmed/2009-6-27_12137_SIs_SHadi.jpg F. Naz's Avatar

    F. Naz

    Chartered Accountant

    Satisfied Customers:

    1975
    Experience with chartered accountancy
  • http://ww2.justanswer.com/uploads/JK/jkcpa/2011-1-16_182614_jkcpa.64x64.jpg Bizhelp's Avatar

    Bizhelp

    CPA

    Satisfied Customers:

    1873
    Bachelors Degree and CPA with Accounting work experience