Module 3 – Queries

What are queries?

In Access, queries are like questions that you ask to find related, even very specific, information in your database. In queries, you sometimes use data from just one table and other times from more than one. 

In Access, a query is a database object. It doesn’t store data. Instead, it displays data that is stored in tables and it makes that data available for you to work with. 

Duration: 06:02

Creating queries

For quick searches and questions, create a basic query to find the data you need and get your answers.

Often, to get the answers you need, you create queries that gather information from more than one table or from a combination of tables and queries.

Basic queries

Duration: 05:44

Queries with many tables

Duration: 05:15