Learn how to create Graph Charts in MS Access by adhering to these crucial points.
MS Access provides users with a number of options for storing, presenting and viewing information in the form of numbers and text. But this is not where its excellence ends, because there is a lot more it offers. In MS Access you can represent data equally beautifully in the forms of graphs and images, by making use of charts and graphs in MS Access.
Creating charts in MS Access is definitely not a challenge if you can understand the very basic rules to follow. When creating a chart in Access, ensure that you are making use of dots and lines to represent any time gap that has been occurring. These dots and lines should be used in relation to figures they are supposed to represent. This is to imply that you should avoid using numbers and text to represent a time span already mentioned in number and texts.
To create graphs in MS Access, you will first have to understand how to create a form in Access that can be used for preparing graphs in the application. To help you get more clarity on creating graphs and charts in MS Access, we are listing key tips that you need to keep in mind.
Key points to Remember
- The first thing that you need to be clear with is what suits you best, a chart or a graph.
- For figures that keep on changing regularly, let’s say the daily temperature, you can opt for line or bar chart. Much like manually creating a graph.
- For determining the scale of your chart, consider the maximum and the minimum values available with you. It is advisable to start the scale of the chart with 0, and then proceed in X Axis and Y Axis in equal intervals.
- The Microsoft Graph Chart Object allows you to do on computer, what we have been doing manually.
- When creating charts, you should make a selection between pie charts, line charts or bar charts. This selection should be based on the kind of data you are working on.
- If your data is the one that keeps on changing at regular intervals, then you must have a data source object that can update the chart whenever the data changes. This data source can either be a Table or a Query. This will prevent you from manually making the changes in the charts.
If you are opting to make use of graph charts in MS Access, you need to understand that it will not be as easy as it is in Excel. But it is no rocket science either. There is a certain procedure you need to follow, but before you proceed towards following that procedure, there are certain key points that you need to remember. This article is an attempt to brief you with those points, so that the required procedure can be completed successfully.
All data stored in your Access database can get compromised in the event of an Access crash. So it is always better to keep a recovery tool handy to recover mdb database.
Vivian Stevens is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including sql fix and excel recovery software products. For more information visit www.datanumen.com