help wit ms access and publisher assignment
Do you need academic writing help with your homework? Let us write your papers.
Order a Similar Paper
Order a Different Paper
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.
Save your time - order a paper!
Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines
Order Paper NowFor 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.