Access 2016 Intermediate

Lesson 11 – Using Advanced Form Design

Access 2016

Steps

Practice Data

3. Select Design View .

The blank form appears in Design View .

Click

4. Select the table or query on which you want to base the report. The table or query name appears in the Choose the table or query where the object’s data comes from box. 5. Drag items onto the form as desired. The items appear on the form as appropriate.

Double-click Line Items in the Field List

Follow the instructions shown below the table to complete this step

Drag the Order Number , Product ID , and Quantity fields to the 2" mark on the horizontal ruler. Click in a blank area of the form to deselect the controls. Space the controls vertically on the form and size them to fit.

Close the form and save it as Customer Orders . Close ADVFORM.ACCDB .

Page 218

OFFICEPRO, Inc.