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 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 Capstone Project A Banner Consulting 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: 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. Open the ParticipantRegistration form in Design View and update the 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. Align the Phone and Status controls and their associated labels using Top alignment. c. Align the LastName and Phone text boxes using Left alignment. d. Align the LastName and Phone labels using Left alignment. 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. With the ParticipantRegistration form still open in Design View, add registration details to the form as follows: a. With the Use Control Wizards button selected, add a subform to the form. b. Use the Registrations table for the subform. c. Select the RegistrationID, ParticipantID, RegistrationFee, PresentationFee, and GuestFee fields (in that order) to add to the subform. d. Accept the default link (Show Registrations for each record in Participants using ParticipantID) to link the main form to the subform. e. Save the subform using RegistrationDetails as the subform name. f. 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. 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. Figure 1: ParticipantRegistration Form in Design View 6. Open the EmployeeEntry form in Design View and provide a way to find an employee as follows: a. With the Use Control Wizards button selected, 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. With the EmployeeEntry form still open in Design View, provide a quick way to close the form as follows: a. Add a command button to the right side of the Form Footer section. b. Choose the Close Form 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. 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: a. Add a rectangle control around the DepartmentID and **More