Microsoft Office Marketplace logo



 

Single user USD99 EUR69 GBP69

Access 2007

Access 2000 - 2003

Supports Microsoft Office 2007
Microsoft® SQL Server®

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, 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

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.