Access 2016 Intermediate

Lesson 11 – Using Advanced Form Design

Access 2016

Steps

Practice Data

9. Double-click to select the default text. The text is selected. 10. Type the desired logic control name. The name appears in the label box.

Double-click Check xx ( xx is a number)

Type Send a Catalog?

11. Press [Enter] .

Press [Enter]

The text in the label box is entered onto the form.

Click in a blank area of the form to deselect the logic control.

Switch to Form view and scroll through the records. Since the logic control (the check box) is now bound to the Catalog field, it reflects the value of the Catalog field for each record by appearing checked or unchecked.

S ETTING THE T AB O RDER A UTOMATICALLY



Discussion

The tab order determines the order in which form fields and controls are selected when you press the [Tab] key during data entry. The default tab order is the order in which the fields or controls were added to the form. If you have added, rearranged, or deleted fields or controls, the tab order may not be suitable for data entry. You can choose to have Access automatically rearrange the tab order to reflect the order of the fields on the form. The fields are then accessed from left to right across each row.



Procedures

1. Open the desired form in Design view. 2. Select the Design tab on the Ribbon .

3. Select the Tab Order button

in the Tools group.

4. Select the Auto Order button

.

5. Select

.

Page 212

OFFICEPRO, Inc.