Microsoft Office Marketplace logo



 
Single user USD99 EUR69 GBP49
Supports Access 2000 and higher, not ADP

'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
 

Check out the flash demos:
Understanding how your queries work together 1:51
Create new queries using sql templates 1:40
Query editor for fast and effective SQL editing 2:50

 

Edit and track your Access SQL with 4TOPS Query Tree Editor

Improve your Microsoft® Access™ query development by using the 4TOPS Query Tree Editor add-in.

ms access query tree
Query Used By shows in a tree all queries that depend on a certain table or query. Very helpful when assessing the consequences of changes. Double-click on multiple queries to compare results. This will help you diagnose in case queries don't return the results you expected.

Query Editor makes changes to the query easy. Replaces Microsoft Access' built-in editor. No need to copy to WordPad and back.
  • Find/Replace: find strings or fields, optionally replace them.
  • Insert Fields from a selection list
  • Syntax coloring and brackets checking
  • On opening the editor adds line breaks and indentation to the query to show it's structure.

Query Templates are a short and easy to understand way to create SQL queries
.

Support

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

Query Tree Editor Online Help

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.