Charts add a new dimension when you use them on your forms or reports.
Although they may seem kind of overwhelming at first, they are fairly straightforward when you use the Chart Wizard for a new form or the Chart
option on the Insert menu for an existing form
. You can see an example of what a chart can look like in the figure display below:
The chart displayed here is a simple pie chart, but there are 20 styles of charts to choose from. Once you have created a chart,
you can modify various properties such as the way data values are displayed using Microsoft Chart directly from Access.
One of the things to keep in mind when creating forms with charts is that you will want to base them on queries rather than on tables directly.
The reason for using queries versus tables that you can then set up the fields in the query to be a much closer match to the data that you want to display in the chart.
For example, the query that the chart in the figure below is based on is called qryHoursByProjects.
Notice that only the fields necessary for display in the chart itself are included.
To see the steps for creating a new chart on a form using the wizard, you will use a modified version of the qryHoursByProjects query called qryHoursByProjectsForClientNo.
This query can be seen here:
The only modification is the addition of the criteria requesting the client number (ClientNo). While in the Forms list of the Database window, choose New.
In the next lesson, you will learn what ActiveX controls are and where you can use them.