I created a fairly complex Access database for a client, involving several layers of queries and many tables. I am trying to document the function of all these queries and I was wondering whether there exists some kind of standard flow chart type methodology of doing so, showing e.g. Query A is a select query on Query B and Table 1 joined on Fields a, b, c, and Query B itself is a crosstab query on Table 2, etc.
Thanks
0 comments
—
Ask HN: Standard documentation for SQL queries? · HackerTrans
I created a fairly complex Access database for a client, involving several layers of queries and many tables. I am trying to document the function of all these queries and I was wondering whether there exists some kind of standard flow chart type methodology of doing so, showing e.g. Query A is a select query on Query B and Table 1 joined on Fields a, b, c, and Query B itself is a crosstab query on Table 2, etc.
Thanks