|
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
SharePoint DryToast Garry's Blog Like FMS Products? Smart Access is Back
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 |
Is Your Database Corrupt ?
The Toolbox
GRAF+FX -->
Visual Database Exploring Samples
Graf+FX® shows you a number different ways that you can start building your own data mining / fast graphing solutions using Microsoft Access. This software is provided as part of The Toolshed.
Click here to read about exploring data in Access 2007
Method 1: A Microsoft Access 97 Library of routines that allows you to add data mining functionality to your own Access Database. With an imported and fully documented drilldown template form and the Graf+FX library, you can explore your databases with graphs and queries using a technique called Data Mining. You can also a quickly generate/prototype Access Graphs without running the graph wizards. And when you master these techniques, you can then fine tune the interface or even build your own using the power of the Graf+FX functions, subroutines and the drilldown class object. Comes with full source code.
See a demo of the form that you import
Methods
2 & 3: A Microsoft Access database with
full source code that will allow you to start fast graphing any table/query and commence
drilldowns on the data.
Click to see one form
Download
The Library Help File (the
best way to understand whats on offer)
Method 1: The Library Method
You add the data mining library to your database in 3 steps
 | You import the (3) template forms from the userObjects database into your database |
| You open a new code module in your database and establish a reference link to the graf+FX.mdb. Alternatively, just import the library modules into your own database. |
| You open the graf+FX form that you have imported into you database and verify that the libraries work. This will give you drilldown capabilities to 5 levels. |
Graf+FX also allows you to explore other Access
databases using external queries.
A more versatile option is provided to allow you to explore other Access databases through the exploring databases option at the top of the screen. (show below). This allows you to use a hidden feature of Access SQL syntax. Selecting an external database rather than using internal queries, tables and linked tables allows your users Access to other data sources without having to setup new linked tables or import data
into your database.
Method 2: Your Own Datamining Interface(s)
Unzip the database. Link to your tables. Click on the refresh systems tables button and start graphing !!! You do not need any additional licences once you start using this program. There is also a similar interface that shows you how to use table and query filters in your drilldown queries and graphs.
Features The Graf97+FX Library Will Add To Your Database Include
| Fast Access graphs from any of MS Graphs objects or use our special designs |
| Drilldown on any table or query |
| Drilldowns are viewed using group by queries |
| Full source code so that you can take the software where you want to go |
| Use any of the graf formats provided or create your own layouts |
| View the SQL or save the query from any of the drilldowns |
| Save your grafs as forms for later reuse in your own application. |
| The template form is fully documented so that you will understand the calls to library. |
| The template form links to the library help file so that you can easily reference a call for each form event. |
| Fully Callable Procedures Library (Functions and Subroutines) |
| Plus you will devise your own ways to use the drilldown class module in your
application far better than we ever could.
Smart Graphs You can take control of your Microsoft Charts and make them far more feature packed using Visual Basic. Click here to see the Smart Graphs that you can manipulate in Graf+FX. |
Installation
First you must have Microsoft Access 97 or
Access 2000/XP
Secondly you must install Microsoft Graph when installing Access 97/2000 or Microsoft Office
97/2000.
Then unzip the file graf*+FX.mdb library database into any directory that you like. You then need to follow the instructions in the help
file graf+FX_Start.hlp
before commencing to import the objects into
your own database.
Before thinking that this is the answer to all your data mining needs, you should be an Access programmer. If you are not, then you may be better of purchasing Graf-FX as this has been setup for instant use on your data. Even though Graf-FX is also available with full source code in the programmers pack, it is more complicated by virtue of its greater feature list.
Licensing Information + Ordering
Graf+FX comes complete with full source code. You
may use the software as a library and documentation is provided to describe how
you would do this. Alternatively, you simple import the modules and class
modules into your database and use them in your Access application.
The software does not have any security restrictions.
Click here for the
download file if you own "The Toolshed" Else ???
Click Here to find out how to order The Toolshed.
to go the next page
in this loop