Construction Management

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
Open the Access file Construction_Management and Save
with the file name Lastname_Firstname_Construction_Management
Create a form named based on the Students table, save it
as Lastname Firstname Student Form
Add the following student records.
Use your first name and last name for the last record.
First Name, Last Name: Karen Crosby
Address, city, state, zip: 11171 54th
Ave, New Orleans, LA, 33714
Phone number, degree: 504-555-0092, Construction
Management
First Name, Last Name: Richard Eagleson
Address, city, state, zip: 12501 W Isabel St, New
Orleans, LA, 33708
Phone number, degree: 504-555-5832, Information
Systems
First Name, Last Name: Larry Magg
Address, city, state, zip: 15304 Cypress St, New
Orleans, LA 33701
Phone number, degree: 504-555-0362, Construction
Management
First Name, Last Name: Joel Lashley
Address, city, state, zip: 12513 Frierson Ave, New
Orleans, LA 33701
Phone number, degree: 504-555-0186, Construction

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

Part
3
Start mail merge and choose your Access file
Lastname_Firstname_Construction_Management as the data source.
Filter the recipients to show only the Construction
Management students.
Insert the student’s name and mailing address.
Save the publication.
Complete the merge to a new publication.
Save the merged publication as
Lastname_Firstname_Merged_Conference and then update the footer with your name.

Last Completed Projects