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
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.
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
SQL Editor replacement
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
- 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.
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 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
For any questions or requests concerning this product or to all other 4TOPS products please contact our our support..