• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 18. Building Queries in an Acces... > Building Queries Using a Text Editor

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 window and click the New button on the Database window toolbar, or you can choose Query from the Insert menu. When you do this, Access displays the New Query dialog box, as shown in Figure 18-25.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint