Quick Query is a Plug-In for Microsoft® Access. It provides a simple way to perform SQL based queries on the fly, without the need to create and save a query using the standard MS Access interface.
What's wrong with MS Access?
Developers who use database applications such as SQL Server, Oracle or MySql will be used to writing ad-hoc queries
to return data, check values, etc. Although MS Access provides the ability to edit the SQL directly, you need
to create a new query, bypass the Query Designer and enter SQL Mode. You are then presented with a basic text editor.
There is no context sensitive highlighting, and writing anything but the simplest queries can cause major headaches.
- Windows ME/2000/XP/2003
- Net Framework Version 1.1
- MS Access 2000 or greate
|File Size:||535 KB|
|License:||Free to try, $20.00 to buy|
How is Quick Query any better?
Quick Query allows you to quickly write an SQL query and display the results in the same window.
It provides context sensitive highlighting to easily identify keywords and nested pairs of brackets.
You can have several temporary queries on the go at the same time, without cluttering the MS Access workspace.
Queries stored within the database can be accessed with Quick Query, and then saved back to the database.
New queries can also be saved to the database.
Main Features of Quick Query :
- 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.
| RELATED SOFTWARE DOWNLOADS FOR QUICK QUERY
- PG Lightning Admin
PostgreSQL administration program for Windows
- Data Quik - Database Copier
Copy Database Records and selected fields between DBase, Paradox, Access, Excel and some Lotus Files.
- Visual SQL-Designer
is a program for visual constructing hard SQL-query for any database and write it
- Visual Open DB
is a generic data analysing application that allows you to query any valid data source
- 4TOPS Query Tree Editor for MS Access
is an add-in for MS Access for query development,edit and run queries from a tree dialog
- RazorSQL 4.X
is an SQL query tool, Navigator database, SQL editor, and database administration tool.
- Active Query Builder Standard ActiveX Edition
is a visual query builder component suite that allows your end-users to build complex SQL queries with unions and subqueries via an intuitive visual interface.
- Active Query Builder Standard .NET Edition
is a visual SQL query builder component that allows your end-users to build complex SQL queries via an intuitive visual query building interface easily.
- Oracle Query Analyser
is a professional development tool allows rapid transact SQL development against an Oracle database.
is an Interactive Query Tool which helps you to manipulate your SQL data easily.
- SQL Uniform
database query, comparation, export, convert, admin tool.