Access 2016 Intermediate

Lesson 8 – Using Controls and Layouts

Access 2016

name from the Name field in an address table. The bound text box control gets the values from the Name field because you have connected or bound it to that field.

Label controls are unbound controls. They display information that is not stored in a table. Unbound controls can be text, images, lines, or rectangles drawn on the design. Unbound controls are often paired with bound controls as labels. Unbound controls are also used to enhance a form or report, or to provide more information, such as instructions for entering data. Text box and label controls are automatically added to a form created using the Form Wizard. However, you can use the toolbox in Design view to add other controls to a form or report. These controls include list boxes, combo boxes, drop-down list boxes, command buttons, check boxes, option buttons, option groups, toggle buttons, and tabs.

NOTE Calculated controls derive their information using an expression to manipulate the table data on which a form is based. For example, you can display an order total on a form that is calculated by multiplying the Unit Price and the Quantity fields in an Orders table. Calculated controls are unbound since the result of the calculation is not stored in a table.

U SING T ABLE L AYOUTS



Discussion

When editing forms or reports in Access, you can group your form controls in one layout, and manipulate them as a unit. Table layouts align your controls and their respective labels vertically and horizontally, to give your form a uniform appearance.

There are two types of control layouts: stacked and tabular.

NOTE You can use multiple layouts on a form or report.

OFFICEPRO, Inc.

Page 144