Shelly Cashman Access 365 | Modules 4-7: SAM Capstone Project A скачать в хорошем качестве

Shelly Cashman Access 365 | Modules 4-7: SAM Capstone Project A

Please contact us if you need this project or any other project in any subject to be completed. Whatsapp: +1-343-321-3276 Email: essayserviceusa@gmail.com WhatsApp Link: https://wa.me/13433213276 #ShellyCashmanAccess365 #Modules4-7SAMCapstoneProjectA #BannerConsulting Shelly Cashman Access 365 | Modules 4-7: SAM Capstone Project A Banner Consulting ENHANCING FORMS AND REPORTS PROJECT STEPS 1. Banner Consulting is a nationwide consulting firm with headquarters in Ann Arbor, Michigan. The firm hosts community fundraising events throughout the year and encourages employees and their families to participate. You work in the Human Resources Department and help coordinate the events, using an Access database to track data about participants, sponsors, fundraising booths, and registrations. Open the Employees table in Design View. Use the Input Mask Wizard to add an input mask to the Phone field using the following options: a. Use the Phone Number input mask with the Input Mask format !(999) 000-0000 and the underscore (_) as the placeholder character. b. The input mask should store the values without symbols in the mask. (Hint: Some of these values might be the default input mask values.) c. Save and close the table. 2. Use the Form Wizard to create a new form based on the Booths table using the following options: 3. Open the ParticipantRegistration form in Design View and update the form as follows to add a missing field: 4. With the ParticipantRegistration form still open in Design View, add registration details to the form as follows: 5. With the ParticipantRegistration form still open in Design View, add a title to the form. Use Participant Registration Form as the title as shown in Figure 1. Save and close the form. 6. Open the EmployeeEntry form in Design View and provide a way to find an employee as follows: 7. With the EmployeeEntry form still open in Design View, provide a quick way to close the form as follows: 8. With EmployeeEntry form still open in Design View, add a rectangle control to the form as follows to separate the employee information from the department information: 9. With the EmployeeEntry form still open in Design View, update the design as follows to use consistent formatting: 10. Use the Report Wizard to create a multi-table report as follows to list participant fees: 11. Use the Label Wizard to create mailing labels for the Participants table using the following options: 12. Open the PresentationsAndRegistrations report in Layout View. Open the Group, Sort, and Total pane, and then add an ascending sort order on the RegistrationID field within the PresentationID group. Save but do not close the report. 13. With the PresentationsAndRegistrations report still open in Layout View, select the PresentationFee column, and then add subtotals and a grand total to the column using the Sum function. Save but do not close the report. 14. With the PresentationsAndRegistrations report still open in Layout View, apply conditional formatting to the values in the TotalFees column so that if the field value is greater than or equal to 275, the field's font color is set to Aqua Blue (9th column, 1st row in the Standard Colors palette) and the font is bold. 15. Open the EmployeeContact report in Design View and set the Record Source property to the EmployeeContact query to use the query's record for later report development. Save and close the EmployeeContact report. 16. Open the RegistrationsByState report in Design View, and add a grouping field to the report as follows to reorganize the records: 17. With the RegistrationsByState report still open in Design View, add a field to the State group header as follows to display the state name: 18. With the RegistrationsByState report still open in Design View, add page numbers and dates to the report as follows: 19. Open the PresentationCharts form in Design View. Update the tab control as follows to provide more meaningful information: 20. With the PresentationCharts form still open in Design View, display the pie chart in the first tab control. 21. With the PresentationCharts form still open in Design View, display the second tab control. Insert a chart into the second tab control as follows to compare fees: 22. Open the RegistrationsByParticipant report in Design View. Remove the Page Header and Footer from the report. Save but do not close the report. 23. With RegistrationsByParticipant report still open in Design View, add a control as follows to display the full name of each participant: 24. With the RegistrationsByParticipant report still open in Design View, add registration details to the report as follows: