Exercices on queries
Texte en français
Word 2010 Tutorials
Join our Newsletter
Share this page
Before we begin
Create a form form chart with the assistant
Changing a form
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.
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 change 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.
Why a chart?
the main menu, select the tab Forms .
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.
this exercise, select the Employees table.
From the list of the available fields, select fields office and Commission.
It's enough of:
the field of the left column and to press the button .
When the wanted fields were selected, press the Next button.
Access a list of types of chart offers you to represent your data.
this exercise, select the type of chart sector.
Double-click on the button Sum Decommission.
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.
that the synthesis is on the option Sum .
It's always possible to you to change fields or synthesis by returning to the Design view.
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.
the name of the chart, enter the name: Total of the commissions
of the company.
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.
To be able to change the chart form, you must enter Design view.
You can change the dimension of the form to answer your needs.
To modify the presentation.
the cursor over 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 change it.
|You like what you read?
Share it with your friends.