Lesson 14
Access Queries Conclusion
This module discussed defining queries in Access.
To start with, you created a query with the Simple Query Wizard, which allows you to easily group and summarize data, and the query you created can be edited in Design view.
Then you moved on to Query Design view which involved choosing tables and fields, then adding criteria, sorting, and creating calculated fields. You should be comfortable with all of these features of the Query Design view. Of course, getting exactly the data you want using a query can take practice, but you have the foundations of the knowledge you need.
Terms and concepts
This module introduced you to the following terms:
- Action query
- Criteria expression
- Crosstab query
- Dynaset
- Operator
- Query definition
Access 2010 also continues to provide the Query Wizard, a tool specifically designed to walk the user through creating each of the pieces of the query in a step-by-step fashion. Switching any query to SQL
View mode allows for direct modification of the SQL statement for the query. Access 2010 makes building queries extremely easy, whether you are using the Query Designer, using the Query Wizard, or writing
the SQL statement from scratch.
In the next module you will learn how to design and create a form.