Shelly Cashman Access 365 | Module 7: End of Module Project 2 скачать в хорошем качестве

Shelly Cashman Access 365 | Module 7: End of Module Project 2

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 | Module 7: End of Module Project 2 PROJECT STEPS 1. Dairy State Community College has four locations in the state of Wisconsin, and each campus has an alumni association, which serves as a center for fundraising and promotion of the college. You work in the main alumni association office as an information specialist and are developing an Access database to track alumni data for all four campuses. Open the CampusUpdates form in Design View to fine-tune the appearance of the form and make it more informative and appealing. Add a title to the form using Campus Updates as the title text. Bold the title text. Change the background color of the Form Header section to Maroon 2 (6th column, 3rd row in the Standard Colors palette). Remove the unused Page Header and Page Footer sections. Confirm that the form matches Figure 1, and then save and close the form. Figure 1: CampusUpdates form in Design View 2. Open the StaffList form in Design View to include the name of each staff member. Add a text box between the StaffID and Position controls. Align the left edge of the new text box with the StaffID text box and align the left edge of the new label with the left edge of the Staff ID label. Create a calculated control that concatenates the FirstName field, a space, and the LastName field. (Hint: Your control should contain the formula =[FirstName]&' '&[LastName]). Use Name as the text for the new label. Resize the new text box so that its right edge is at the 3" mark on the horizontal ruler. Confirm that the form matches Figure 2, and then save and close the form. Figure 2: StaffList form in Design View 3. Open the AlumniEntry form in Design View to modify an action of the Add Record button. Clicking the button should insert a new record and position the insertion point in the first field on the form. Modify the build event of the Add Record button so the GoToControl action positions the insertion point in the AlumniID text box. Save your changes, switch to Form View, and then click the Add Record button. Confirm that the form matches Figure 3, and then close the form. Figure 3: AlumniEntry form in Form View 4. Open the ProgramUpdates form in Design View to improve its appearance. Insert a rectangle around the MinParticipants and Budget controls, including the labels and text boxes. The top-left edge of the rectangle is at the 4" mark on the horizontal ruler and the first tick mark on the vertical ruler. The bottom-right edge of the rectangle is at the 7" mark on the horizontal ruler and the 1" mark on the vertical ruler. Change the Special Effect property of the rectangle to Shadowed to make the rectangle more prominent. Confirm that the form matches Figure 4, and then save and close the form. Figure 4: ProgramUpdates form in Design View 5. Open the FamilyDonorLevels form in Design View to update the datasheet and chart on the tab control to make them easier to interpret. Remove the unnecessary LevelID control from the subform, scrolling as necessary to display the control. Save your changes, switch to Form View, and then resize the columns in the subform to their best fit. Confirm that the form matches Figure 5, and then save but do not close the form. Figure 5: FamilyDonorLevels form with Datasheet tab in Form View 6. Display the FamilyDonorLevels form in Design View, and then display the Chart tab in the tab control. Change the chart type to a Bar Chart and place the legend on the bottom of the chart. Confirm that the form matches Figure 6, and then save and close the form. Figure 6: FamilyDonorLevels form with Chart tab in Design View 7. Open the FamilyUpdates form in Design View to make it easier to find family names with the combo box control. Use the Row Source property of the combo box to display its fields in Query Builder, and then sort the LastName field in ascending order. Save your changes to Query Builder and the form, and then close the form. Save and close any open objects in your database. Compact and repair your database, close it, and then exit Access. Follow the directions on the website to submit your completed project.