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

Shelly Cashman Access 365 | Modules 4-7: SAM Critical Thinking Capstone Project C

Please contact us if you need this project or any other projects in any subject to be completed. WhatsApp: +1-343-321-3276 Email: essayserviceusa@gmail.com WhatsApp Link: https://wa.me/13433213276 Shelly Cashman Access 365 | Modules 4-7: SAM Critical Thinking Capstone Project C 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. Modify the Employees table to make it easier to enter phone numbers by adding 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. Store the values without symbols in the input mask. c. Save and close the table. 2. Use the Form Wizard to create a new form using the following options: a. Select all fields in the Booths table. b. Use the Columnar layout. c. Use BoothEntry as the title of the form. View the BoothEntry form in Form View, and then save and close the form. 3. Update the ParticipantRegistration form as follows to add a missing field: a. Display the fields for the Participants table and then add the Phone control to the form directly below the LastName control and label. b. Top-align the Phone and Status controls and their associated labels. c. Left-align the LastName and Phone text boxes. d. Left-align the LastName and Phone labels. e. Change the tab order so that users tab to the Phone control directly after the LastName control. Save but do not close the form. 4. Add missing registration details to the ParticipantRegistration form as follows: a. Use a control wizard to add a subform based on the Registrations table to the form. b. Add the RegistrationID, ParticipantID, RegistrationFee, PresentationFee, and GuestFee fields (in that order) to the subform. c. Accept the default link to link the main form to the subform. d. Save the subform using RegistrationDetails as the subform name. e. If necessary, reposition the subform to match the approximate location shown in Figure 1. (Hint: The left edge of the subform is at 0.5" mark on the horizontal ruler and the top of the subform label is at the 2" mark on the vertical ruler.) Save the ParticipantRegistration form but do not close it. 5. Add Participant Registration Form as the title of the ParticipantRegistration form as shown in Figure 1. Save and close the form. Figure 1: ParticipantRegistration Form in Design View 6. Modify the EmployeeEntry form as follows to provide a way to find an employee: a. Use a control wizard to add a combo box to the right side of the Form Header section. b. Choose to have the combo box get the values from the Employees table. c. Select the EmployeeID and EmployeeLast fields (in that order) for the combo box. d. Sort the records in ascending order by the EmployeeLast field. e. Hide the key column and remember the value for later use. f. Use Find Employee as the label for the combo box. g. Resize and reposition the combo box control and label to the approximate location shown in Figure 2. (Hint: The left edge of the combo box control is at the 6" mark on the horizontal ruler and the bottom edge of the control is at the 0.5" mark on the vertical ruler.) Save the changes to the EmployeeEntry form but do not close it. 7. Provide a quick way to close the EmployeeEntry form as follows: a. Use a control wizard to add a command button to the right side of the Form Footer section. b. Choose the appropriate action for the command button. c. Display the text Close and no picture on the button. d. Use CloseForm as the meaningful name for the command button. e. Position the command button in the Form Footer section with the left edge at the 6" mark on the horizontal ruler, as shown in Figure 2. Save the EmployeeEntry form but do not close it. 8. Add a rectangle control to the EmployeeEntry form as follows to separate the employee information from the department information: a. Add a rectangle control around the DepartmentID and DepartmentName controls. **More