Access 2016 Advanced

Lesson 5 – Using Charts

Access 2016

If necessary, display All Access Objects in the Navigation Pane.

Steps

Practice Data

1. On the Create tab in the Forms group select the Form Design button. A new blank form opens in Design view.

Click

2. On the Design tab in the Controls

Click

group select the Insert Chart button . The Insert Chart button is selected.

3. Click the blank form.

Click the blank form

The Chart Wizard opens.

4. Select the table or query on which you want to base the chart. The table or query name appears in the Which table or query would you like to use to create your chart? box.

Click Table: Packing Slip

5. Select Next .

Click

The next page of the Chart Wizard appears.

6. Add the field containing the data you want to display in the chart from the Available Fields list box. The field name appears in the Fields for Chart list box.

Double-click Ord Tot

7. Add additional fields from the

Double-click Sales Rep

Available Fields list box as desired. The field names appear in the Fields for Chart list box.

8. Select Next .

Click

The next page of the Chart Wizard appears.

9. Select the desired chart type. The chart type is selected, and a

Click the Pie Chart (last row, first column)

description of the chart type appears in the right panel of the Chart Wizard.

Page 50

OFFICEPRO, Inc.

Made with FlippingBook - Online magazine maker