|
vb123.com |
|
|
Home Contact Us Order Software Search vb123 The Magazine that Access Developers loved to read and write for is back Article Index Here or Purchase Here
RSS &
Newsletter
Get Good Help
Like FMS Products? The Toolbox About The Editor 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
or try our new site built with
SharePoint Designer |
The
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