download querytree



 

Single user USD79 EUR59.50 GBP49.50
ribbon 2007 with querytree
Access 2007 - 2010 32-bit
toolbar 2003 with querytree
Access 2000 - 2003

Windows XP, Vista®, Windows 7 and Microsoft® SQL Server®.

ADP not supported

translations
Abfragenentwicklung mit Hilfe von SQL-Vorlagen
Consultas - cree, edite, analice y verifique

Check out the flash demos:

Query Tree Editor Online Help

'Query Tree Editor is a useful product that integrates well with Microsoft Access and has many advantages over the internal editor'
Doug Steele, Advisor Guide Microsoft Access 12/06

 

4TOPS Query Tree Editor - create, edit, analyze 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

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.

find status 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:

sql templates

SQL Editor replacement

querytrees' SQL editor

Microsoft Access's 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 our our support..