Page 1 of 21PREVNEXT

Forms II: Use subforms

Nested subforms
Use subforms to work with more than one form at a time. Learn how to create and customize subforms inside main forms in Microsoft Office Access 2003.

About this course

This course includes:

  • Three self-paced lessons and three practice sessions for hands-on experience.
  • A short test at the end of each lesson; tests are not scored.
  • A Quick Reference Card you can take away from the course.


After completing this course you will be able to:

  • Explain how subforms work.
  • Create subforms using the Form Wizard and the SubForm Wizard.
  • Change the layout of subforms.
  • Use subforms to perform calculations and display the results in the main form.

Before you begin

You should be familiar with the basics of creating forms, or you should take the course Forms I: Create a form to enter and view your data.

Suppose you work with a complex database that contains many tables and forms. Wouldn't it be nice if you could view and enter data in multiple tables with just a single form? Access subforms let you do that. By putting forms into other forms, you can have everything you need all in one place.

To learn more about this course, read the overview in the center of this page or the table of contents in the left column. Then click Next to start the first lesson.

Page 1 of 21PREVNEXT