Q: SQL Editor tool?

M

MarkD

We have a coworker who wants to learn SQL. Unfortunately,
the SQL design window in Access doesn't color text or
pinpoint where a mistake in the SQL text lies (like SQL
Navigator does, and I think SQL Server has a similar
function).

Is there an add in or an application she could use that
goes against Access tables and allows for better SQL
editing/debugging?

Thanks,
-Mark
 
V

Van T. Dinh

Sorry, I am not aware of any add-in.

However, if she wants to learn JET SQL, it is probably better to start by
using the QueryGrid to design what she wants, then switch to the SQL View
of the Query and see what the SQL String Access constructs for her. This
way, she can learn the correct JET SQL syntax quickly.

There is a JET SQL Reference section in Access Help for all the syntaxes
required in Access / JET. In addition, there is an excellent book on JET
SQL "SQL for Mere Mortals" by M. Hernandez and J. Viescas.
 
Top