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

6. Access Structured Query Language (SQL) > 6.2. Access Query Design

Access Query Design

In Microsoft Access, queries can be defined in several different ways, but they all come down to an SQL statement in the end. The Query Wizard helps create a query by asking the user to respond to a series of questions. This approach is the most user friendly, but also the least powerful. Access also provides a Query Design window with two different views. The Design View is shown in Figure 6-1.

The Access Query Design View
Figure 6-1. The Access Query Design View

Query Design View displays table schemes, along with their relationships, and allows the user to select columns to return (projection) and specify criteria for the returned data (selection). Figure 6-1 shows a query definition that joins the BOOKS and PUBLISHERS table and returns the Title, Publisher, and Price of all books whose price is over $25.00.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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