4TOPS Query Tree Editor for MS Access 4.0

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. Supports Access 2000-2007.

Improve your Microsoft® Access® query development by using the tools of the 4TOPS Query Tree Editor add-in. Query Tree reduces the analysis time in the cases a query doesn't give the result you want.

As an Access developer it can be a real pain to figure out all of the related queries when trying to make modifications to your database. Just touching one query may break a number of areas. This tool helps figure all that out.

Major Features:

1. Analyse all the dependencies of queries
   • Precedent (Uses) and Dependent (Used By) show the dependencies of queries in the database as a tree. Very helpful when assessing the consequences of changes.
2. Create Queries using templates
   • As an alternative to Access' built-in 'Simple Query Wizard', 4TOPS introduces creating queries using SQL templates. The advantages of this approach are:
   • • Many different types of queries are supported (last count: 30: select where like, left join, totals, insert, update, etcetera.
     • Queries are created faster
3. SQL Editor replacement
   • Microsoft Access' built-in SQL editor is rather simple for the advanced programmers. 4TOPS includes a full-fledged editor with intellisense. No need to copy to NotePad and back any more.
   • • Has Find and Replace possibilities: find strings or fields, optionally replace them.
     • You can Insert Fields from a selection list
     • Has Syntax coloring and brackets checking
     • On opening the editor adds line breaks and indentation to the query to show its structure.
4. Find Queries
   • Finding Queries lets you get a list of all the queries that use a certain string, e.g. a fieldname. This is useful if you plan to make changes to one or more fields and you want to see which queries will be affected. You can immediately start making the changes from the list using the SQL Editor.
5. Verify Queries
   • Verify Queries is a 1-click solution to make sure that after you make changes to the database or queries they all still work. You can immediately start fixing the broken queries from the list using the SQL Editor.