SQL Editor

Press the 'Query Editor' button on the toolbar or ribbon (Create
> Queries) to Start the SQL Editor. The SQL Editor replaces the MS
Access built-in SQL editor.
Features:
- Color coding of SQL keywords and functions for improved readability
- Use Templates to do apply common SQL fragments, such as nz({FIELD}) or
format(...)
- Find and replace
- Fast insertion of fields (insert
Item)
- Syntax problems help: marks unmatched brackets in red (
- Open editor for underlying query by using right click on it in
current open editor

Controls:
Save
Save current changes.
Undo
Undo editing
Design
Open the query in design mode
Query Editor Find and
Replace (Find & Replace strings or fields in the SQL)
Insert Item
Insert a field
Open
Run the query
Save As
Save changes under a new query name