MicroKnowledge Access 2007 Form Design

Access 2007 Form Design

Participants will create a user interface in Access using forms. Explore the different options available to create data entry forms and format them properly. Learn the essentials of advanced form features by utilizing tab controls, combo boxes, subforms and option groups.

Recommended Preparation: Access 2007 Basic or equivalent experience. Some knowledge of lookup fields is a plus.

Lesson 1: Creating Data Entry Forms

Instant forms
Split forms
Multiple items forms
Using the form wizard
Blank forms

Lesson 2: Form Enhancements Using Layout View

Changing fonts and text styles
Using conditional formatting
Formatting numbers, gridlines and other special elements
Adding fields from related tables

Lesson 3: Form Enhancements Using Design View

Working with controls and control properties
Creating calculated fields
Using control layouts

Lesson 4: Applying Advanced Controls

Tab controls
Combo boxes
Subforms
Option groups