• 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 the Query Des...

Building Queries Using the Query Designer

Particularly if you are already familiar with building queries in a desktop database, using the query designer in an Access project is the best way to get started designing queries for SQL Server.

Understanding the Query Designer

As noted earlier, you can use the query designer to create three different types of queries—views, in-line functions, and stored procedures that return a result from a single select statement. Although these queries have different purposes, most of the tools you use to create them in Design view are the same. Let’s start by looking at the common elements in the query designer for all query types. Later sections of this chapter cover the differences for each query type.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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