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.
Made with FlippingBook - Online magazine maker