Access 2016 Advanced

Lesson 1 - Using Subforms/Subreports

Access 2016

Steps

Practice Data

1. Double-click the subform control you want to edit. The subform control is selected and the property sheet for the control opens. 2. Double-click the subform control text to select it. The text is selected. 3. Make the desired editing changes. The editing changes are made. 4. Continue making editing changes as desired. The editing changes are made.

Scroll as necessary and double-click the subform Qty unbound control (the Qty label box in the subform) Double-click the text Qty in the label box

Type Quantity

Press [Enter]

Close the property sheet, then save and close the form.

D ISPLAYING A S UBFORM IN D ATASHEET V IEW



Discussion

Display a subform in Datasheet view. This option allows you to view many subform records at once, rather than viewing them one at a time in Form view. Since the benefit of using subforms is to display the many side of a one-to-many relationship, Datasheet view is generally preferred.

Page 8

OFFICEPRO, Inc.