Access 2016 Intermediate

Lesson 11 – Using Advanced Form Design

Access 2016

Steps

Practice Data

10. Continue to type values as desired. The values appear in the rows.

Enter the following values under Col1 in the wizard, pressing [Tab] after you type each value: UPS , DHL , Emery , FedEx .

11. Select Next .

Click

The next page of the List Box Wizard appears.

12. Select the desired storage option for the field. The desired storage option is selected. 13. 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

14. Select the desired field name, if applicable.

Click Shipping Method

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

15. Select Next .

Click

The next page of the List Box Wizard appears with the insertion point in the What label would you like for your list box? box.

16. Type a label for the list box.

Type Shipping Method

The text appears in the What label would you like for your list box? box.

17. Select Finish .

Click

The List Box Wizard closes, and the list box appears on the form.

Reduce the height of the Shipping Method list box by dragging the bottom border up to the 5cm mark on the vertical ruler. Line up the Shipping Method label with the Shipping Cost label above it. If necessary, move the Shipping Method list box to left align with the Shipping Cost text box above it. Click in a blank area of the form to deselect the list box.

Page 204

OFFICEPRO, Inc.