Shelly Cashman Access 365 | Module 8: SAM Project B скачать в хорошем качестве

Shelly Cashman Access 365 | Module 8: SAM Project B

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 #Module8SAMProjectB #HaverhillsNeighborhoodAssociation Shelly Cashman Access 365 | Module 8: SAM Project B Haverhills Neighborhood Association MACROS, NAVIGATION FORMS, CONTROL LAYOUTS PROJECT STEPS 1. Haverhills Neighborhood Association works with the city of Madison, Wisconsin, to improve the neighborhood for residents. As a volunteer with database skills, you and the other association members want to access forms and reports by clicking tabs and buttons rather than using the Navigation Pane. Open the Preview CommitteeResidents macro in Design View to modify the macro so it opens the report in Print Preview. Save and then close the Preview CommitteeResidents macro. 2. Open the Open ResidentAddresses macro in Design View to correct an error as follows: 3. Create a new macro with two submacros as follows to make it easy to open frequently used tables: 4. Open the Committees table in Datasheet View to create a data macro as follows that verifies each committee has at least three members and no more than 12: 5. Create a Datasheet form based on the Representatives table, and then save the form using the default text Representatives as the form name. Close the form. 6. Create a form as follows to provide access to the most common lookup forms in the database: 7. Open the Residents form in Datasheet View, and then complete the following tasks to create a UI macro for the form: 8. Open the Main Menu Navigation form in Layout View to update the form as follows: a. Add the FormsList form to the Main Menu Navigation form as the last horizontal tab. b. Rename the FormsList tab using Other Forms as the new tab name. c. Move the Committees tab so that it appears first in the list. Confirm that the form matches Figure 5, and then save and close the form. Figure 5: Main Menu Navigation Form in Layout View 9. Open the Lookups form in Design View to complete creating the form as follows: a. Add a third command button to the form in the approximate position shown in Figure 6. b. Using the Command Button Wizard, select Miscellaneous as the category and Run Macro as the action. c. Select Open Forms.Open ResidentDues Form as the macro. d. Select the Text option, and then enter Open ResidentDues Form as the text. e. Use Residents as the name for the command button. Save the changes to the form, but do not close it. Figure 6: Lookups Form in Design View 10. With the Lookups form still open in Design View, fine-tune the form design as follows to improve its appearance: a. Adjust the size of the three buttons To Widest. b. Adjust the spacing of the buttons to Equal Vertical. c. Align the buttons to the Left. Confirm that your form matches Figure 6, and then save and close the Lookups form. 11. Open the ResidentsAndPrograms form in Layout View to modify the layout as follows and make the form easier to use: a. Split the cell containing the value for the FirstName field horizontally. b. Delete the Last Name label. c. Move the cell containing the value for the LastName field to the right of the FirstName field. d. Use Resident Name instead of First Name as the label text. e. Move the Date of Birth label and DateOfBirth field value below the Resident Name controls. f. Change the control margins for the control layout to Narrow and the control padding to Medium. Confirm that your form matches Figure 7, and then save and close the ResidentsAndPrograms form. Figure 7: ResidentsAndPrograms Form in Layout View 12. Open the ResidentsByProgram report in Layout View to change the arrangement of the fields. Change the control layout in the report to Stacked as shown in Figure 8. Save the change to the report and close it.