Microsoft Access
Creating subforms exercise
Average difficulty
This Microsoft Access CREATING SUBFORMS exercise is provided to allow potential course delegates to assess their suitability for the Wise Owl ACCESS INTRODUCTION FOR DEVELOPERS course only, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.
Exercise: Owners and Pets Form
A full answer to this exercise is provided as part of the training course!
| 1) | Download the files needed to start this exercise: exercise-347.zip (and click here if you experience any problems unzipping this file after downloading it). |
| 2) | Create a form based on the Owner table using the AutoForm: Columnar wizard, naming it OwnersOfPetsMainForm. |
| 3) | Create a second form based on the Pet table using the AutoForm: Tabular wizard, naming it OwnersOfPetsSubForm. |
| 4) | In design view, drag the sub form onto the main form. Add buttons and text boxes with expressions so that the result resembles the example below: |
Use the control wizard when adding your command buttons
|
|
| 5) | Close the form saving the changes. |
Thank you for showing an interest in this Access Introduction for Developers training course! As mentioned above, full answers to this and other exercises are provided on the course. On all Wise Owl scheduled courses delegates can take away these model answers (together with their own efforts!) on a free USB stick.
