Access 2016 Advanced

Lesson 1 - Using Subforms/Subreports

Access 2016

E XERCISE

U SING S UBFORMS /S UBREPORTS



Task

Use a subform/subreport.

1. Open SUBFORMX.ACCDB . 2. Open the Invoice Form form in Design view. 3. Use the SubForm Wizard to create a subform in the bottom center of the form. 4. Insert the existing Project Form form as a subform. 5. Select the appropriate option from the list box to link the main form and subform by the Project ID field. Name the subform Project Info . 6. Delete the subform’s label box. 7. Size and position the subform control so that all the fields appear, if necessary. 8. Switch to Form view to see the subform. 9. Select the Project ID field in the subform and switch to Datasheet view. 10. Close and save the form. 11. Open the Payment Form form in Design view. 12. Create a total for the subform called Early bird discount in the Payment Form form at the 5” mark on the horizontal ruler below the subform. Use 15% as the discount. 13. View the form in Form view to see the subform total. 14. Close the form without saving the changes. 15. Close the database file.

Page 14

OFFICEPRO, Inc.