Access provides a good foundation for the database technique called data mining. Its
strengths are it interfaces to most database formats and industrial strength SQL queries
can feed the very flexible Microsoft Graph for data visualization.
Graf-FX has been configured in a front end software database rather than as an Access Add-In. To use your data, you will first need to link/attach to your database and then import any queries that are relevant for data mining. It is better to have a separate software database as data mining will produce a lot of additional query and form objects that would clutter up an existing access application.
Graf-FX is fully functional shareware and you will find it valuable to work through the introductory examples in the Graf-FX help file before experimenting with the Northwind database.
download the article here or download Graf-FX shareware here
Here are some pictures from the article.
Figure2 Graf-FX launchpad form undertaking drilldowns on the INVOICES query
Figure 3 Drilldown query shown as a Microsoft graph object
Figure 5A Crosstab/3D drilldown shown as a 3D graph .
Figure 6 How you can drilldown on the Invoices query in 3D
Get Good Help Here
If you need help with a database or Office programming, our Professionals could be the answer because we have worked on many similar solutions
We have converted vb123.com to Expression Web, contact us if we can help you move to the latest Microsoft web tool.
About The Editor ~ Contact Us
Garry Robinson writes for a number of popular computer magazines, is now a book author and has worked on 100+ Access databases. He is based in Sydney, Australia