Constructing Queries to Analyze Data in Microsoft Access 2019

Queries, being the heart of Access 2019, allow for the searching andextraction of information from tables for analysis. In this chapter, youwill learn how to construct queries using Design View to analyze data and becomeknowledgeable about different query types and their function. You willlearn how to create a simple Select query and add tables and fields tothe query grid, and become familiar with different views and how tomanipulate fields and criteria on the query grid. We will also coveradvanced 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

Leave a Comment