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 select query that "selects" data from a table or tables based on your query criteria. You can also build other types of queries. The different query types are
Now, you might be thinking that all these query types are a little too much to handle. However, you create different query types just as you would a select query.
As a matter of fact, you actually design each of these different query types as a select table (using a wizard, Query Design view, or a combination of both), and then you change the query type in the Query Design view. It's just a matter of selecting the query type from the Query menu.
In this lesson, you learned how to create a simple query and how to save, edit, and print query results. You also learned about the different query wizards and the different types of queries. In the next lesson you work in the Query Design view.