DataMoxie for Microsoft Access 97, 2000, 2002

- Version 1.0c

DataMoxie™ is a data discovery and productivity Add-In
designed for users of Microsoft® Access Versions 97,
2000, and 2002 (XP®). This tool compiles a list of
data elements derived from the field collections of
tables, indices, queries and relationships and presents
the results in an alphabetical list identifying where a
particular data element is used. Its features include:
Table, Index, Query, and Relationship lists showing
where the data element is used within these structures
(including data type and length). Property windows
providing details about fields in Tables, Indexes,
Queries or Relationships as well as details for objects
referencing the data element (Forms, Reports, and
Modules). Ability to search report and form controls
for references to a data element. Ability to search
class and standard modules for references to a data
element and to cache these results for each line of
code. These results are identified by line number and
by procedure name and type within a module and can be
viewed interactively or written to a log file.
Search of query SQL statements for a data element (for
those queries that don't contain output fields or field
definitions). Annotation capabilities for table
field definitions as well as database tables, queries,
forms, reports, and modules. These can be viewed in the
properties windows or sent to the log file. Log
output options to selectively write DataMoxie™ results
to a text file for documentation (such as a data
dictionary) or change-estimate functions and more ...