Access 2016 Advanced

Access 2016

Lesson 1 - Using Subforms/Subreports

12. Type a name for the subform or subreport.

13. Select

.



Step-by-Step

From the Student Data directory, open SUBFORM.ACCDB . Create a subform/subreport.

Open the Order Entry form in Design view.

If necessary, display the ruler, and select the Design tab on the Ribbon .

Steps

Practice Data

1. Click the Use Control Wizards button in the Controls group, if necessary. The Control Wizards are enabled. 2. Click the Subform/Subreport tool in the Controls group. The mouse pointer changes into a plus sign (+) with a form attached when positioned over the form. 3. Click in the form or report where you want to place the top left corner of the subform or subreport. The default control for the subform or subreport appears and the SubForm or SubReport Wizard opens. 4. Select the desired option for the subform or subreport source. The desired option is selected. 5. Select the desired form or report you want to insert. The desired form or report is selected.

Click

, if

necessary

Click

Click in the form at the 1.5'' mark on the vertical ruler, under the Shipping Cost label box

Click form

Use an existing

Scroll as necessary and click Order Items

6. Select Next .

Click

The next page of the SubForm or SubReport Wizard appears.

OFFICEPRO, Inc.

Page 5