Create a Chart Report

Use Microsoft Access to create a chart that retrieves information from many records in your database, instead of creating a link from the chart to the current record on a single form or report. For example, you can create a chart that displays annual sales for all products, which you can then add to a form or report. The information in this kind of chart is updated all at once, whenever you view the form or run the report.

Create a new chart report   In the database window, on the Reports tab, click New. Select the table or query that contains the data to chart, double-click Chart Wizard, and then follow the instructions in the wizard.

To see the chart, preview the report   When the Chart Wizard is finished, click the Print Preview button to see the report.

Print Preview button

Add the chart report to your application   If you set up your database as an application, you can make the chart easy for users to access by adding it to your main switchboard. For more information, see Turn Your Inventory Database into an Application.

Next Steps