O'Reilly logo

Microsoft® Office Access 2003 Inside Out by John L. Viescas

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required