7/7/2009 2:10:33 AM
Access Tip: Form / SubForm
By Richard Rost
Q: I need to be able to track my students in a database along with what courses each student is enrolled for, and what date the course begins. How would I go about doing this?
A: For this, you would create two tables - one for your Students, and another for the Courses that student is taking. Then you would set up a Form with a Subform so that you can enter in all of the courses for that student, along with the details.
Click here to see the full video tutorial
I teach the concepts in this free mini tutorial in my Access 202 course. These are full courses - over 60 minutes in length each. I spend a lot more time going over how to do this, in addition to lots more tips and tricks.
Keywords: access tips form subform