Access 2016 Advanced

Lesson 1 - Using Subforms/Subreports

Access 2016

Steps

Practice Data

7. Select the desired link option.

Click

Choose from a

The desired link option is selected.

list. , if necessary

8. Select the desired link for the subform or subreport from the list box. The desired link is selected.

Click Show Order Items for each record in Orders using Order Number , if necessary

9. Select Next .

Click

The next page of the SubForm or SubReport Wizard appears with the insertion point in the What name would you like for your subform or subreport? box.

10. Type a name for the subform or subreport.

Type Order Items of Company

The name appears in the What name would you like for your subform or subreport? box.

11. Select Finish .

Click

The SubForm or SubReport Wizard closes and the subform or subreport appears in the form or report.

Size the subform control (from the bottom edge and right corner) so that it is approximately 1 1/2'' high and 3 1/2'' wide, if necessary. Switch to Form view to see the subform. Switch back to Design view and deselect the subform control, if necessary.

Close and save the form.

Practice the Concept: Create a subreport in the Sales Data 1 report at the 2.5” mark on the horizontal ruler and the 1” mark on the vertical ruler. Use the Qtr 2 Sales report for the subreport and select the first Show Customer Sales Query for each record in Customer Sales Query option for the link. Accept the default name for the subreport and view the report in print preview.

Close and save the report.

Page 6

OFFICEPRO, Inc.