Attendance Tracking in Access

Hey guys...
I have the challenge of integraating an attendance tracking module to my student managment Dbase.
Do you guys know of any opensource examples out there that I can take a look at??

I am relativley new at all of this so I need a head start so to speak. I want to produce a student ID number to print on a label as a bar code. Then upon scanning the barcode I want to enter a time/date stamp to a table I guess to track that student's attendance.

I guess each student will have to have thier own table to keep track of this???
Hmmmmm....I have a lot of questions about this project...that's why it would be good to see an example.

Thanks Guys!!
Any input will be appreciated.
tobytkdAsked:
Who is Participating?
 
Arthur_WoodConnect With a Mentor Commented:
No each student would NOT have his/her own table.

You would have an Attendance table, which holds the StudentID and the Attemdance Date.

Is this toe a SINGLE event/class or are there several that you might be keeping track of,  If several, then your Attentdance table would hold StudentID, ClassID, AttendanceDate as the fields.

AW
0
 
jjafferrCommented:
Hi tobytkd,
Check this link for a similar task
http://www.experts-exchange.com/Databases/MS_Access/Q_20012462.html

Hope this helps

Jaffer
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.