Quick Query is a Plug-In for Microsoft Access. It provides a context sensitive, simple way to perform SQL queries on the fly, without creating or saving a query using the standard Query Designer.
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 its 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 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 of 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.
System Requirements:
Windows Operating System (Me, 2000, XP, 2003)
MS Access 2000 or greater
Microsoft .Net Framework Version 1.1