Databases

Unit 2: Manipulating the Data in a Database

Lesson 5: Creating a Database Query

How do you create a query from multiple tables?

If you haven't already, you should read the concept "What role do queries have in good database design?"

Some things to notice in the above animation:

1. The database starts out with two tables: Items and Stores.
2. The first step is to add two or more tables to the Query Design window.
3. Access automatically links the common fields in the two tables, as shown here: