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 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 34. 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 E-mail 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 your name. please note I will updated the first and last name.thx
Looking for a solution written from scratch with No plagiarism and No AI?
WHY CHOOSE US?
We deliver quality original papers |
Our experts write quality original papers using academic databases.We dont use AI in our work. We refund your money if AI is detected |
Free revisions |
We offer our clients multiple free revisions just to ensure you get what you want. |
Discounted prices |
All our prices are discounted which makes it affordable to you. Use code FIRST15 to get your discount |
100% originality |
We deliver papers that are written from scratch to deliver 100% originality. Our papers are free from plagiarism and NO similarity.We have ZERO TOLERANCE TO USE OF AI |
On-time delivery |
We will deliver your paper on time even on short notice or short deadline, overnight essay or even an urgent essay |