Queries, being the heart of Access 2019, allow for the searching and extraction of information from tables for analysis. In this chapter, you will learn how to construct queries using Design View to analyze data and become knowledgeable about different query types and their function. You will learn how to create a simple Select query and add tables and fields to the query grid, and become familiar with different views and how to manipulate fields and criteria on the query grid. We will also cover advanced query construction.
In this chapter, we're going to cover the following main topics:
- Constructing basic queries
- Manipulating query fields and the Total row
- Constructing advanced queries
