Data Mining Using MS Access

vb123.com

Garry Robinson's Popular MS Access, Office and VB Resource Site

Home Contact Us
Order our Software

Smart Access
The Magazine that Access Developers loved to read and write for is back Read More

RSS & Newsletter
Join our XML/RSS Newsfeed or sign up for our informative newsletter on Office Automation, Access and VB topics
Read More

Get Good Help
If you need help with a database, our Professionals could be the answer
Read More

Is Your Database Corrupt ?
If you have a corrupt database, Try our Access Recovery service

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

Access >>> SQL
Upsize to SQL Server 2005 or 2008, easily repeated conversions, highly accurate SQL query
translation and web form conversion.
Read More

The Toolbox
Libraries of software that we regularly import into our projects. This is a newer version of the Toolshed More..

SharePoint
For our company file sharing and task management, we use
SharePointHosting

Datamining/Graphs
Explore your data with this versatile graphing and data mining shareware tool. Read More

DryToast
Backup and query your BaseCampŽ projects
Read More

Garry's Blog
Find out a few other things that Garry has been writing about Microsoft Access. Read more

Like FMS Products?
Purchase them from us and get a free Workbench or Toolbox More

Smart Access is Back
We have recently purchased exclusive rights to the Smart Access magazine

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
Contact Us ...

or try our new site built with SharePoint Designer
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

Links >>> Home | Search | Workbench | Orders | Newsletter | Access Security | Access professionals