Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 More

The Director's Cut

Editing the Screen Play

 

Click Here to Get Started

Sample Files

 

Intermediate Access

Lesson Objectives: Learn how to make forms that represent one-to-many relationships. This lesson will show how to create forms with subforms, multi item and spilt forms, and how to bind controls. In this lesson you will:

Practice the steps needed to create a table Page 3

Use the Field Properties to set the Default Date Page 5

Practice the steps needed to create a form Page 6

Use a Query for a Combo Box Page 12

Test Your Software Page 16

Define One-to-One Relationships Page 17

Learn how to make a Table for the Subform Page 18

Practice the steps needed to make a Subform Page 19

Define the fields that link the Form and Subform Page 23

Learn how to make Multiple Item Forms Page 28

Learn how to make Split Forms Page 31

Identify Bound and Unbound Controls Page 33