Lesson 1: Creating a Simple Query

Lesson 2: Creating Queries from Multiple Tables

In the last lesson we looked at queries that used the data from one table. In this lesson we will explore how to build relationships between tables and how we can use those tables to build queries that use data from all the tables.

Lesson 3: Queries that Change Data

In this lesson we will look at several types of queries you can perform on your data. Each of these queries will change either the data in the table or the structure of the database.

Lesson 4: Advanced Queries

Many of the queries in this lesson allow you to summarize your data. The crosstab queries, aggregate and total queries provide you a quick way of summarizing data. While you may prefer to do this kind of summarization with a report or with other tools, it is nice to know what Access can do.