A Microsoft Access query is a question about the information stored in Access tables.
Your query can be a simple question about data in a single table, or it can be a more complex question about information stored in several tables.
After run query, Microsoft Access returns only the information you requested.
Chapter 7 - Problem solving using access. Learning objectives of this chapter include: Describe the process of using the simple query wizard using access, describe the process of using the design view for creating a query using access, describe the process of adding a calculated field to a query using access, describe the process of using aggregate functions to calculate totals in queries, describe how to format results displayed in calculated fields.
In this lesson, you will learn to: Identify the following kinds of relations: Base tables Query results Views Create tables Alter tables Remove tables Query tables and work on them Define views Perform DML operations on views Identify the different types of views Identify data integrity constraints.