Assignment Instructions

The Scenario:

In past years, New Orleans has been hit hard by hurricanes and other bad weather. The construction industry, working with New Port Community College, has put a renewed emphasis on training the Construction Management students to build structures that meet current building codes. You have been asked to create a flyer inviting all Construction Management students to attend a conference.

For this assignment, you will need the following files:

    New blank Publisher publication

    Construction_Management

    CM_Logo

You will save your files as:

    Lastname_Firstname_Construction_Management

    Lastname_Firstname_Construction_Conference

    Lastname_Firstname_Merged_Conference

Part 1

  1. Open the Access file Construction_Management and Save with the file name Lastname_Firstname_Construction_Management
  2. Create a form named based on the Students table, save it as Lastname Firstname Student Form
  3. Add the following student records.
  4. Use your first name and last name for the last record.

First Name

Last Name

Address

City

State

ZIP

Phone Number

Degree

Karen

Crosby

11171 54th Ave

New Orleans

LA

33714

504-555-0092

Construction Management

Richard

Eagleson

12501 W Isabel St

New Orleans

LA

33708

504-555-5832

Information Systems

Larry

Magg

15304 Cypress St

New Orleans

LA

33701

504-555-0362

Construction Management

Firstname

Lastname

12513 Frierson Ave

New Orleans

LA

33701

504-555-0186

Construction Management

Part 2

  1. Create a report using the Report Wizard that includes the fields First Name, Last Name, Phone Number, and Degree.
  2. Group the data by Degree and sort the data by Last Name. Change the column widths so all data is visible.
  3. Create a Publisher template of your choice.
  4. Save the file as Lastname_Firstname_Construction_Conference and then insert the your name in the footer.
  5. In a text box, add information about the Construction Management conference to be held on campus on March 3–4.
  6. In another text box, list Louisiana cities, such as Baton Rouge, Lafayette, that have had damage due to hurricanes.
  7. Insert and format appropriate online images.
  8. Create a business set for Mrs. Finale using the following information.

Individual name

Tammy Finale

Job position

Director, Construction Management Program

Organization name

New Port Community College

Address

12745 Dartmouth Ave New Orleans, LA 70114

Phone Number

504-555-0030

Fax

504-555-0031

E-mail

construction@NewPortCC.edu

Tagline

Building a better New Orleans

Logo

CM_Logo

Business Information set name

Finale

Part 3

  1. Start mail merge and choose your Access file Lastname_Firstname_Construction_Management as the data source.
  2. Filter the recipients to show only the Construction Management students.
  3. Insert the student’s name and mailing address.
  4. Save the publication.
  5. Complete the merge to a new publication.
  6. Save the merged publication as Lastname_Firstname_Merged_Conference and then update the footer with your name.
First NameLast NameAddressCityStateZIPPhone NumberDegree
MickaBaker1513 Greens DrNew OrleansLA70032.0504-555-0176Construction Management
ZenaGrows15104 Eagle WayNew OrleansLA70032.0504-555-0383Construction Management
MaryAplletree1866 41st Ave NNew OrleansLA70043.0504-555-0983Nursing
JerryLewis15817 Amber Walk LnNew OrleansLA70032.0504-555-4336Business Administration
ChloeTanner14206 S Davis Mabry HwyNew OrleansLA70114.0504-555-5331Criminal Justice
LisaGomez1314 S Edmond AveNew OrleansLA70139.0504-555-2188Construction Management
MiraHodge1209 E Liverston AveNew OrleansLA70148.0504-555-5352Accounting
JacksonBorderline12109 E Pale AveNew OrleansLA70032.0504-555-0186Communication

please note I will updated the first and last name.thx

"Get 15% discount on your first 3 orders with us"
Use the following coupon
FIRST15

Order Now