Sams Teach Yourself SQL in 10 Minutes

Using Microsoft Query

Microsoft Query is a standalone SQL query tool and is an ideal utility for testing SQL statements against ODBC Data Sources. Microsoft Query is optionally installed with other Microsoft products (for example, Microsoft Office), as well as with other third-party products. To use Microsoft Query, do the following:

1. Microsoft Query uses OBDC to interact with databases, so an ODBC Data Source must be present before you can proceed (see the earlier instructions).

2. Before you can use Microsoft Query, it must be installed on your computer. Browse your program groups beneath the Start button to locate it. If it is not present under the Start button, use Start Find to locate it on your system. (It is often present without your knowing ...