The first program I ever wrote in Access was a database analyzer. When I started using Access in 1993, I had already been developing database applications for 10 years. I was surprised there was not a built-in way to generate a Data Dictionary so I wrote a tool to do it and more. The Analyzer is menu driven, easy-to-use, and free.
Over the years, the Analyzer has been expanded by me and many others.
The 5 basic Analyzer reports are:
- Table Summary
- Deep Analysis (Data Dictionary + Value Analysis)
- Field List
- Table Indexes
- Relationships
Additional reports include:
- Lookup Fields
- Database Information
- Linked Databases
- Table Detail
- Field Statistics
- Object Summary
- Form Record Sources
- Form Control RowSources
- Font Styles
- LOOK in Form Control or Row Source (prompts for a parameter).
the Analyzer source code is posted here:
http://analyzer.codeplex.com/
Over the years, the Analyzer has been expanded by me and many others.
The 5 basic Analyzer reports are:
- Table Summary
- Deep Analysis (Data Dictionary + Value Analysis)
- Field List
- Table Indexes
- Relationships
Additional reports include:
- Lookup Fields
- Database Information
- Linked Databases
- Table Detail
- Field Statistics
- Object Summary
- Form Record Sources
- Form Control RowSources
- Font Styles
- LOOK in Form Control or Row Source (prompts for a parameter).
the Analyzer source code is posted here:
http://analyzer.codeplex.com/
here is a 5-minute demo video (that just touches the tip of the iceberg):
http://www.youtube.com/watch?v=st3dcpVjwl0
http://www.youtube.com/watch?v=st3dcpVjwl0
If you wish to be part of the development team, that would be great! The
Analyzer project needs
- expert help to code additional tests, write an interface to make
it easier to incorporate new and changed objects from others, and more
- interested people of all levels to create reports and test code
- feedback from users
- ideas from all ~
To be added:
- Join CodePlex
- Email strive4peace2010 at yahoo.com with
-- CodePlex username
-- Name
-- Reason for wanting to be on the team
-- Experience with Access*
-- Location
* all with a love for Access and desire to share freely are welcome to contribute no matter what your experience.
I hope you find the Analyzer helpful. Thank you ~
Warm Regards,
Crystal
Microsoft MVP, Access
"If I have seen further it is by standing on the shoulders of giants."
-- Isaac Newton
Through sharing, we will all get better
~ have an awesome day ~
Analyzer project needs
- expert help to code additional tests, write an interface to make
it easier to incorporate new and changed objects from others, and more
- interested people of all levels to create reports and test code
- feedback from users
- ideas from all ~
To be added:
- Join CodePlex
- Email strive4peace2010 at yahoo.com with
-- CodePlex username
-- Name
-- Reason for wanting to be on the team
-- Experience with Access*
-- Location
* all with a love for Access and desire to share freely are welcome to contribute no matter what your experience.
I hope you find the Analyzer helpful. Thank you ~
Warm Regards,
Crystal
Microsoft MVP, Access
"If I have seen further it is by standing on the shoulders of giants."
-- Isaac Newton
Through sharing, we will all get better
~ have an awesome day ~
__._,_.___
Posted by: Crystal <strive4peace2008@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar