Selasa, 24 Juni 2014

Re: [MS_AccessPros] Analyzer for Microsoft Access project on CodePlex

 

Incredible tool. I should have downloaded it sooner. It worked great when I had to create a data dictionary. Thanks for the heads up.
 

With Warm Regards,
 
Arthur D. Lorenzini
IT System Manager
Cheyenne River Housing Authority
Wk.(605)964-4265  Ext. 130
Fax (605)964-1070
"Only those who will risk going too far can possibly find out how far one can go."






On Monday, June 23, 2014 4:27 PM, "Crystal strive4peace2008@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:


 
 
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/


here is a 5-minute demo video (that just touches the tip of the iceberg):
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 ~




__._,_.___

Posted by: Art Lorenzini <dbalorenzini@yahoo.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)

.

__,_._,___

Tidak ada komentar:

Posting Komentar