Overview

What is Quick Query?

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.

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.