Example of the completed Switchboard Form

Designing for Users:

Meet the Stars

Key Concept: Use Command Buttons to open Forms and Reports from a Form.

 

Plan: Create a Switchboard Form.

 

What Are the Steps?

Create an Unbound Form.

 

Add Command Buttons:

To open two Forms: Movies, Customers.

To open one Report: Movies by Year

 

Add Buttons to Return to the Switchboard

From the Movies and Customers Form.

 

What Are the Issues? The Command Button Wizard creates Embedded Macros.

 

Why Use This Method? Embedded Macros are the default in Microsoft Access 2010.

 

The Macros will be converted to Visual Basic (VBA) to demonstrate legacy programming.