4TOPS Query Tree Editor - create, edit, analyse and verify

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.

Analyse all the dependencies of queries - understand why queries don't return the results you expect.
Create queries using templates - SQL editing with intellisense.
Find Queries: Give a search string - a fieldname or function - and you get all the queries that use it.
Verify Queries: Click and be sure that after you make changes to the database the queries all still work.
Document your queries using the text tree or a screenshot of the dependency tree.

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.
The picture below shows in a tree all the queries that depend on a selected table or query. Double-click on the relevant queries in the tree to compare the results of each. This will help you diagnose in case a certain query doesn't return the results you expected.

ms access query tree

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

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.

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.

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.

Support

For any questions or requests concerning this product or to all other 4TOPS products please contact support@4tops.com.

Installation

The download uses self-extracting technology for easy installation.

Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.