Access 2016 Intermediate

Lesson 11 – Using Advanced Form Design

Access 2016

Steps

Practice Data

5. Select Next .

Click

The next page of the Combo Box Wizard appears.

6. Select the desired view option.

Click

Tables .

The desired view option is selected.

7. Select the table or query containing the values for the combo box in the Which table or query should provide the values for your combo box? list box. The table or query name is selected.

Click Table: Reps

8. Select Next .

Click

The next page of the Combo Box Wizard appears.

9. Select the field containing the values from the Available Fields list box. The field name appears in the Selected Fields list box.

Double-click INITIALS

10. Select Next .

Click

The next page of the Combo Box Wizard appears.

11. Select Next .

Click

The next page of the Combo Box Wizard appears.

12. Select Next .

Click

The next page of the Combo Box Wizard appears.

13. Select the desired storage option for the field. The desired storage option is selected. 14. Select the Store that value in this field list, if applicable. A list of fields appears.

Click

Store that value

in this field

Click Store that value in this field

15. Select the desired field name, if applicable.

Click Sales Rep

The field name appears in the Store that value in this field box.

Page 198

OFFICEPRO, Inc.