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

Shelly Cashman Access 365 | Modules 8-10: 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 8-10: 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 PreviewReports macro so that it opens the EmployeeContact report in Print Preview. Save the change to the macro, and then close it. 2. Create a new macro with two submacros as follows to open frequently used tables: a. Add a submacro named Open Participants Table to the macro. b. Set the submacro to open the Participants table for editing in Datasheet View. c. Add a second submacro named Open Registrations Table to the macro. d. Set the second submacro to open the Registrations table for editing in Datasheet View. e. Save the macro using OpenTables as the macro name. Confirm that your macro matches Figure 1 and then close the macro. Figure 1: OpenTables Macro 3. Create a data macro for the EarlyRegistrations table as follows that makes sure the Paid amount is logical and accurate: a. Choose a data macro for the table that triggers an event that occurs after the user has changed the data but before the change is actually made in the database. b. Add a statement that checks whether the Paid field value is greater than the TotalFees field value. If it is, the macro should set the value in the Paid field to the same value in the TotalFees field. c. Add a statement that checks whether the Paid field value is less than 0. If it is, the macro should set the value to 0. d. Verify the data macro matches the one shown in Figure 2. Save and close the macro, and then save and close the EarlyRegistrations table. Figure 2: Data Macro for the Before Change Event 4. Create a form for accessing other database forms as follows: a. Create a Navigation form with horizontal tabs. b. Add the Booths, Employees, and Sponsors Datasheet forms to the Navigation form in that order. c. Use Datasheet Navigation Form as the form title. d. Save the navigation form using DatasheetNavigation as the name. Confirm that your form matches Figure 3 in Form view. Save and close the DatasheetNavigation form. Figure 3: DatasheetNavigation Form in Form View 5. Create a UI macro for the Employees form as follows that opens the EmployeeEntry form when a user selects a value in the EmployeeID column: a. Open the Property Sheet for the EmployeeID column. b. Open the Macro Builder for the On Click event. c. Set a temporary variable using EN as the name and [EmployeeID] as the expression. d. Add an action that opens the EmployeeEntry form as a dialog window and displays only the record the user selected. e. Remove the temporary variable in the last action of the macro. Confirm that your macro matches Figure 4. Save and close the macro and then save and close the form. Figure 4: UI Macro for the On Click Event in the Employees Form 6. Add another form to the Main Menu Navigation form as follows: a. Add the FormList form to the Main Menu Navigation form as the last horizontal tab. b. Use Entry Forms as the name of the new tab. c. Move the Employees tab so that it appears first in the list. Switch to Form View, confirm that the form matches Figure 5, and then save and close the form. Figure 5: Main Menu Navigation Form in Form View 7. Add a command button as follows to the DetailForms form to open the RegistrationDetails form: a. Use a control wizard to add a command button to the form below the Open ParticipantDetails Form button. b. Choose to run the OpenForms.Open RegistrationDetails Form macro. c. Use Open RegistrationDetails Form as the text to display on the command button. d. Use OpenRegistration as the name of the command button. e. Position the left edge of the new button at the 2" mark on the horizontal ruler and the top edge at the 2.5" mark on the vertical ruler, as shown in Figure 6. Save the changes to the form but do not close it. 8. Format the command buttons on the DetailForms form as follows to create a more consistent layout: a. Adjust the size of the three buttons to the width of the widest button. b. Adjust the spacing to create equal vertical space between the buttons. c. Align the buttons to the left. Confirm that your form matches Figure 6. Save and close the DetailForms form. Figure 6: DetailForms Form in Design View 9. Create a custom database property as follows to provide a way to note final changes to the database: a. Open the Properties dialog box for the **more