Create Ribbon

 

Intermediate Access Objectives

In this lesson, you will learn how to:

1. Use a Query as the Record Source for a Subform.

2. Apply Quick Styles to Controls in a Form/Subform.

3. Apply Conditional Formatting to a Subform that has Datasheet as the Default View.

4. Create a Form that has a Bound Control, a Combo Box, that will filter the Records in the Subform.

Menu Map
 
 

Lesson 3 : Form and Subform Design, part 1

 

   
Form Tools->Datasheet Ribbon
Menu Map

Menu Maps

From the Create Ribbon.

1. Create ->Queries ->Query Design, page 61

2. Create ->Forms->More Forms->Datasheet, page 64

6. Create ->Tables->Table Design, page 72

 

From the Form Tools->Datasheet Ribbon

3. Form Tools ->Datasheet, page 65

4. Datasheet->Formatting-> Alternate Row Color, page 66

5. Datasheet->Formatting-> Conditional Formatting, page 67