Help wit MS Access and Publisher assignment
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 |
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
- 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.
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 |
|
construction@NewPortCC.edu |
Tagline |
Building a better New Orleans |
Logo |
CM_Logo |
Business Information set name |
Finale |
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 the file name.