Automatically logging attendance

P

paulaj

First let me begin by saying that my Access knowledge is limited, at best. I
figured Access would be the best place to try to start.

I am a training instructor. Currently when I have a class, everyone passes
around a little sheet and signs in when they attend. I then turn around and
enter everyone into Excel. Every now and again I print the list out so folks
can see the courses that they have attended.

What I would like.... is for me to have something that everyone logs into as
they come to class. I would most likely create everyone a unique user id,
maybe their desk code and last 4 of their SS# that they would just key in;
that way no one can dispute the actual attendance record.

Knowing that just about everything is possible....how do I go about this?
Any ideas (or templates) would be greatly appreciated.
 
M

Mr B

Are you on a network?

If so, you can have an Access application that will read the network id of
the user as they open the app. Then you can create a new record for that
individual based on their login ID. You would need a table of students with
their logins.

You could just have an icon on their desktop that would run the application.
when they logged in, it would automatically create a new record for the
student logging in, assign the current date to the record and then
immediately close, thus capturing their attendence.

If you are not on a network, you can do the same thing by have them log in
with a user id and password.

HTH

Mr. B
 
Top