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.

Subscribe to Access Tip: Form / SubForm
Get notifications when this page is updated