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

Chapter 15. Creating a Simple Query > Understanding Access Query Types

Understanding Access Query Types

Before this lesson ends, you should spend a little time learning about the different types of queries that Access offers. In this lesson, you created a simple select query that “selects” data from a table or tables based on your query criteria. You can also build other types of queries in Access and most are based on the select query. For example, a select query pulls certain data from a table or tables. If you wanted to make a table from the data that the query pulls together for you, all you would have to do is create the select query and then change it to a Make Table query. The query type is changed in the Query Design view using the Query menu. We will work in the Query Design view in the next lesson.

The different query types are


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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