Relational forms tie together data from various tables into a single screen, facilitating easy data entry and editing. This workshop is intended for anyone who is interested in learning how to create and enhance relational forms and subforms with drop-down lists, command buttons, and calculated fields. Creating a switchboard will be introduced.

(Description continued below)

Participants will:

• create relational forms and subforms
• learn various navigational views
• enhance forms with drop-down lists and command buttons
• add calculated fields and default value properties
• use Form Designer to build upon a blank form
• modify form controls and properties
• create an unbound combo box and modify lookup field properties
• create a switchboard using the Switchboard Manager

The following workshops are suggested prerequisites to this workshop:

• Access: Queries

Participants should already be able to:

• work with relational databases
• define relationships between tables
• create relational queries