6
INTRO
Activity Layout
38
WRD
10
10. Double-space aft er the inside address and insert the following salutati on and merge fi eld left -aligned:
NOTE:
Insert a colon aft er the <<First_Name>> merge fi eld.
Dear «First_Name»:
11. Double-space and key the following fi rst paragraph of text left -aligned and single-spaced:
Thank you for your interest in our upcoming Batt le of the Bands. As you know, The Hub is host to the
hott est competi ti on giving local high school bands the opportunity to use our live performance stage as
their venue. Previous competi ti ons have had over 700 people in att endance. The exposure is fantasti c;
you never know what talent scouts are among the audience.
12. Double-space and key the following second paragraph left -aligned and single-spaced, inserti ng a merge fi eld
for the type of music.
Currently, we are sti ll holding auditi ons. We are excited at the possibility of featuring a band that plays
«Type_of_Music». We know our crowd will love it. Please be pati ent with us during this process. We will
contact you as soon as all of the contestants have been selected.
13. Double-space and key the following conclusion paragraph left -aligned and single-spaced.
Thank you again for auditi oning. We expect this next Batt le to have the highest turnout yet. Please don't
hesitate to contact me if you have any further questi ons.
14. Double-space, hit the tab key, and key the following complimentary close. Be sure to quadruple space
between the closing and your name so that you can sign the printed lett er.
Sincerely,
[Student's Name]
Microsoft Offi ce Specialist
15. Carefully proofread your work for accuracy and format. Your document should fi t on one page.
16. Resave the fi le.
17. Using the mail merge feature, merge your lett ers to a new document.
18. Save the document as Project WRD-10 Modifi ed Block Merged in your "Word" folder under "The Hub" folder.
19. Print a copy of one or more of the merged lett ers if required by your instructor.
Modified Block Style Letter
45
WRD
12
FIGURE WRD-12.1
Employee Personnel Form
© The Hub, Employee Personnel Form, version 1, <current date>
Employee Personnel Form
First Name
Last Name
Social Security
Date of Birth
Address
City
State
Zip
Phone Number
Cell Phone Number
Email Address
Spouse's Name (if applicable)
Phone Number
Cell Phone Number
Email Address
Emergency Contact Name
Phone Number
Days Available
Nights Available
Weekends Available
Holidays Available
T-Shirt Size (S, M, L, XL)
Shoe Size
Bank Name
Address
City
State
Zip Code
Direct Deposit yes no
Deposit Amount
Primary Beneficiary
Secondary Beneficiary
Employee Signature:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
35
WRD
9
Mailing Labels
M
ailing labels are oft en a substi tute for printi ng mailing addresses directly
onto envelopes. They become necessary when the item being mailed
is packaged in something other than an envelope that fi ts in the printer or for
correspondence that is going to many diff erent addresses. Microsoft Word
allows users to choose from the most popular brands and sizes of labels.
1. Allow for correct word spacing and punctuati on around merged fi elds.
2. Proofread the labels carefully before and aft er merging.
3. Read through all instructi ons prior to completi ng the project.
1. Using Microsoft Word, create a new document.
2. Save the document as Project WRD-9 Mailing Labels in your "Word" folder
under "The Hub" folder.
3. Using the mail merge feature, set up the main document indicati ng "Labels" as
the document type. Choose Avery 5163 (2 inch x 4 inch) mailing labels.
4. Using the mail merge feature, select the fi le "Membership Database" (created
in Project ACC-1 Membership Database) in your "Access" folder under "The
Hub" folder.
NOTE:
This step will connect the main document (the labels) to the data source
document; the data source document does not actually display on the screen.
5. Using the mail merge feature, insert the following merge fi elds single-spaced:
NOTE:
Insert the necessary spaces and punctuati on between merge fi elds as
shown below.
«First_Name» «Last_Name»
«Street_Address»
«City», «State» «Zip»
6. Carefully proofread your work for accuracy and format.
7. Resave the fi le.
8. Using the mail merge feature, merge the labels to a new document.
9. Carefully proofread your work for accuracy and format.
10. Select the enti re document, center align all text, and change the font size to 22
point.
11. Save the document as Project WRD-9 Mailing Labels Merged in your "Word"
folder under "The Hub" folder.
12. Print a copy of the merged document if required by your instructor.
important NOTE
Prior to completing this
project, you must first
complete "Project ACC-1:
Membership Database"
in the Microsoft Access
section of this book.
your TASK
Your task is to create
Mailing Labels that can
be merged with the
Membership Database
you completed in
Project ACC-1. The
Hub wants to grab its
members' att enti on
this year. Instead of
sending a traditi onal
birthday card,
management wants
to send a multi media
greeti ng with video
and sound, all saved
onto a DVD. The small
bubble-lined envelope
cannot be run through
the printer, so mailing
labels must be created.
the SKILLS
· Format mailing labels
· Complete a mail
merge with a
database
Overview
Provides a description of each project,
highlighting the document(s) to be produced.
Important Note
Calls attention to an important point
before beginning the project.
Your Task
Provides an overview of what needs
to be done to complete the project.
Input Frames
Provides the text to be typed and formatted into
the finished project.
Project Sample
Illustrates a
completed
document with
proper formatting.
Instructions
Provides the step-by-step instructions for
completing each project.
The Skills
lists the skill(s) being reinforced.
P
rojects in this simulation have been organized into an easy-to-read, self-guided, step-by-step
format. This book is divided into five sections, each containing a set of individual projects for
each of the Microsoft Office applications.
A brief explanation of the individual sections that make up each project in this simulation follows.
It is recommended that you read this section to become familiar with the format of this book.
Strategies
Outlines the actions needed to successfully
complete the projects.
For Evaluation Purposes Only