4TOPS Query Tree Editor for MS Access for query development. Analyse, edit and run queries from a tree dialog showing query dependencies (Uses / Used By). Supports Access 2000-2007, SQL Editor included.
Dec 26, 2011 12:07:03
Windows 95, Windows 98, Windows ME, Windows NT, Windows 2000, Windows XP, Windows 2003, Windows Vista
Description: 4TOPS Query Tree Editor is an add-in for MS Access for query development and analysis. The Query Tree dialog displays the dependency tree of a selected query (Uses / Used By). The buttons on the dialogs support a natural way of working with queries, smoothly switching from the tree overview to query editing to saving different versions or running them to evaluate the results. Double-click on a query opens the query datasheet. Press the Edit button to make required changes using the Query Editor. The Print button writes the tree to the Debug Window. Use it to compare query dependency trees or to paste it into your documentation. Double-click on multiple queries to compare results. This will help you diagnose in case queries don't return the results you expected.
There are templates for the most usual sql. New is Verify and Find. Verify in one click that all queries still work after changes and Find all queries/tables that use a certain Field.