vb123.com.au
Data Mining Using Microsoft Access
Microsoft
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.
Published 1998-07
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
Our Tools and Resources
vb123 Professionals
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
Frontpage Conversions
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
Access 2003 Security
