Homework answers / question archive / Shelly Cashman Access 2019 | Module 8: End of Module Project 1 Competitive Swim Clubs Inc

Shelly Cashman Access 2019 | Module 8: End of Module Project 1 Competitive Swim Clubs Inc

MS Access

Share With

---

Shelly Cashman Access 2019 | Module 8: End of Module Project 1

Competitive Swim Clubs Inc.

Macros, Navigation Forms, Control Layouts

GETTING STARTED

• Open the file SC_AC19_EOM8-1_FirstLastName_1.accdb, available for download from the SAM website.
• Save the file as SC_AC19_EOM8-1_FirstLastName_2.accdb by changing the “1” to a “2”.
  • If you do not see the .accdb file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.
• Open the _GradingInfoTable table and ensure that your first and last name is displayed as the first record in the table. If the table does not contain your name, delete the file and download a new copy from the SAM website.

• PROJECT STEPS

1. Competitive Swim Clubs Inc. is a national chain of swim clubs targeted to youth and adults who are or who want to be competitive swimmers. You are the regional manager for clubs located in the southeastern United States. You and your colleagues need to be able to access forms and reports by simply clicking tabs and buttons, rather than using the Navigation Pane.
   
   Both coaches and clubs access the Swimmers table frequently. Create a macro to open the Swimmers table in Datasheet View and in Edit data mode. Save the macro using Open Swimmers Table as the name of the macro and close it.
2. Open the OpenForms macro in Design View and add a second submacro to the macro that opens the Coach Master Form in Read Only data mode. Use Open Coach Master Form as the name of the submacro. Save the changes to the macro and close the macro.
3. To add a table to a Navigation Form, you first must create a datasheet form for the table. Create a datasheet form based on the SwimFees table, and then save the form using the default name SwimFees as the form name. Close the form.
4. Open the Swimmers form in Design View and create a UI macro that opens the Swimmer Master Form when a user selects a value in the SwimmerID column. Set a temporary variable using SN as the name and [SwimmerID] as the expression. Add an OpenForm action using [SwimmerID]=[TempVars]![SN] as the Where condition, Read Only as the data mode, and Dialog as the window mode. Remove the temporary variable as the last action of the macro. Confirm that your macro matches Figure 1. Save and close the macro and then save and close the form.

5. Open the Swimmers table in Datasheet View and then create a data macro associated with the Before Change event for the table. The macro checks the LevelID field. If the value in the LevelID field is less than 1, the macro should set the value to 1. If the LevelID field is greater than 6, then the macro should set the value to 6. Save and close the macro and then save and close the Swimmers table.
6. Create a Navigation form for the database using the Horizontal Tabs layout. Add the Clubs Datasheet form and the Coaches Datasheet form to the Navigation form in that order. Change the title of the form using Clubs Navigation Form as the new title and then save the navigation form using the same name as the new title. Switch to Form View and confirm that your form matches Figure 2. Save and close the Clubs Navigation Form.

7. Open the Reports List form in Design View. Add a command button to the form. Position the command button so that the top-left edge is at the 1" mark on the vertical ruler and the 2" mark on the horizontal ruler. The command button should run the submacro that previews the Swimmer Level Report. Use Preview Swimmer Level Report as the text for the button and use Preview_Swimmer_Level_Report as the name of the button. Change the width of the button to 2.3" to view the full button text. Confirm that your form matches Figure 3. Save and close the Reports List form.

8. Open the Members Navigation Form in Layout View. Modify the form by adding the Reports List form to the Navigation Form and moving the Members form so that it appears first in the list. Switch to Form View and confirm that the form matches Figure 4. Save and close the Members Navigation Form.

9. Open the Clubs and Coaches Report in Layout View and change the report layout to Stacked as shown in Figure 5. Save the change to the report and close it.

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 SAM website to submit your completed project.