Run multiple SQL Queries on the fly
Quick Query allows you to have multiple windows open at once, which are hosted outside
of the Access workspace.
Context Sensitive Highlighting
The query area provides context sensitive highlighting. Keywords, restricted words
and symbols, brackets and functions are all highlighted for easy identification.
Query multiple databases at once
Each window creates it's own connection to the current database open in MS Access.
If the open database changes, that connection is still maintained. This allows you
to query one database, while modifying another.
Manage existing Access queries
Quick Query provides access to existing queries in the current access database.
Queries can be opened, modified and then saved back into the database. New queries
can also be saved into the database. Once saved, queries can be used from within
MS Access in the same way as other Access queries.
Create queries too complex for Access Designer
There are certain types of more complex query that cannot be handled in the Access
query designer. An example if this is trying to join 2 instances of the same table
together with different aliases. Although there is a workaround in Access (using
multiple queries), it is difficult to maintain over time.
View additional information about each query
After each query has finished running, the time taken to run the query to the nearest
millisecond, and the total number of records returned from the query will be displayed
in the status bar.