Access 2010: Advanced Form Design

The Receipt Form, part 2


Advanced Access Objectives

In this lesson, you will learn how to:

1. Create a Select Query that combines (JOINS) several Tables by matching Keys.

2. Create a Blank Form and select a Query as the Record Source in the Form Properties.

3. Add existing Fields to a Form.

4. Add a Subform and Link the Form and Subform by three Key Fields.

5. Test the Receipt Form, see if it works.