Access 2016 Advanced

Lesson 5 – Using Charts

Access 2016

E XERCISE

U SING C HARTS



Task

Use a chart.

1. Open CHART1X.ACCDB . 2. Display All Access Objects in the Navigation Pane.

3. Using the Chart Wizard, select the Sales table, and include the Cost and Sales Rep fields to create a Bar Chart (second row, first column). Accept the default layout and title for the chart and select not to display a legend. Select to open the report with the chart displayed. 4. Switch to Design view. View the Sales chart in the Microsoft Graph window. ( Hint: When you display the chart in the Microsoft Graph window, the data that appears is sample data. It is not representative of the actual data that will appear in the final chart.) 5. Change the chart type to Column . Select the Clustered Column sub-type, if necessary. 6. Change the chart title to Sales Reps . 7. Apply the Bold Italic style and a 12 -point font size to the chart title. 8. Add data labels that show the actual values represented by the chart. 9. Size and position the chart as necessary to view the values.

10. Close Microsoft Graph and preview the report. 11. Close and save the report as Sales Report . 12. Close the database file.

Page 64

OFFICEPRO, Inc.