vb123.com.au
Using Access
Filters to Graph and Explore Your Databases
This
article describes how you can explore data in Access using a simple data-mining technique,
shows you the VBA code that will allow you to perform this analysis, and summarizes why
you might want to use Access for exploring your valuable databases. The
interface is shown below.
This article was written for and published in
"Microsoft Office & VBA Developer" by Garry Robinson.
Your Sample Database Is Called "grafFilters97.zip"
Sample database is suited to all versions of Access
If you do NOT own "The Toolbox", Click
here to find out how to purchase The Toolbox.
Other Related Pages
See an online demo of Graf-FX
Read
an article on Graf-FX
Consolidation queries
Controlling
Microsoft Graph from Access
The
next article in this loop
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
Using Access
Filters to Graph and Explore Your Databases
This article describes how you can explore data in Access using a simple data-mining technique, shows you the VBA code that will allow you to perform this analysis, and summarizes why you might want to use Access for exploring your valuable databases. The interface is shown below.
This article was written for and published in "Microsoft Office & VBA Developer" by Garry Robinson.
Your Sample Database Is Called "grafFilters97.zip"
Sample database is suited to all versions of Access
If you do NOT own "The Toolbox", Click
here to find out how to purchase The Toolbox.
Other Related Pages
See an online demo of Graf-FX
Read
an article on Graf-FX
Consolidation queries
Controlling
Microsoft Graph from Access
The
next article in this loop
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
