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

Chapter 15. Creating a Simple Query > Using Other Query Wizards

Using Other Query Wizards

Access's different query features are quite powerful; they can do amazingly complicated calculations and comparisons on data from several tables. Queries also can do calculations to summarize data or arrange the query data in a special format called a crosstab. Creating more advanced queries means that your database tables must be joined by the appropriate relationships; otherwise, the query cannot pull the data from multiple tables.

You can create very complex queries from the Query Design view, which you learn about in the next lesson. However, Access also provides some wizards that can be used to create some of the more complex query types. These wizards include the following:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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