We can insert a “Chart” in an existing form or “Report”. In this example I have a “Products” form, which I opened in “Design View”. If you need to do this, the first thing you do is , leave a little place for your “Chart” in the “Details” section.
Then click the “Insert Chart” (1) button in the “Design” (2) tab under the “Controls” section in the “Ribbon”.
Click and drag it into the form, at the place where you’d like to insert (3).
This opens the “Chart Wizard”. In the first wizard window, choose a table or query that you want to make a “Chart” for. I choose the “Orders” table. This is also the table where I have entered all the goods sold.
Click the “Next” button.
In the second window of the wizard, you define the data you want to use in your “Chart”. In this case it is the “Date” field and the “Quantity” field. The purpose of my “Chart” is, that I get a clear picture of the number of items sold for each article .
In the third window, you determine the type of “Chart”. When you select a “Chart” on the left of the window, you get a description of this on the right side of the window.
I choose “Column Chart” and click the “Next” button
In the fourth window, we determine how we want to classify the data in our “Chart”. “Access” will give you a suggestion, but you can always change it by dragging the field buttons and by placing them in the different compartments of the sample “Chart”. You can also change the value of the fields by double-clicking these fields in the chart.
For example, if you double-click on the “Date of Month” in the “Chart”, the “Group” window appears, where you have the choice to group the data by year, quarter, month, etc. So, if you double-click on the “Sum of Amount” in the “Chart” for example, the “Summarize” window appears, where you have the choice to summarize the data according to Sum, Average, Minimum etc.
Click the “Next” button to proceed
In the fifth window, select the fields in the form in such a way that the fields in the “Chart” can be linked with each other.
In other words, when you navigate between the various articles, the “Chart” should also be adjusted. “Access” will give you a suggestion here also.
Click the “Next” button
In the last window of the wizard, we enter a title, which is shown above the “Chart”. Make a choice whether or not you want to display a legend in your “Chart”.
Click the “Finish” button.
Save your “Report”, and go to “Report View” to see the result.
We can click the navigation buttons (1) to view the different “Charts” per items sold.
You've completed Lesson 62 START NEXT LESSON