Thanks, XXXXX XXXXX upload details and I can review when back in front of my laptop later today
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.
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
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
• 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
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
• 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
5. Purchase Date
6. Warranty Type
7. Warranty Length
9. Repair Date
The data within the query should be sorted alphabetically by
Item Category. Save the query as Repaired Items.
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
Include the following fields from the Merchants table:
1. Merchant Name
2. Merchant Address
3. Merchant City
4. Merchant State
5. Merchant ZIP
Merchant Name. Set the criteria cell for the Item Category
field to search for “Appliances.” Save the query as Appliance
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):
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:
• 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 Date: (none)
Item Number: 2
Item Name: Television
Item Manufacturer: Telecom
Item Model Number: TV100
Item Serial Number: XXXXXXXXX /p>
Purchase Date: 02/14/20XX
Purchase Price: $299.95
Warranty Length: 90 days parts/labor
Repair Date: 09/01/20XX
Comments: Remove candy from
Item Number: 3
Item Name: Personal Computer
Item Category: Computers
Item Manufacturer: Deluxe
Item Model Number: PC1000
Purchase Price: $1,299.95
Merchant ID: 6
Online/Mail Order: Yes
Warranty Length: 1 year parts/labor/tech
Item Number: 4
Item Name: CD-ROM Drive
Item Model Number: CD200
Item Serial Number: 11233211
Purchase Date: 01/02/20XX
CoItem Number: 5
Item Name: Ink-Jet Printer
Item Manufacturer: Stylus
Item Model Number: IJ750
Purchase Price: $169.95
Warranty Length: 90 days parts/labor/
Repair Date: 05/15/20XX
Comments: Replace defective print
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
Warranty Type: Manufacturer/store
Warranty Length: 90 days/1 year
Item Number: 7
Item Name: Washing Machine
Item Manufacturer: General Appliance
Item Model Number: CL900
Item Serial Number: 90050221
Purchase Date: 12/19/20XX
Purchase Price: $450.00
Warranty Length: 1 year parts/labor
Item Number: 8
Item Name: Clothes Dryer
Item Model Number: DR199
Purchase Date: 01/19/20XX
Purchase Price: $599.95
Repair Date: 06/09/20XX
CommeItem Number: 9
Item Name: Dishwasher
Item Manufacturer: Washmatic
Item Model Number: DW19
Item Serial Number: XXXXXXXXXXX /p>
Purchase Date: 08/12/20XX
Purchase Price: $275.00
Merchant ID: 3
Item Number: 10
Item Name: Digital Camera
Item Manufacturer: Snapic
Item Model Number: Snap100
Purchase Price: $225.00
Merchant ID: 4
Credit Card Purchase: No
Item Number: 11
Item Name: 35mm Camera
Item Category: Photo Equipment
Item Manufacturer: Camco
Item Model Number: SLR75
Purchase Date: 05/20/20XX
Item Number: 12
Item Name: Zoom Lens
Item Model Number: Zoom10
Item Serial Number: 351
Purchase Date: 02/20/20XX
Purchase Price: $125.00
Warranty Length: 30 days parts/labor
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
Warranty Type: n/a
Warranty Length: n/a
Comments: 24-karat gold, 24″ long,
Item Number: 14
Item Name: Engagement Ring
Item Manufacturer: Jewelserv
Purchase Date: 02/11/20XX
Purchase Price: $1,500.00
Comments: 3/4-carat square cut
diamond in 18-karat
Item Number: 15
Item Name: Lighter
Item Category: Collectibles
Item Manufacturer: ZIPpy
Item Model Number: 21BT200
Purchase Date: 09/25/20XX
Purchase Price: $100.00
Merchant ID: 7
Comments: Original 1950
#200 of 500 made.
Appraised at $200.00.
Item Number: 16
Item Name: Candy Dish
Item Manufacturer: Jones Glass
Item Category: n/a
Purchase Date: 12/20/20XX
Purchase Price: $250.00
Comments: Cranberry Depression
glass candy dish.
Appraised at $500.00
Use the information listed below to create the Merchants database.
Graded Project 17
Merchant Name: Electronics Mart
Merchant City: Blankston
Merchant State: PA
Merchant ZIP: 18454
Merchant URL: http://www.emart.com
Merchant Phone: (XXX) XXX-XXXX
Merchant Fax: (XXX) XXX-XXXX
Merchant Name: Appliances Inc.
Merchant E-mail: n/a
Merchant URL: n/a
Merchant Name: Stuff Mart
Merchant City: Shopville
Merchant State: NY
Merchant ZIP: 10022
Merchant URL: http://www.stuffmart.com
Merchant Name: Photo Barn
Merchant City: Klossville
Merchant ZIP: 19019
Merchant URL: http://www.snapshot.com
Merchant Name: Jewelry Warehouse
Merchant City: Platold
Merchant State: NJ
Merchant ZIP: 00050
Merchant URL: http://www.jewelware.com
Merchant Name: Crazy John’s Computers
Merchant City: Wynnsville
Merchant State: CO
Merchant ZIP: 18888
Merchant URL: http://www.merchandizing
Merchant Name: Collector’s Emporium
Merchant City: Oldenburg
Merchant ZIP: 18999
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
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.
What Is Hunger?
Effects of Hunger on Children
Worldwide Locations of Hunger
Locations within Countries
Causes of Hunger
Caused by Humans
Harvest and Store Properly
How to Contact Us
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
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
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
2. After selecting the title text, enlarge its type size to
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.
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,
2. Click to insert the clip art onto the slid
3. Resize, reposition, or crop the clip art as appropriate
• 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
• 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
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
8. Click on Slide 7.
9. Find an image suitable for illustrating the contents of
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
1. If it isn’t already running, launch PowerPoint and open
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
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
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.
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,
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
6. Now highlight the second bulleted blurb, “E-mail
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
(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
(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
(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.
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
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
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
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
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.
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
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
5. Save and close your database (Figure 1).
PART 2: CREATING YOUR
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
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
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
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
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
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
9. Move the chart below the worksheet as shown in
Advanced PC Applications 7
PART 3: CREATING YOUR
AND PREPARING IT FOR
1. Open Microsoft PowerPoint and create a
2. Save your document as “Nick’s Presentation.”
3. Choose a Design theme and apply it to your slides.
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.
chart in Slide 5.
Slide 6 as you
Advanced PC Applications 11
PART 4: CREATING
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,
• 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.
as a single file
Web page as
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
FIGURE 15—Insert the Address Block and Greeting Line from the Mail Merge Wizard. from your Access database into this letter
This is the first file - Inventory Database
Second assignment - World Hunger
Presentation - https://app.box.com/s/posuhtybthzgz6lils1x
Video - https://app.box.com/s/3ddhrrtl66xxjl1e1fwu
Excel File - https://app.box.com/s/n0bzsj6gkb1rahiq1st5
Word file - https://app.box.com/s/3fmaxlvsp6zr4dpqaowk
Third assignment - Nick's Sporting Goods
Presentation - https://app.box.com/s/r1wp2juts4qgue72mp62
Excel file - https://app.box.com/s/fwpnlf0n48xbujv53hle
Database - https://app.box.com/s/n3mxa3wy4wcr4ugj5vhj
Letter - https://app.box.com/s/erl1peqrnzyif4rxilio
Merge - https://app.box.com/s/wmmf48mhhajz0ktigy7i
That should be all of them!