Microsoft training courses | Wise Owl - home page

Phone (01457) 858877 or email.

Free Microsoft Access 2007 training exercise

This Access 2007 exercise of average difficulty is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.

You can learn how to do this exercise on the following Wise Owl training course: This course also includes a full answer to this exercise.
First download the files needed to start this exercise: ex-670 (and click here if you experience any problems unzipping this file after downloading it).

Pet menu form

Create two simple forms:

  • A form called frmOwnerSimple to view or edit owner details;
  • A form called frmPetSimple to view or edit pet details.

Create a new form in design view called frmMenu to resemble the example shown below:

Access 2007 exercise - Uses of VBA (image 1)

Use properties to turn off the unnecessary features such as Record Selectors

Write code in the Open event of the form so that it appears restored rather than maximised when it is opened.

Attach code to each of the buttons to:

  • Hide the menu form (use the Visible property of the form to do this);
  • Open the relevant form (depending on the button clicked).

Attach code to the Close event of each of the input forms, so that when either form is closed, the main menu becomes visible again.

Check that the system works, then save and close all the forms.

All content copyright Wise Owl Business Solutions Ltd 2013. All rights reserved.