There is a newer version of this video available

• Click here to see my new TechHelp video: Recordsets

Programmatically access your data using VBA code

Q: I need to track attendance for students in my class. Is there a way to show a list of all of the students in my class, click on the students that are absent, and then save that information to a table so I can report on it later? I need to do this every day, so it needs to be easy and fast.

A: The easiest thing to do would be to create a multi-select listbox with all of your students in it. Click on the students that are absent, and then use a Recordset to programmatically add those students to an "attendance history" table.I know this might seem confusing, but it's real simple. See this Free Video Tutorial for step-by-step instructions.

Recordsets aren't easy... this is an advanced Access developer concept. However, I do cover them in great detail starting in Microsoft Access Developer Level 16. I spend over 10 hours covering Recordsets. They're important for any developer to learn about, and once you master them, the sky's the limit with your databases!

This is a repost of one of my older videos. I'll be updating it soon!