Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Bookmark and ShareShare
Overview
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.

  • Length: 45–50 minutes
 


GOALS

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.
 
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.
COURSE TEXT

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.

 
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.

  Go to previous page (disabled)    Next Go to next page
advertisement