New Perspectives Access 2016 | Module 6: SAM Project 1b

GRMH Recreation Centers

Creating Forms To Display Data

 

GETTING STARTED
  • Open the file NP_AC16_6b_ FirstLastName_1.accdb, available for download from the SAM website.
  • Save the file as NP_AC16_6b_ FirstLastName_2.accdbby changing the “1” to a “2”.
    • If you do not see the .accdbfile extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.
    • Open the _GradingInfoTabletable 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. Use the Split Form tool to create a split form based on the tblTrainertable, save the form as frmTrainerSplitForm, and then close the form.
    2. Open the frmMemberEntryform in Layout View and make the following changes:
      1. Select the control layout (which contains the Member ID, FirstName, LastName, Address, City, State, Zip, Phone, BirthDate, and Genderfields), and then in the Arrange tab, change the control padding to Narrow.
      2. Select the Address control pair, and then change the control margins to Medium.

      Save and close the form.

      1. Use the Datasheet form tool to create a datasheet form based on the tblBillingtable, save the form as frmBillingDataSheet, and then close the form.
      2. Use the Multiple Items form tool to create a multiple items form based on the tblTrainertable, save the form as frmTrainerMultiple, and then close the form.

        Refer to Figure 1a on the following page while completing Steps 5–7.

         


         

        Figure 1a: frmBilling Form in Form View

         

        1. Open the frmBillingform in Layout View. Change the title in the Form Header section to Billing for Training, and then change the font color of the form title to Green, Accent 6(10 thcolumn, 1 strow of the Theme Colors palette). Save the form.
        2. Switch to viewing the frmBillingform in Design View and make the following changes:
          1. Remove the BillingIDcontrol pair from the stacked layout. ( Hint: To make this control pair easier to manipulate, you may want to move it below the other controls on the form.)
          2. Reduce the width of the BillingIDtext box to approximately 0.7".
          3. Anchor the BillingIDcontrol pair to the Bottom Left of the form.

          Save the form, but do not close it.

          1. With the frmBillingform still open in Design View, change the tab order for the fields in the Detail section so the BillingIDfield is the last field in the tab order. ( Hint: Refer to Figure 1b on the following page.) Test the form in Form View, confirm that it looks similar to Figure 1a, and then save and close the form.


             

            Figure 1b: frmBilling Form Tab Order

             

            Refer to Figures 2a and 2b on the following pages while completing Steps 8–9.


             

            Figure 2a: frmLocationsAndEmployees Form in Layout View

             

            Figure 2b: frmLocationsAndEmployees Form in Design View

             

            1. Create a blank form in Design View, and then make the following updates:
              1. Add the LocationID, LocationName, Address, City, State, ZipCode, and Phonefields (in that order) from the tblLocationtable to the Detail section of the form.
              2. Reposition the controls to the approximate location shown in Figure 2b. ( Hint: The left edge of the text box controls should be at the 2"mark on the horizontal ruler.)
              3. Select the LocationNameand Addresstext box controls (but not the labels), and then resize them to match Figure 2b. ( Hint: The right edge of the controls should be at approximately the 4"mark on the horizontal ruler.)
              4. In the form header, add the title Locations and Employees. ( Hint:Do not type the period.)
              5. Save the form with the name frmLocationsAndEmployees, but do not close the form.
              6. Use the Subform Wizard to add a subform to the frmLocationsAndEmployeesform by completing the following steps:
                1. Insert the subform in the approximate location shown in Figure 2b.
                2. Include the EmployeeID, First, Last, and Titlefields (in that order) from the tblEmployeetable in the subform.
                3. Accept the default link using the common LocationIDfield between the form and subform.
                4. Save the subform using frmEmployeeSubformas the name.
                5. Delete the label associated with the subform.
                6. If necessary, resize and reposition the subform to the approximate location shown in Figure 2b.
                7. Switch to Layout View. Resize the Employee First, Employee Last, and Titlefields in the subform to Best Fit so the data is visible.

                Save and close the frmLocationsAndEmployeesform.

                Refer to Figure 3a below and Figure 3b on the following page while completing Steps 10–15.

                 

                Figure 3a: frmTrainersBilling Form in Form View

                 

                Figure 3b: frmTrainersBilling Form in Design View

                 

                1. Open the frmTrainersBillingform in Design View and complete the following steps:
                  1. Delete the LastNamelabel and change the caption for the FirstNamelabel to Trainer. ( Hint:Do not type the period.)
                  2. Select the Trainerand Specialtylabels, and then align their left edges.
                  3. Select the LastNameand Specialtytextbox controls, and then align their left edges.

                  Save, but do not close, the form.

                  1. Add a title to the frmTrainersBillingForm Header section. Use Trainers and Billingfor the title instead of the default text.
                  2. Make sure the form’s Record Source property is set to tblTrainer, and then use the Combo Box Wizard to add a combo box in the Form Header section by completing the following steps:
                    1. Add a combo box to the approximate location shown in Figure 3b. ( Hint: Position the pointer at the top of the Form Header and at the 5.5"mark on the horizontal ruler when inserting this combo box.)
                    2. The combo box should find a record in the form based on a selected value.
                    3. Select the TrainerID, LastName, and FirstNamefields (in that order) for the combo box.
                    4. Do not hide the key column.
                    5. Resize the columns to Best Fit so all data is visible in the combo box.
                    6. Use the label Trainer IDfor the combo box.
                    7. If necessary, resize and reposition the combo box control to approximately match the location shown in Figure 3b.
                    8. Switch to Form View, and then use the Combo box to find the record for Trainer 778, Nick Collins.

                    Save the form, and then close it.

                    1. Open the frmBillingSubformform in Design View. Add a calculated control to the frmBillingSubformForm Footer section by completing the following steps:
                      1. Insert a text box in the Form Footer section at the approximate location shown in Figure 4 on the following page. ( Hint: Position the pointer just below the top of the Form Footer section on the vertical ruler and at approximately the 1"mark on the horizontal ruler.)
                      2. Enter an expression in the text box control that displays the total number of invoices displayed in the form. ( Hint: The calculated control should contain the Count function and the BillingIDfield.)
                      3. Set the Name property of the calculated control to txtCountBilling. ( Hint:Do not type the period.)
                      4. Insert a second text box below the text box you just added) in the Form Footer section at the approximate location shown in Figure 4 on the following page. ( Hint: Position the pointer at approximately the 0.5"mark on the vertical ruler and at approximately the 1"mark on the horizontal ruler.)
                      5. Enter an expression in the text box control that displays the total amount of the invoices displayed in the form. ( Hint: The calculated control should contain the SUM function and the Amountfield.)
                      6. Set the Name property of the calculated control to txtSumAmount. ( Hint:Do not type the period.)

                      Save and close the frmBillingSubform.

                       

                      Figure 4: frmBillingSubform Form in Design View

                       

                      1. Open the frmTrainersBillingform in Design View. Add calculated controls to the Detail section of the form by following the directions below:
                        1. Insert a text box control in the approximate location shown in Figure 3b on page 7.
                        2. Change the Caption property of the label associated with the text box to Number of Invoices. ( Hint:Do not type the period.)
                        3. Add an expression that displays the txtCountBillingcontrol value from the frmBillingSubformsubform.
                        4. Add a second text box control (below the control you just added) in the approximate location shown in Figure 3b on page 7.
                        5. Change the Caption property of the label associated with the second text box to Total Amount. ( Hint:Do not type the period.)
                        6. Add an expression to the second text box that displays the txtSumAmountcontrol value from the frmBillingSubformsubform.
                        7. Set the format for this calculated control to Currency.
                        8. Resize and position the calculated controls as shown in Figure 3b on page 7.
                        9. Set the Tab Stop property for both calculated controls to No.

                        Save the form without closing it.

                        1. Draw a rectangle around the calculated controls and their labels, as shown in Figure 3b on page 7. Set the rectangle’s properties to match those listed below:
                          1. Set the Border Width property to 4 pt.( Hint: The border width is the same as the Shape Outline’s Line Thickness.)
                          2. Set the Special Effect property to Raised.

                          Switch to Form View and test the form, and then save 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.

                          New Perspectives Access 2016 | Module 6: SAM Project 1b

                          GRMH Recreation Centers

                          Creating Forms To Display Data

                           

                          GETTING STARTED
                          • Open the file NP_AC16_6b_ FirstLastName_1.accdb, available for download from the SAM website.
                          • Save the file as NP_AC16_6b_ FirstLastName_2.accdbby changing the “1” to a “2”.
                            • If you do not see the .accdbfile extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.
                            • Open the _GradingInfoTabletable 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. Use the Split Form tool to create a split form based on the tblTrainertable, save the form as frmTrainerSplitForm, and then close the form.
                            2. Open the frmMemberEntryform in Layout View and make the following changes:
                              1. Select the control layout (which contains the Member ID, FirstName, LastName, Address, City, State, Zip, Phone, BirthDate, and Genderfields), and then in the Arrange tab, change the control padding to Narrow.
                              2. Select the Address control pair, and then change the control margins to Medium.

                              Save and close the form.

                              1. Use the Datasheet form tool to create a datasheet form based on the tblBillingtable, save the form as frmBillingDataSheet, and then close the form.
                              2. Use the Multiple Items form tool to create a multiple items form based on the tblTrainertable, save the form as frmTrainerMultiple, and then close the form.

                                Refer to Figure 1a on the following page while completing Steps 5–7.

                                 


                                 

                                Figure 1a: frmBilling Form in Form View

                                 

                                1. Open the frmBillingform in Layout View. Change the title in the Form Header section to Billing for Training, and then change the font color of the form title to Green, Accent 6(10 thcolumn, 1 strow of the Theme Colors palette). Save the form.
                                2. Switch to viewing the frmBillingform in Design View and make the following changes:
                                  1. Remove the BillingIDcontrol pair from the stacked layout. ( Hint: To make this control pair easier to manipulate, you may want to move it below the other controls on the form.)
                                  2. Reduce the width of the BillingIDtext box to approximately 0.7".
                                  3. Anchor the BillingIDcontrol pair to the Bottom Left of the form.

                                  Save the form, but do not close it.

                                  1. With the frmBillingform still open in Design View, change the tab order for the fields in the Detail section so the BillingIDfield is the last field in the tab order. ( Hint: Refer to Figure 1b on the following page.) Test the form in Form View, confirm that it looks similar to Figure 1a, and then save and close the form.


                                     

                                    Figure 1b: frmBilling Form Tab Order

                                     

                                    Refer to Figures 2a and 2b on the following pages while completing Steps 8–9.


                                     

                                    Figure 2a: frmLocationsAndEmployees Form in Layout View

                                     

                                    Figure 2b: frmLocationsAndEmployees Form in Design View

                                     

                                    1. Create a blank form in Design View, and then make the following updates:
                                      1. Add the LocationID, LocationName, Address, City, State, ZipCode, and Phonefields (in that order) from the tblLocationtable to the Detail section of the form.
                                      2. Reposition the controls to the approximate location shown in Figure 2b. ( Hint: The left edge of the text box controls should be at the 2"mark on the horizontal ruler.)
                                      3. Select the LocationNameand Addresstext box controls (but not the labels), and then resize them to match Figure 2b. ( Hint: The right edge of the controls should be at approximately the 4"mark on the horizontal ruler.)
                                      4. In the form header, add the title Locations and Employees. ( Hint:Do not type the period.)
                                      5. Save the form with the name frmLocationsAndEmployees, but do not close the form.
                                      6. Use the Subform Wizard to add a subform to the frmLocationsAndEmployeesform by completing the following steps:
                                        1. Insert the subform in the approximate location shown in Figure 2b.
                                        2. Include the EmployeeID, First, Last, and Titlefields (in that order) from the tblEmployeetable in the subform.
                                        3. Accept the default link using the common LocationIDfield between the form and subform.
                                        4. Save the subform using frmEmployeeSubformas the name.
                                        5. Delete the label associated with the subform.
                                        6. If necessary, resize and reposition the subform to the approximate location shown in Figure 2b.
                                        7. Switch to Layout View. Resize the Employee First, Employee Last, and Titlefields in the subform to Best Fit so the data is visible.

                                        Save and close the frmLocationsAndEmployeesform.

                                        Refer to Figure 3a below and Figure 3b on the following page while completing Steps 10–15.

                                         

                                        Figure 3a: frmTrainersBilling Form in Form View

                                         

                                        Figure 3b: frmTrainersBilling Form in Design View

                                         

                                        1. Open the frmTrainersBillingform in Design View and complete the following steps:
                                          1. Delete the LastNamelabel and change the caption for the FirstNamelabel to Trainer. ( Hint:Do not type the period.)
                                          2. Select the Trainerand Specialtylabels, and then align their left edges.
                                          3. Select the LastNameand Specialtytextbox controls, and then align their left edges.

                                          Save, but do not close, the form.

                                          1. Add a title to the frmTrainersBillingForm Header section. Use Trainers and Billingfor the title instead of the default text.
                                          2. Make sure the form’s Record Source property is set to tblTrainer, and then use the Combo Box Wizard to add a combo box in the Form Header section by completing the following steps:
                                            1. Add a combo box to the approximate location shown in Figure 3b. ( Hint: Position the pointer at the top of the Form Header and at the 5.5"mark on the horizontal ruler when inserting this combo box.)
                                            2. The combo box should find a record in the form based on a selected value.
                                            3. Select the TrainerID, LastName, and FirstNamefields (in that order) for the combo box.
                                            4. Do not hide the key column.
                                            5. Resize the columns to Best Fit so all data is visible in the combo box.
                                            6. Use the label Trainer IDfor the combo box.
                                            7. If necessary, resize and reposition the combo box control to approximately match the location shown in Figure 3b.
                                            8. Switch to Form View, and then use the Combo box to find the record for Trainer 778, Nick Collins.

                                            Save the form, and then close it.

                                            1. Open the frmBillingSubformform in Design View. Add a calculated control to the frmBillingSubformForm Footer section by completing the following steps:
                                              1. Insert a text box in the Form Footer section at the approximate location shown in Figure 4 on the following page. ( Hint: Position the pointer just below the top of the Form Footer section on the vertical ruler and at approximately the 1"mark on the horizontal ruler.)
                                              2. Enter an expression in the text box control that displays the total number of invoices displayed in the form. ( Hint: The calculated control should contain the Count function and the BillingIDfield.)
                                              3. Set the Name property of the calculated control to txtCountBilling. ( Hint:Do not type the period.)
                                              4. Insert a second text box below the text box you just added) in the Form Footer section at the approximate location shown in Figure 4 on the following page. ( Hint: Position the pointer at approximately the 0.5"mark on the vertical ruler and at approximately the 1"mark on the horizontal ruler.)
                                              5. Enter an expression in the text box control that displays the total amount of the invoices displayed in the form. ( Hint: The calculated control should contain the SUM function and the Amountfield.)
                                              6. Set the Name property of the calculated control to txtSumAmount. ( Hint:Do not type the period.)

                                              Save and close the frmBillingSubform.

                                               

                                              Figure 4: frmBillingSubform Form in Design View

                                               

                                              1. Open the frmTrainersBillingform in Design View. Add calculated controls to the Detail section of the form by following the directions below:
                                                1. Insert a text box control in the approximate location shown in Figure 3b on page 7.
                                                2. Change the Caption property of the label associated with the text box to Number of Invoices. ( Hint:Do not type the period.)
                                                3. Add an expression that displays the txtCountBillingcontrol value from the frmBillingSubformsubform.
                                                4. Add a second text box control (below the control you just added) in the approximate location shown in Figure 3b on page 7.
                                                5. Change the Caption property of the label associated with the second text box to Total Amount. ( Hint:Do not type the period.)
                                                6. Add an expression to the second text box that displays the txtSumAmountcontrol value from the frmBillingSubformsubform.
                                                7. Set the format for this calculated control to Currency.
                                                8. Resize and position the calculated controls as shown in Figure 3b on page 7.
                                                9. Set the Tab Stop property for both calculated controls to No.

                                                Save the form without closing it.

                                                1. Draw a rectangle around the calculated controls and their labels, as shown in Figure 3b on page 7. Set the rectangle’s properties to match those listed below:
                                                  1. Set the Border Width property to 4 pt.( Hint: The border width is the same as the Shape Outline’s Line Thickness.)
                                                  2. Set the Special Effect property to Raised.

                                                  Switch to Form View and test the form, and then save 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.

                                                  New Perspectives Access 2016 | Module 6: SAM Project 1b

                                                  GRMH Recreation Centers

                                                  Creating Forms To Display Data

                                                   

                                                  GETTING STARTED
                                                  • Open the file NP_AC16_6b_ FirstLastName_1.accdb, available for download from the SAM website.
                                                  • Save the file as NP_AC16_6b_ FirstLastName_2.accdbby changing the “1” to a “2”.
                                                    • If you do not see the .accdbfile extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.
                                                    • Open the _GradingInfoTabletable 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. Use the Split Form tool to create a split form based on the tblTrainertable, save the form as frmTrainerSplitForm, and then close the form.
                                                    2. Open the frmMemberEntryform in Layout View and make the following changes:
                                                      1. Select the control layout (which contains the Member ID, FirstName, LastName, Address, City, State, Zip, Phone, BirthDate, and Genderfields), and then in the Arrange tab, change the control padding to Narrow.
                                                      2. Select the Address control pair, and then change the control margins to Medium.

                                                      Save and close the form.

                                                      1. Use the Datasheet form tool to create a datasheet form based on the tblBillingtable, save the form as frmBillingDataSheet, and then close the form.
                                                      2. Use the Multiple Items form tool to create a multiple items form based on the tblTrainertable, save the form as frmTrainerMultiple, and then close the form.

                                                        Refer to Figure 1a on the following page while completing Steps 5–7.

                                                         


                                                         

                                                        Figure 1a: frmBilling Form in Form View

                                                         

                                                        1. Open the frmBillingform in Layout View. Change the title in the Form Header section to Billing for Training, and then change the font color of the form title to Green, Accent 6(10 thcolumn, 1 strow of the Theme Colors palette). Save the form.
                                                        2. Switch to viewing the frmBillingform in Design View and make the following changes:
                                                          1. Remove the BillingIDcontrol pair from the stacked layout. ( Hint: To make this control pair easier to manipulate, you may want to move it below the other controls on the form.)
                                                          2. Reduce the width of the BillingIDtext box to approximately 0.7".
                                                          3. Anchor the BillingIDcontrol pair to the Bottom Left of the form.

                                                          Save the form, but do not close it.

                                                          1. With the frmBillingform still open in Design View, change the tab order for the fields in the Detail section so the BillingIDfield is the last field in the tab order. ( Hint: Refer to Figure 1b on the following page.) Test the form in Form View, confirm that it looks similar to Figure 1a, and then save and close the form.


                                                             

                                                            Figure 1b: frmBilling Form Tab Order

                                                             

                                                            Refer to Figures 2a and 2b on the following pages while completing Steps 8–9.


                                                             

                                                            Figure 2a: frmLocationsAndEmployees Form in Layout View

                                                             

                                                            Figure 2b: frmLocationsAndEmployees Form in Design View

                                                             

                                                            1. Create a blank form in Design View, and then make the following updates:
                                                              1. Add the LocationID, LocationName, Address, City, State, ZipCode, and Phonefields (in that order) from the tblLocationtable to the Detail section of the form.
                                                              2. Reposition the controls to the approximate location shown in Figure 2b. ( Hint: The left edge of the text box controls should be at the 2"mark on the horizontal ruler.)
                                                              3. Select the LocationNameand Addresstext box controls (but not the labels), and then resize them to match Figure 2b. ( Hint: The right edge of the controls should be at approximately the 4"mark on the horizontal ruler.)
                                                              4. In the form header, add the title Locations and Employees. ( Hint:Do not type the period.)
                                                              5. Save the form with the name frmLocationsAndEmployees, but do not close the form.
                                                              6. Use the Subform Wizard to add a subform to the frmLocationsAndEmployeesform by completing the following steps:
                                                                1. Insert the subform in the approximate location shown in Figure 2b.
                                                                2. Include the EmployeeID, First, Last, and Titlefields (in that order) from the tblEmployeetable in the subform.
                                                                3. Accept the default link using the common LocationIDfield between the form and subform.
                                                                4. Save the subform using frmEmployeeSubformas the name.
                                                                5. Delete the label associated with the subform.
                                                                6. If necessary, resize and reposition the subform to the approximate location shown in Figure 2b.
                                                                7. Switch to Layout View. Resize the Employee First, Employee Last, and Titlefields in the subform to Best Fit so the data is visible.

                                                                Save and close the frmLocationsAndEmployeesform.

                                                                Refer to Figure 3a below and Figure 3b on the following page while completing Steps 10–15.

                                                                 

                                                                Figure 3a: frmTrainersBilling Form in Form View

                                                                 

                                                                Figure 3b: frmTrainersBilling Form in Design View

                                                                 

                                                                1. Open the frmTrainersBillingform in Design View and complete the following steps:
                                                                  1. Delete the LastNamelabel and change the caption for the FirstNamelabel to Trainer. ( Hint:Do not type the period.)
                                                                  2. Select the Trainerand Specialtylabels, and then align their left edges.
                                                                  3. Select the LastNameand Specialtytextbox controls, and then align their left edges.

                                                                  Save, but do not close, the form.

                                                                  1. Add a title to the frmTrainersBillingForm Header section. Use Trainers and Billingfor the title instead of the default text.
                                                                  2. Make sure the form’s Record Source property is set to tblTrainer, and then use the Combo Box Wizard to add a combo box in the Form Header section by completing the following steps:
                                                                    1. Add a combo box to the approximate location shown in Figure 3b. ( Hint: Position the pointer at the top of the Form Header and at the 5.5"mark on the horizontal ruler when inserting this combo box.)
                                                                    2. The combo box should find a record in the form based on a selected value.
                                                                    3. Select the TrainerID, LastName, and FirstNamefields (in that order) for the combo box.
                                                                    4. Do not hide the key column.
                                                                    5. Resize the columns to Best Fit so all data is visible in the combo box.
                                                                    6. Use the label Trainer IDfor the combo box.
                                                                    7. If necessary, resize and reposition the combo box control to approximately match the location shown in Figure 3b.
                                                                    8. Switch to Form View, and then use the Combo box to find the record for Trainer 778, Nick Collins.

                                                                    Save the form, and then close it.

                                                                    1. Open the frmBillingSubformform in Design View. Add a calculated control to the frmBillingSubformForm Footer section by completing the following steps:
                                                                      1. Insert a text box in the Form Footer section at the approximate location shown in Figure 4 on the following page. ( Hint: Position the pointer just below the top of the Form Footer section on the vertical ruler and at approximately the 1"mark on the horizontal ruler.)
                                                                      2. Enter an expression in the text box control that displays the total number of invoices displayed in the form. ( Hint: The calculated control should contain the Count function and the BillingIDfield.)
                                                                      3. Set the Name property of the calculated control to txtCountBilling. ( Hint:Do not type the period.)
                                                                      4. Insert a second text box below the text box you just added) in the Form Footer section at the approximate location shown in Figure 4 on the following page. ( Hint: Position the pointer at approximately the 0.5"mark on the vertical ruler and at approximately the 1"mark on the horizontal ruler.)
                                                                      5. Enter an expression in the text box control that displays the total amount of the invoices displayed in the form. ( Hint: The calculated control should contain the SUM function and the Amountfield.)
                                                                      6. Set the Name property of the calculated control to txtSumAmount. ( Hint:Do not type the period.)

                                                                      Save and close the frmBillingSubform.

                                                                       

                                                                      Figure 4: frmBillingSubform Form in Design View

                                                                       

                                                                      1. Open the frmTrainersBillingform in Design View. Add calculated controls to the Detail section of the form by following the directions below:
                                                                        1. Insert a text box control in the approximate location shown in Figure 3b on page 7.
                                                                        2. Change the Caption property of the label associated with the text box to Number of Invoices. ( Hint:Do not type the period.)
                                                                        3. Add an expression that displays the txtCountBillingcontrol value from the frmBillingSubformsubform.
                                                                        4. Add a second text box control (below the control you just added) in the approximate location shown in Figure 3b on page 7.
                                                                        5. Change the Caption property of the label associated with the second text box to Total Amount. ( Hint:Do not type the period.)
                                                                        6. Add an expression to the second text box that displays the txtSumAmountcontrol value from the frmBillingSubformsubform.
                                                                        7. Set the format for this calculated control to Currency.
                                                                        8. Resize and position the calculated controls as shown in Figure 3b on page 7.
                                                                        9. Set the Tab Stop property for both calculated controls to No.

                                                                        Save the form without closing it.

                                                                        1. Draw a rectangle around the calculated controls and their labels, as shown in Figure 3b on page 7. Set the rectangle’s properties to match those listed below:
                                                                          1. Set the Border Width property to 4 pt.( Hint: The border width is the same as the Shape Outline’s Line Thickness.)
                                                                          2. Set the Special Effect property to Raised.

                                                                          Switch to Form View and test the form, and then save 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.

                                                                          New Perspectives Access 2016 | Module 6: SAM Project 1b New Perspectives Access 2016 | Module 6: SAM Project 1b New Perspectives  | Module 6: SAM Project 1b | Module 6: SAM Project 1b

                                                                          GRMH Recreation Centers GRMH Recreation Centers

                                                                          Creating Forms To Display Data

                                                                          Creating Forms To Display Data Creating Forms To Display Data

                                                                             

                                                                          GETTING STARTED GETTING STARTED
                                                                          • Open the file NP_AC16_6b_ FirstLastName_1.accdb, available for download from the SAM website.
                                                                          • Save the file as NP_AC16_6b_ FirstLastName_2.accdbby changing the “1” to a “2”.
                                                                            • If you do not see the .accdbfile extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.
                                                                            • Open the _GradingInfoTabletable 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.
                                                                          • Open the file NP_AC16_6b_ FirstLastName_1.accdb, available for download from the SAM website. Open the file NP_AC16_6b_ FirstLastName_1.accdb, available for download from the SAM website. NP_AC16_6b_ FirstLastName_1.accdb FirstLastName
                                                                          • Save the file as NP_AC16_6b_ FirstLastName_2.accdbby changing the “1” to a “2”.
                                                                            • If you do not see the .accdbfile extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.
                                                                            • Open the _GradingInfoTabletable 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.
                                                                            Save the file as NP_AC16_6b_ FirstLastName_2.accdbby changing the “1” to a “2”. NP_AC16_6b_ FirstLastName_2.accdb FirstLastName
                                                                            • If you do not see the .accdbfile extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.
                                                                            • Open the _GradingInfoTabletable 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.
                                                                          • If you do not see the .accdbfile extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.
                                                                          • .accdb
                                                                          • Open the _GradingInfoTabletable 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.
                                                                          • _GradingInfoTable

                                                                               

                                                                            PROJECT STEPS PROJECT STEPS
                                                                            1. Use the Split Form tool to create a split form based on the tblTrainertable, save the form as frmTrainerSplitForm, and then close the form.
                                                                            2. Open the frmMemberEntryform in Layout View and make the following changes:
                                                                              1. Select the control layout (which contains the Member ID, FirstName, LastName, Address, City, State, Zip, Phone, BirthDate, and Genderfields), and then in the Arrange tab, change the control padding to Narrow.
                                                                              2. Select the Address control pair, and then change the control margins to Medium.
                                                                            3. Use the Split Form tool to create a split form based on the tblTrainertable, save the form as frmTrainerSplitForm, and then close the form. Use the Split Form tool to create a split form based on the tblTrainertable, save the form as frmTrainerSplitForm, and then close the form. tblTrainer frmTrainerSplitForm
                                                                            4. Open the frmMemberEntryform in Layout View and make the following changes:
                                                                              1. Select the control layout (which contains the Member ID, FirstName, LastName, Address, City, State, Zip, Phone, BirthDate, and Genderfields), and then in the Arrange tab, change the control padding to Narrow.
                                                                              2. Select the Address control pair, and then change the control margins to Medium.
                                                                              Open the frmMemberEntryform in Layout View and make the following changes: frmMemberEntry
                                                                              1. Select the control layout (which contains the Member ID, FirstName, LastName, Address, City, State, Zip, Phone, BirthDate, and Genderfields), and then in the Arrange tab, change the control padding to Narrow.
                                                                              2. Select the Address control pair, and then change the control margins to Medium.
                                                                            5. Select the control layout (which contains the Member ID, FirstName, LastName, Address, City, State, Zip, Phone, BirthDate, and Genderfields), and then in the Arrange tab, change the control padding to Narrow.
                                                                            6. Member ID FirstName LastName Address City State Zip Phone BirthDate Gender Narrow
                                                                            7. Select the Address control pair, and then change the control margins to Medium.
                                                                            8. Medium

                                                                              Save and close the form. Save and close the form.

                                                                              1. Use the Datasheet form tool to create a datasheet form based on the tblBillingtable, save the form as frmBillingDataSheet, and then close the form.
                                                                              2. Use the Multiple Items form tool to create a multiple items form based on the tblTrainertable, save the form as frmTrainerMultiple, and then close the form.
                                                                              3. Use the Datasheet form tool to create a datasheet form based on the tblBillingtable, save the form as frmBillingDataSheet, and then close the form. Use the Datasheet form tool to create a datasheet form based on the tblBillingtable, save the form as frmBillingDataSheet, and then close the form. tblBilling frmBillingDataSheet
                                                                              4. Use the Multiple Items form tool to create a multiple items form based on the tblTrainertable, save the form as frmTrainerMultiple, and then close the form. Use the Multiple Items form tool to create a multiple items form based on the tblTrainertable, save the form as frmTrainerMultiple, and then close the form. tblTrainer frmTrainerMultiple

                                                                                Refer to Figure 1a on the following page while completing Steps 5–7. Refer to Figure 1a on the following page while completing Steps 5–7. Refer to Figure 1a on the following page while completing Steps 5–7.

                                                                                     






                                                                                       

                                                                                Figure 1a: frmBilling Form in Form View

                                                                                Figure 1a: frmBilling Form in Form View Figure 1a: frmBilling Form in Form View

                                                                                   

                                                                                1. Open the frmBillingform in Layout View. Change the title in the Form Header section to Billing for Training, and then change the font color of the form title to Green, Accent 6(10 thcolumn, 1 strow of the Theme Colors palette). Save the form.
                                                                                2. Switch to viewing the frmBillingform in Design View and make the following changes:
                                                                                  1. Remove the BillingIDcontrol pair from the stacked layout. ( Hint: To make this control pair easier to manipulate, you may want to move it below the other controls on the form.)
                                                                                  2. Reduce the width of the BillingIDtext box to approximately 0.7".
                                                                                  3. Anchor the BillingIDcontrol pair to the Bottom Left of the form.
                                                                                3. Open the frmBillingform in Layout View. Change the title in the Form Header section to Billing for Training, and then change the font color of the form title to Green, Accent 6(10 thcolumn, 1 strow of the Theme Colors palette). Save the form. Open the frmBillingform in Layout View. Change the title in the Form Header section to Billing for Training, and then change the font color of the form title to Green, Accent 6(10 thcolumn, 1 strow of the Theme Colors palette). Save the form. frmBilling Billing for Training Green, Accent 6 th st
                                                                                4. Switch to viewing the frmBillingform in Design View and make the following changes:
                                                                                  1. Remove the BillingIDcontrol pair from the stacked layout. ( Hint: To make this control pair easier to manipulate, you may want to move it below the other controls on the form.)
                                                                                  2. Reduce the width of the BillingIDtext box to approximately 0.7".
                                                                                  3. Anchor the BillingIDcontrol pair to the Bottom Left of the form.
                                                                                  Switch to viewing the frmBillingform in Design View and make the following changes: frmBilling
                                                                                  1. Remove the BillingIDcontrol pair from the stacked layout. ( Hint: To make this control pair easier to manipulate, you may want to move it below the other controls on the form.)
                                                                                  2. Reduce the width of the BillingIDtext box to approximately 0.7".
                                                                                  3. Anchor the BillingIDcontrol pair to the Bottom Left of the form.
                                                                                5. Remove the BillingIDcontrol pair from the stacked layout. ( Hint: To make this control pair easier to manipulate, you may want to move it below the other controls on the form.)
                                                                                6. BillingID Hint
                                                                                7. Reduce the width of the BillingIDtext box to approximately 0.7".
                                                                                8. BillingID 0.7"
                                                                                9. Anchor the BillingIDcontrol pair to the Bottom Left of the form.
                                                                                10. BillingID

                                                                                  Save the form, but do not close it. Save the form, but do not close it.

                                                                                  1. With the frmBillingform still open in Design View, change the tab order for the fields in the Detail section so the BillingIDfield is the last field in the tab order. ( Hint: Refer to Figure 1b on the following page.) Test the form in Form View, confirm that it looks similar to Figure 1a, and then save and close the form.
                                                                                  2. With the frmBillingform still open in Design View, change the tab order for the fields in the Detail section so the BillingIDfield is the last field in the tab order. ( Hint: Refer to Figure 1b on the following page.) Test the form in Form View, confirm that it looks similar to Figure 1a, and then save and close the form. With the frmBillingform still open in Design View, change the tab order for the fields in the Detail section so the BillingIDfield is the last field in the tab order. ( Hint: Refer to Figure 1b on the following page.) Test the form in Form View, confirm that it looks similar to Figure 1a, and then save and close the form. frmBilling BillingID Hint




                                                                                       

                                                                                    Figure 1b: frmBilling Form Tab Order

                                                                                    Figure 1b: frmBilling Form Tab Order Figure 1b: frmBilling Form Tab Order

                                                                                       

                                                                                    Refer to Figures 2a and 2b on the following pages while completing Steps 8–9. Refer to Figures 2a and 2b on the following pages while completing Steps 8–9. Refer to Figures 2a and 2b on the following pages while completing Steps 8–9.






                                                                                           

                                                                                    Figure 2a: frmLocationsAndEmployees Form in Layout View

                                                                                    Figure 2a: frmLocationsAndEmployees Form in Layout View Figure 2a: frmLocationsAndEmployees Form in Layout View

                                                                                       

                                                                                    Figure 2b: frmLocationsAndEmployees Form in Design View

                                                                                    Figure 2b: frmLocationsAndEmployees Form in Design View Figure 2b: frmLocationsAndEmployees Form in Design View

                                                                                       

                                                                                    1. Create a blank form in Design View, and then make the following updates:
                                                                                      1. Add the LocationID, LocationName, Address, City, State, ZipCode, and Phonefields (in that order) from the tblLocationtable to the Detail section of the form.
                                                                                      2. Reposition the controls to the approximate location shown in Figure 2b. ( Hint: The left edge of the text box controls should be at the 2"mark on the horizontal ruler.)
                                                                                      3. Select the LocationNameand Addresstext box controls (but not the labels), and then resize them to match Figure 2b. ( Hint: The right edge of the controls should be at approximately the 4"mark on the horizontal ruler.)
                                                                                      4. In the form header, add the title Locations and Employees. ( Hint:Do not type the period.)
                                                                                      5. Save the form with the name frmLocationsAndEmployees, but do not close the form.
                                                                                      6. Use the Subform Wizard to add a subform to the frmLocationsAndEmployeesform by completing the following steps:
                                                                                        1. Insert the subform in the approximate location shown in Figure 2b.
                                                                                        2. Include the EmployeeID, First, Last, and Titlefields (in that order) from the tblEmployeetable in the subform.
                                                                                        3. Accept the default link using the common LocationIDfield between the form and subform.
                                                                                        4. Save the subform using frmEmployeeSubformas the name.
                                                                                        5. Delete the label associated with the subform.
                                                                                        6. If necessary, resize and reposition the subform to the approximate location shown in Figure 2b.
                                                                                        7. Switch to Layout View. Resize the Employee First, Employee Last, and Titlefields in the subform to Best Fit so the data is visible.
                                                                                      7. Create a blank form in Design View, and then make the following updates:
                                                                                        1. Add the LocationID, LocationName, Address, City, State, ZipCode, and Phonefields (in that order) from the tblLocationtable to the Detail section of the form.
                                                                                        2. Reposition the controls to the approximate location shown in Figure 2b. ( Hint: The left edge of the text box controls should be at the 2"mark on the horizontal ruler.)
                                                                                        3. Select the LocationNameand Addresstext box controls (but not the labels), and then resize them to match Figure 2b. ( Hint: The right edge of the controls should be at approximately the 4"mark on the horizontal ruler.)
                                                                                        4. In the form header, add the title Locations and Employees. ( Hint:Do not type the period.)
                                                                                        5. Save the form with the name frmLocationsAndEmployees, but do not close the form.
                                                                                        6. Use the Subform Wizard to add a subform to the frmLocationsAndEmployeesform by completing the following steps:
                                                                                          1. Insert the subform in the approximate location shown in Figure 2b.
                                                                                          2. Include the EmployeeID, First, Last, and Titlefields (in that order) from the tblEmployeetable in the subform.
                                                                                          3. Accept the default link using the common LocationIDfield between the form and subform.
                                                                                          4. Save the subform using frmEmployeeSubformas the name.
                                                                                          5. Delete the label associated with the subform.
                                                                                          6. If necessary, resize and reposition the subform to the approximate location shown in Figure 2b.
                                                                                          7. Switch to Layout View. Resize the Employee First, Employee Last, and Titlefields in the subform to Best Fit so the data is visible.
                                                                                          Create a blank form in Design View, and then make the following updates:
                                                                                          1. Add the LocationID, LocationName, Address, City, State, ZipCode, and Phonefields (in that order) from the tblLocationtable to the Detail section of the form.
                                                                                          2. Reposition the controls to the approximate location shown in Figure 2b. ( Hint: The left edge of the text box controls should be at the 2"mark on the horizontal ruler.)
                                                                                          3. Select the LocationNameand Addresstext box controls (but not the labels), and then resize them to match Figure 2b. ( Hint: The right edge of the controls should be at approximately the 4"mark on the horizontal ruler.)
                                                                                          4. In the form header, add the title Locations and Employees. ( Hint:Do not type the period.)
                                                                                          5. Save the form with the name frmLocationsAndEmployees, but do not close the form.
                                                                                          6. Use the Subform Wizard to add a subform to the frmLocationsAndEmployeesform by completing the following steps:
                                                                                            1. Insert the subform in the approximate location shown in Figure 2b.
                                                                                            2. Include the EmployeeID, First, Last, and Titlefields (in that order) from the tblEmployeetable in the subform.
                                                                                            3. Accept the default link using the common LocationIDfield between the form and subform.
                                                                                            4. Save the subform using frmEmployeeSubformas the name.
                                                                                            5. Delete the label associated with the subform.
                                                                                            6. If necessary, resize and reposition the subform to the approximate location shown in Figure 2b.
                                                                                            7. Switch to Layout View. Resize the Employee First, Employee Last, and Titlefields in the subform to Best Fit so the data is visible.
                                                                                          7. Add the LocationID, LocationName, Address, City, State, ZipCode, and Phonefields (in that order) from the tblLocationtable to the Detail section of the form.
                                                                                          8. LocationID LocationName Address City State ZipCode Phone tblLocation
                                                                                          9. Reposition the controls to the approximate location shown in Figure 2b. ( Hint: The left edge of the text box controls should be at the 2"mark on the horizontal ruler.)
                                                                                          10. Hint 2"
                                                                                          11. Select the LocationNameand Addresstext box controls (but not the labels), and then resize them to match Figure 2b. ( Hint: The right edge of the controls should be at approximately the 4"mark on the horizontal ruler.)
                                                                                          12. LocationName Address Hint 4"
                                                                                          13. In the form header, add the title Locations and Employees. ( Hint:Do not type the period.)
                                                                                          14. Locations and Employees Hint:
                                                                                          15. Save the form with the name frmLocationsAndEmployees, but do not close the form.
                                                                                          16. frmLocationsAndEmployees
                                                                                          17. Use the Subform Wizard to add a subform to the frmLocationsAndEmployeesform by completing the following steps:
                                                                                            1. Insert the subform in the approximate location shown in Figure 2b.
                                                                                            2. Include the EmployeeID, First, Last, and Titlefields (in that order) from the tblEmployeetable in the subform.
                                                                                            3. Accept the default link using the common LocationIDfield between the form and subform.
                                                                                            4. Save the subform using frmEmployeeSubformas the name.
                                                                                            5. Delete the label associated with the subform.
                                                                                            6. If necessary, resize and reposition the subform to the approximate location shown in Figure 2b.
                                                                                            7. Switch to Layout View. Resize the Employee First, Employee Last, and Titlefields in the subform to Best Fit so the data is visible.
                                                                                            Use the Subform Wizard to add a subform to the frmLocationsAndEmployeesform by completing the following steps: frmLocationsAndEmployees
                                                                                            1. Insert the subform in the approximate location shown in Figure 2b.
                                                                                            2. Include the EmployeeID, First, Last, and Titlefields (in that order) from the tblEmployeetable in the subform.
                                                                                            3. Accept the default link using the common LocationIDfield between the form and subform.
                                                                                            4. Save the subform using frmEmployeeSubformas the name.
                                                                                            5. Delete the label associated with the subform.
                                                                                            6. If necessary, resize and reposition the subform to the approximate location shown in Figure 2b.
                                                                                            7. Switch to Layout View. Resize the Employee First, Employee Last, and Titlefields in the subform to Best Fit so the data is visible.
                                                                                          18. Insert the subform in the approximate location shown in Figure 2b.
                                                                                          19. Include the EmployeeID, First, Last, and Titlefields (in that order) from the tblEmployeetable in the subform.
                                                                                          20. EmployeeID First Last Title tblEmployee
                                                                                          21. Accept the default link using the common LocationIDfield between the form and subform.
                                                                                          22. LocationID
                                                                                          23. Save the subform using frmEmployeeSubformas the name.
                                                                                          24. frmEmployeeSubform
                                                                                          25. Delete the label associated with the subform.
                                                                                          26. If necessary, resize and reposition the subform to the approximate location shown in Figure 2b.
                                                                                          27. Switch to Layout View. Resize the Employee First, Employee Last, and Titlefields in the subform to Best Fit so the data is visible.
                                                                                          28. Employee First Employee Last Title

                                                                                            Save and close the frmLocationsAndEmployeesform. Save and close the frmLocationsAndEmployeesform. frmLocationsAndEmployees

                                                                                            Refer to Figure 3a below and Figure 3b on the following page while completing Steps 10–15. Refer to Figure 3a below and Figure 3b on the following page while completing Steps 10–15. Refer to Figure 3a below and Figure 3b on the following page while completing Steps 10–15. Refer to Figure 3a below and Figure 3b on the following page while completing Steps 10–15.

                                                                                               

                                                                                            Figure 3a: frmTrainersBilling Form in Form View

                                                                                            Figure 3a: frmTrainersBilling Form in Form View Figure 3a: frmTrainersBilling Form in Form View

                                                                                               

                                                                                            Figure 3b: frmTrainersBilling Form in Design View

                                                                                            Figure 3b: frmTrainersBilling Form in Design View Figure 3b: frmTrainersBilling Form in Design View

                                                                                               

                                                                                            1. Open the frmTrainersBillingform in Design View and complete the following steps:
                                                                                              1. Delete the LastNamelabel and change the caption for the FirstNamelabel to Trainer. ( Hint:Do not type the period.)
                                                                                              2. Select the Trainerand Specialtylabels, and then align their left edges.
                                                                                              3. Select the LastNameand Specialtytextbox controls, and then align their left edges.
                                                                                            2. Open the frmTrainersBillingform in Design View and complete the following steps:
                                                                                              1. Delete the LastNamelabel and change the caption for the FirstNamelabel to Trainer. ( Hint:Do not type the period.)
                                                                                              2. Select the Trainerand Specialtylabels, and then align their left edges.
                                                                                              3. Select the LastNameand Specialtytextbox controls, and then align their left edges.
                                                                                              Open the frmTrainersBillingform in Design View and complete the following steps: frmTrainersBilling
                                                                                              1. Delete the LastNamelabel and change the caption for the FirstNamelabel to Trainer. ( Hint:Do not type the period.)
                                                                                              2. Select the Trainerand Specialtylabels, and then align their left edges.
                                                                                              3. Select the LastNameand Specialtytextbox controls, and then align their left edges.
                                                                                            3. Delete the LastNamelabel and change the caption for the FirstNamelabel to Trainer. ( Hint:Do not type the period.)
                                                                                            4. LastName FirstName Trainer Hint:
                                                                                            5. Select the Trainerand Specialtylabels, and then align their left edges.
                                                                                            6. Trainer Specialty
                                                                                            7. Select the LastNameand Specialtytextbox controls, and then align their left edges.
                                                                                            8. LastName Specialty

                                                                                              Save, but do not close, the form. Save, but do not close, the form.

                                                                                              1. Add a title to the frmTrainersBillingForm Header section. Use Trainers and Billingfor the title instead of the default text.
                                                                                              2. Make sure the form’s Record Source property is set to tblTrainer, and then use the Combo Box Wizard to add a combo box in the Form Header section by completing the following steps:
                                                                                                1. Add a combo box to the approximate location shown in Figure 3b. ( Hint: Position the pointer at the top of the Form Header and at the 5.5"mark on the horizontal ruler when inserting this combo box.)
                                                                                                2. The combo box should find a record in the form based on a selected value.
                                                                                                3. Select the TrainerID, LastName, and FirstNamefields (in that order) for the combo box.
                                                                                                4. Do not hide the key column.
                                                                                                5. Resize the columns to Best Fit so all data is visible in the combo box.
                                                                                                6. Use the label Trainer IDfor the combo box.
                                                                                                7. If necessary, resize and reposition the combo box control to approximately match the location shown in Figure 3b.
                                                                                                8. Switch to Form View, and then use the Combo box to find the record for Trainer 778, Nick Collins.
                                                                                              3. Add a title to the frmTrainersBillingForm Header section. Use Trainers and Billingfor the title instead of the default text. Add a title to the frmTrainersBillingForm Header section. Use Trainers and Billingfor the title instead of the default text. frmTrainersBilling Trainers and Billing
                                                                                              4. Make sure the form’s Record Source property is set to tblTrainer, and then use the Combo Box Wizard to add a combo box in the Form Header section by completing the following steps:
                                                                                                1. Add a combo box to the approximate location shown in Figure 3b. ( Hint: Position the pointer at the top of the Form Header and at the 5.5"mark on the horizontal ruler when inserting this combo box.)
                                                                                                2. The combo box should find a record in the form based on a selected value.
                                                                                                3. Select the TrainerID, LastName, and FirstNamefields (in that order) for the combo box.
                                                                                                4. Do not hide the key column.
                                                                                                5. Resize the columns to Best Fit so all data is visible in the combo box.
                                                                                                6. Use the label Trainer IDfor the combo box.
                                                                                                7. If necessary, resize and reposition the combo box control to approximately match the location shown in Figure 3b.
                                                                                                8. Switch to Form View, and then use the Combo box to find the record for Trainer 778, Nick Collins.
                                                                                                Make sure the form’s Record Source property is set to tblTrainer, and then use the Combo Box Wizard to add a combo box in the Form Header section by completing the following steps: tblTrainer
                                                                                                1. Add a combo box to the approximate location shown in Figure 3b. ( Hint: Position the pointer at the top of the Form Header and at the 5.5"mark on the horizontal ruler when inserting this combo box.)
                                                                                                2. The combo box should find a record in the form based on a selected value.
                                                                                                3. Select the TrainerID, LastName, and FirstNamefields (in that order) for the combo box.
                                                                                                4. Do not hide the key column.
                                                                                                5. Resize the columns to Best Fit so all data is visible in the combo box.
                                                                                                6. Use the label Trainer IDfor the combo box.
                                                                                                7. If necessary, resize and reposition the combo box control to approximately match the location shown in Figure 3b.
                                                                                                8. Switch to Form View, and then use the Combo box to find the record for Trainer 778, Nick Collins.
                                                                                              5. Add a combo box to the approximate location shown in Figure 3b. ( Hint: Position the pointer at the top of the Form Header and at the 5.5"mark on the horizontal ruler when inserting this combo box.)
                                                                                              6. Hint 5.5"
                                                                                              7. The combo box should find a record in the form based on a selected value.
                                                                                              8. Select the TrainerID, LastName, and FirstNamefields (in that order) for the combo box.
                                                                                              9. TrainerID LastName FirstName
                                                                                              10. Do not hide the key column.
                                                                                              11. Resize the columns to Best Fit so all data is visible in the combo box.
                                                                                              12. Use the label Trainer IDfor the combo box.
                                                                                              13. Trainer ID
                                                                                              14. If necessary, resize and reposition the combo box control to approximately match the location shown in Figure 3b.
                                                                                              15. Switch to Form View, and then use the Combo box to find the record for Trainer 778, Nick Collins.
                                                                                              16. Save the form, and then close it. Save the form, and then close it.

                                                                                                1. Open the frmBillingSubformform in Design View. Add a calculated control to the frmBillingSubformForm Footer section by completing the following steps:
                                                                                                  1. Insert a text box in the Form Footer section at the approximate location shown in Figure 4 on the following page. ( Hint: Position the pointer just below the top of the Form Footer section on the vertical ruler and at approximately the 1"mark on the horizontal ruler.)
                                                                                                  2. Enter an expression in the text box control that displays the total number of invoices displayed in the form. ( Hint: The calculated control should contain the Count function and the BillingIDfield.)
                                                                                                  3. Set the Name property of the calculated control to txtCountBilling. ( Hint:Do not type the period.)
                                                                                                  4. Insert a second text box below the text box you just added) in the Form Footer section at the approximate location shown in Figure 4 on the following page. ( Hint: Position the pointer at approximately the 0.5"mark on the vertical ruler and at approximately the 1"mark on the horizontal ruler.)
                                                                                                  5. Enter an expression in the text box control that displays the total amount of the invoices displayed in the form. ( Hint: The calculated control should contain the SUM function and the Amountfield.)
                                                                                                  6. Set the Name property of the calculated control to txtSumAmount. ( Hint:Do not type the period.)
                                                                                                2. Open the frmBillingSubformform in Design View. Add a calculated control to the frmBillingSubformForm Footer section by completing the following steps:
                                                                                                  1. Insert a text box in the Form Footer section at the approximate location shown in Figure 4 on the following page. ( Hint: Position the pointer just below the top of the Form Footer section on the vertical ruler and at approximately the 1"mark on the horizontal ruler.)
                                                                                                  2. Enter an expression in the text box control that displays the total number of invoices displayed in the form. ( Hint: The calculated control should contain the Count function and the BillingIDfield.)
                                                                                                  3. Set the Name property of the calculated control to txtCountBilling. ( Hint:Do not type the period.)
                                                                                                  4. Insert a second text box below the text box you just added) in the Form Footer section at the approximate location shown in Figure 4 on the following page. ( Hint: Position the pointer at approximately the 0.5"mark on the vertical ruler and at approximately the 1"mark on the horizontal ruler.)
                                                                                                  5. Enter an expression in the text box control that displays the total amount of the invoices displayed in the form. ( Hint: The calculated control should contain the SUM function and the Amountfield.)
                                                                                                  6. Set the Name property of the calculated control to txtSumAmount. ( Hint:Do not type the period.)
                                                                                                  Open the frmBillingSubformform in Design View. Add a calculated control to the frmBillingSubformForm Footer section by completing the following steps: frmBillingSubform frmBillingSubform
                                                                                                  1. Insert a text box in the Form Footer section at the approximate location shown in Figure 4 on the following page. ( Hint: Position the pointer just below the top of the Form Footer section on the vertical ruler and at approximately the 1"mark on the horizontal ruler.)
                                                                                                  2. Enter an expression in the text box control that displays the total number of invoices displayed in the form. ( Hint: The calculated control should contain the Count function and the BillingIDfield.)
                                                                                                  3. Set the Name property of the calculated control to txtCountBilling. ( Hint:Do not type the period.)
                                                                                                  4. Insert a second text box below the text box you just added) in the Form Footer section at the approximate location shown in Figure 4 on the following page. ( Hint: Position the pointer at approximately the 0.5"mark on the vertical ruler and at approximately the 1"mark on the horizontal ruler.)
                                                                                                  5. Enter an expression in the text box control that displays the total amount of the invoices displayed in the form. ( Hint: The calculated control should contain the SUM function and the Amountfield.)
                                                                                                  6. Set the Name property of the calculated control to txtSumAmount. ( Hint:Do not type the period.)
                                                                                                3. Insert a text box in the Form Footer section at the approximate location shown in Figure 4 on the following page. ( Hint: Position the pointer just below the top of the Form Footer section on the vertical ruler and at approximately the 1"mark on the horizontal ruler.)
                                                                                                4. Hint 1"
                                                                                                5. Enter an expression in the text box control that displays the total number of invoices displayed in the form. ( Hint: The calculated control should contain the Count function and the BillingIDfield.)
                                                                                                6. Hint BillingID
                                                                                                7. Set the Name property of the calculated control to txtCountBilling. ( Hint:Do not type the period.)
                                                                                                8. txtCountBilling Hint:
                                                                                                9. Insert a second text box below the text box you just added) in the Form Footer section at the approximate location shown in Figure 4 on the following page. ( Hint: Position the pointer at approximately the 0.5"mark on the vertical ruler and at approximately the 1"mark on the horizontal ruler.)
                                                                                                10. Hint 0.5" 1"
                                                                                                11. Enter an expression in the text box control that displays the total amount of the invoices displayed in the form. ( Hint: The calculated control should contain the SUM function and the Amountfield.)
                                                                                                12. Hint Amount
                                                                                                13. Set the Name property of the calculated control to txtSumAmount. ( Hint:Do not type the period.)
                                                                                                14. txtSumAmount Hint:

                                                                                                  Save and close the frmBillingSubform. Save and close the frmBillingSubform. frmBillingSubform

                                                                                                     

                                                                                                  Figure 4: frmBillingSubform Form in Design View

                                                                                                  Figure 4: frmBillingSubform Form in Design View Figure 4: frmBillingSubform Form in Design View

                                                                                                     

                                                                                                  1. Open the frmTrainersBillingform in Design View. Add calculated controls to the Detail section of the form by following the directions below:
                                                                                                    1. Insert a text box control in the approximate location shown in Figure 3b on page 7.
                                                                                                    2. Change the Caption property of the label associated with the text box to Number of Invoices. ( Hint:Do not type the period.)
                                                                                                    3. Add an expression that displays the txtCountBillingcontrol value from the frmBillingSubformsubform.
                                                                                                    4. Add a second text box control (below the control you just added) in the approximate location shown in Figure 3b on page 7.
                                                                                                    5. Change the Caption property of the label associated with the second text box to Total Amount. ( Hint:Do not type the period.)
                                                                                                    6. Add an expression to the second text box that displays the txtSumAmountcontrol value from the frmBillingSubformsubform.
                                                                                                    7. Set the format for this calculated control to Currency.
                                                                                                    8. Resize and position the calculated controls as shown in Figure 3b on page 7.
                                                                                                    9. Set the Tab Stop property for both calculated controls to No.
                                                                                                  2. Open the frmTrainersBillingform in Design View. Add calculated controls to the Detail section of the form by following the directions below:
                                                                                                    1. Insert a text box control in the approximate location shown in Figure 3b on page 7.
                                                                                                    2. Change the Caption property of the label associated with the text box to Number of Invoices. ( Hint:Do not type the period.)
                                                                                                    3. Add an expression that displays the txtCountBillingcontrol value from the frmBillingSubformsubform.
                                                                                                    4. Add a second text box control (below the control you just added) in the approximate location shown in Figure 3b on page 7.
                                                                                                    5. Change the Caption property of the label associated with the second text box to Total Amount. ( Hint:Do not type the period.)
                                                                                                    6. Add an expression to the second text box that displays the txtSumAmountcontrol value from the frmBillingSubformsubform.
                                                                                                    7. Set the format for this calculated control to Currency.
                                                                                                    8. Resize and position the calculated controls as shown in Figure 3b on page 7.
                                                                                                    9. Set the Tab Stop property for both calculated controls to No.
                                                                                                    Open the frmTrainersBillingform in Design View. Add calculated controls to the Detail section of the form by following the directions below: frmTrainersBilling
                                                                                                    1. Insert a text box control in the approximate location shown in Figure 3b on page 7.
                                                                                                    2. Change the Caption property of the label associated with the text box to Number of Invoices. ( Hint:Do not type the period.)
                                                                                                    3. Add an expression that displays the txtCountBillingcontrol value from the frmBillingSubformsubform.
                                                                                                    4. Add a second text box control (below the control you just added) in the approximate location shown in Figure 3b on page 7.
                                                                                                    5. Change the Caption property of the label associated with the second text box to Total Amount. ( Hint:Do not type the period.)
                                                                                                    6. Add an expression to the second text box that displays the txtSumAmountcontrol value from the frmBillingSubformsubform.
                                                                                                    7. Set the format for this calculated control to Currency.
                                                                                                    8. Resize and position the calculated controls as shown in Figure 3b on page 7.
                                                                                                    9. Set the Tab Stop property for both calculated controls to No.
                                                                                                  3. Insert a text box control in the approximate location shown in Figure 3b on page 7.
                                                                                                  4. Change the Caption property of the label associated with the text box to Number of Invoices. ( Hint:Do not type the period.)
                                                                                                  5. Number of Invoices Hint:
                                                                                                  6. Add an expression that displays the txtCountBillingcontrol value from the frmBillingSubformsubform.
                                                                                                  7. txtCountBilling frmBillingSubform
                                                                                                  8. Add a second text box control (below the control you just added) in the approximate location shown in Figure 3b on page 7.
                                                                                                  9. Change the Caption property of the label associated with the second text box to Total Amount. ( Hint:Do not type the period.)
                                                                                                  10. Total Amount Hint:
                                                                                                  11. Add an expression to the second text box that displays the txtSumAmountcontrol value from the frmBillingSubformsubform.
                                                                                                  12. txtSumAmount frmBillingSubform
                                                                                                  13. Set the format for this calculated control to Currency.
                                                                                                  14. Currency
                                                                                                  15. Resize and position the calculated controls as shown in Figure 3b on page 7.
                                                                                                  16. Set the Tab Stop property for both calculated controls to No.
                                                                                                  17. No

                                                                                                    Save the form without closing it. Save the form without closing it.

                                                                                                    1. Draw a rectangle around the calculated controls and their labels, as shown in Figure 3b on page 7. Set the rectangle’s properties to match those listed below:
                                                                                                      1. Set the Border Width property to 4 pt.( Hint: The border width is the same as the Shape Outline’s Line Thickness.)
                                                                                                      2. Set the Special Effect property to Raised.
                                                                                                    2. Draw a rectangle around the calculated controls and their labels, as shown in Figure 3b on page 7. Set the rectangle’s properties to match those listed below:
                                                                                                      1. Set the Border Width property to 4 pt.( Hint: The border width is the same as the Shape Outline’s Line Thickness.)
                                                                                                      2. Set the Special Effect property to Raised.
                                                                                                      Draw a rectangle around the calculated controls and their labels, as shown in Figure 3b on page 7. Set the rectangle’s properties to match those listed below:
                                                                                                      1. Set the Border Width property to 4 pt.( Hint: The border width is the same as the Shape Outline’s Line Thickness.)
                                                                                                      2. Set the Special Effect property to Raised.
                                                                                                    3. Set the Border Width property to 4 pt.( Hint: The border width is the same as the Shape Outline’s Line Thickness.)
                                                                                                    4. 4 pt. Hint
                                                                                                    5. Set the Special Effect property to Raised.
                                                                                                    6. Raised

                                                                                                      Switch to Form View and test the form, and then save and close it. Switch to Form View and test the form, and then save 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. 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.

Answers

Related Questions

Engineering : Appendices...

AppendicesTHERBLIG ANALYSIS CHECKLISTThe choices are marked x for yes or no in the checklist.Reach and MoveYes1. Can either of these therbligs be eli...

Writing : Blue Sword By Robin Mckinley.edited...

Blue sword tale and the myth of Aerin the dragon slayerStudents nameInstitutional affiliationsOnce upon a time, there lived an orphaned girl nickname...

Writing : Policy Reflections...

Running head: POLICY REFLECTIONS1Policy ReflectionsNameInstitutional AffiliationPOLICY REFLECTIONS2Policy ReflectionsThe incident under consideration...

Science : Earth And Sun Answers...

exercise7Earth-Sun RelationshipsThe S n s ra s do no s rike he Ear h he same a in e er loca ion, nor do he s...

Marketing : Mar100 Event Analysis. Xx...

MAR100 Event AnalysisStudent name:MAR 100Article: Rizzo Lilian & FitzGerald Drew, Cord-Cutting Accelerated in 2019, Raising Pressureon Cable Provider...

Computer Science : Information Security Management...

Running Head: HEALTHCARE INFORMATION SECURITY PLANHealthcare Information Security PlanInstitutional AffiliationStudent NameDate1HEALTHCARE INFORMATIO...

If you didn't find the right answer

Ask Your Questions, We'll notify you once someone answers it