|
vb123.com |
|
|
Home Contact Us Order our Software RSS &
Newsletter
Get Good Help
The
Workbench
Find out who has your database open, start the
correct version of Access, easy compacting and backups, change startup
options, mde compile, shutdown database
Read and
Download Garry's Blog
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 Expression Web |
Is Your Database Corrupt ?
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