Access offers you several types of forms. This Web page demonstrates how to create you and to use a chart form. For more data about forms generally, watch to go to the page on forms.
To realize this Web page, it's better use the data of the database demoacc2.mdb or demoa2k2.mdb (for Access97 or Access 2000 respectively). You can take these databases from the page of the demonstration files of this site.
Introduction
Access allows you to generate charts from the mass of data that is accumulated. This page demonstrates how to generate you a chart form and to modify it. The exercise of this page will demonstrate the sum the commissions of the company by office location. These data you will find Commission and office of the Employees table.
To
simplify the analysis of a mass of data. To
analyse quickly the trends of the series of data. To
be able to compare the data. To
analyse proportions.
Creating a chart form with the assistant
From
the main menu, select the tab Forms. Press the New button.
From
the list of the available options, select the option Attending chart.
The "source" of a form or a report can be a table or a query. The query to
use records that answer the wanted criteria or resulting from several connected
tables. It's a point to consider during the creation of a chart.
For
this exercise, select the Employees table. Press the OK button.
From the list of the available fields, select fields office and Commission.
It's enough of:
Choose
the field of the left column and to press the button . OR Make(do)
a double-click on the wished field.
When
the wanted fields were selected, press the Next button.
Access a list of types of chart offers you to represent your data.
For
this exercise, select the type of chart sector. Press the Next button.
Double-click on the button SommeDecommission.
The chart form allows you to generate a synthesis on several elements of the
data. Here is a short description of each of the possible options.
Nobody
Show the values of the selected field.
Sum
Show the sum a selected field.
Average
Show the average of a selected field.
Min
Show the smallest value of a selected field.
Max
Show the biggest value of a selected field.
Count
Show the number of records of a selected field.
Assure
that the synthesis is on the option the Somme. Press the OK button.
It's always possible to you to change fields or synthesis by returning to
the Design mode.
For
this exercise, press the Next button.
It remains still to give a name to the chart as well as to see some other possibilities.
For
the name of the chart, enter the name: Total of the commissions
of the company. Press
the Finish button.
Access will take a moment to generate the chart according to the
options that you chose.
Here is the chart generated from the data of the Employees table.
Modification of the form
To be able to modify the chart form, it's necessary to enter Design mode.
Press
the button. OR From
the Edit menu, select the Creation mode option.
You can change the dimension of the form to answer your needs.
To modify the presentation.
Place
the cursor over the chart. Double-click on the chart.
Access uses the generator of chart of Windows to represent the data. watch
to read the page on the insertion of a chart to
learn how to modify it.
Note:
You can not modify the data from the table of data of the chart module.
To
simplify the analysis of a mass of data.
From
the main menu, select the tab Forms 
.
.
button.