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.
Chapter 10 - Application development with views. This chapter shows you how to apply your query formulation skills to building applications with views. This chapter also emphasizes views as the foundation for building database applications. Before discussing the link between views and database applications, essential background is provided. You will learn the motivation for views, the CREATE VIEW statement, and usage of views in SELECT and data manipulation (INSERT, UPDATE, and DELETE) statements.
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.