|
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. From the
Create Ribbon 1.
Create ->Queries->Query Design, page 128 2.
Create ->Forms->Blank Form, page 131
From the Form Design
Tools->Design Ribbon. 3.
Form Design Tools->Design->Tools->Property Sheet, page 132 4.
Form Design Tools->Design->Header & Footer, page 133 5.
Form Design Tools->Design->Tools->Add Existing Fields, page 138 6.
Form Design Tools->Design->Controls->Subform/Subreport, page 140 |
|
|
|
