Database flowchart??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know of anything out there or within Access that will allow you
to see how all the tables and queries are associated. In other words...I
would like to see which query/queries made a table...etc. Just something
that one could quickly map out how the database is flowing...that would be
very nice!
Thanks in advance.
 
look into "relationships" That will be a good starting point

I think that is what you are looking for
 
[Right-Click] on the Table, Query, or Form, and choose "Dependencies." The
relationships chart shows you how you have related Tables (and sometimes
queries) together, Dependencies show you how you have constructed Queries and
Forms. Probably need to look at both to get an overall picture of what is
connected to what. Can be useful for troubleshooting.
 
There is a pretty good documentation tool available from FMS called Total
Access Analyzer. Download a demo from www.fmsinc.com
While you're visiting the site, take a look at their white papers section.
 
Back
Top