Building Queries Using a Text Editor

Thus far you have learned how to build queries using the query designer. You have already discovered that you can duplicate the functionality of Access desktop database (.mdb) queries by using the similar interface provided by the Access project query designer. However, SQL Server offers substantially more querying power than can be harnessed by using only the graphical query designer. To get the most out of SQL Server’s querying power, you must create queries using Transact-SQL in the text editor.

You won’t find any shortcuts to build a query in the text editor in the queries list in the Database window. To begin building a query using the text editor, you can select Queries on the Object bar in the Database ...

Get Microsoft® Office Access 2003 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.