Tracking Daily Attendance in MS Access

[SKBodner]

Hello,

I'm stumped and I'm hoping someone could help me figure out the best
way to track daily attendance for the next 6-4 months.

I have a list of 80 or so participants who should be attended training
on a daily basis and am tracking if they attended, have an unexcused
absence, or are absence with an excuse. At the end of the month, I plan
to print out reports on those who have missed more than one day with an
unexcused absence. My query will show the number of days missed over
the number of days training has been provided to give me a percentage
of days missed.

I understand that over the next 6-9 months, there are a number of days!
Should I just create a sheet with the participants ID and Name and
start the next column heading as May 1, then May 2...all the way to end
of the training program? Should I have one table for May, another for
June, or put all the dates in one table? Is there a better way to do
this?

Any suggestions would be appreciated.

Sandy :o)

[Bob Quintal]

"SK******@gmail .com" <SK******@gmail .com> wrote in
news:11******** **************@ y43g2000cwc.goo glegroups.com:

Hello,

I'm stumped and I'm hoping someone could help me figure out
the best way to track daily attendance for the next 6-4
months.

I have a list of 80 or so participants who should be attended
training on a daily basis and am tracking if they attended,
have an unexcused absence, or are absence with an excuse. At
the end of the month, I plan to print out reports on those who
have missed more than one day with an unexcused absence. My
query will show the number of days missed over the number of
days training has been provided to give me a percentage of
days missed.

I understand that over the next 6-9 months, there are a number
of days! Should I just create a sheet with the participants ID
and Name and start the next column heading as May 1, then May
2...all the way to end of the training program? Should I have
one table for May, another for June, or put all the dates in
one table? Is there a better way to do this?

Any suggestions would be appreciated.

Sandy :o)

The textbook example would have three tables,
One for students
StudentID
FullName
Phone,
etc.

The next is Status,
1=present,
2=Absent(Excuse ),
3=Absent(no Excuse)
4=Late
etc.

The last is Attendance which contains
StudentID
Date
Status

every schoolday, you run an append query which adds a record for
each student, the current date, optionally a default status.
Then the teacher changes status as required.
--
Bob Quintal

PA is y I've altered my email address.

[PC Datasheet]

A couple of notes for using Bob's suggestion ----
1. Don't name your date field in the Attendance table "Date". "Date" is an
Access reserved word and must not be used as a field name. Sooner or later
you will experience a problem if you do.
2. Do not set up your attendance form where you have to enter the date for
each record. Create a routine to create the dates you need for any class
month and then incorporate the routine in a query to automatically generate
the dates.
3. If you don't have too many different types of Status, use an option
group bound to Status on your form. This will give you multiple checkboxes
where you can check the appropriate Status for each student.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1175 users have come to me from the newsgroups requesting help
re******@pcdata sheet.com
"Bob Quintal" <rq******@sympa tico.ca> wrote in message
news:Xn******** **************@ 207.35.177.135. ..

"SK******@gmail .com" <SK******@gmail .com> wrote in
news:11******** **************@ y43g2000cwc.goo glegroups.com:

Hello,

I'm stumped and I'm hoping someone could help me figure out
the best way to track daily attendance for the next 6-4
months.

I have a list of 80 or so participants who should be attended
training on a daily basis and am tracking if they attended,
have an unexcused absence, or are absence with an excuse. At
the end of the month, I plan to print out reports on those who
have missed more than one day with an unexcused absence. My
query will show the number of days missed over the number of
days training has been provided to give me a percentage of
days missed.

I understand that over the next 6-9 months, there are a number
of days! Should I just create a sheet with the participants ID
and Name and start the next column heading as May 1, then May
2...all the way to end of the training program? Should I have
one table for May, another for June, or put all the dates in
one table? Is there a better way to do this?

Any suggestions would be appreciated.

Sandy :o)

The textbook example would have three tables,
One for students
StudentID
FullName
Phone,
etc.

The next is Status,
1=present,
2=Absent(Excuse ),
3=Absent(no Excuse)
4=Late
etc.

The last is Attendance which contains
StudentID
Date
Status

every schoolday, you run an append query which adds a record for
each student, the current date, optionally a default status.
Then the teacher changes status as required.
--
Bob Quintal

PA is y I've altered my email address.

[Please Stop Advertising]

* PC Datasheet:

A couple of notes for using Bob's suggestion ----
1. Don't name your date field in the Attendance table "Date". "Date" is an
Access reserved word and must not be used as a field name. Sooner or later
you will experience a problem if you do.
2. Do not set up your attendance form where you have to enter the date for
each record. Create a routine to create the dates you need for any class
month and then incorporate the routine in a query to automatically generate
the dates.
3. If you don't have too many different types of Status, use an option
group bound to Status on your form. This will give you multiple checkboxes
where you can check the appropriate Status for each student.

--
To anyone reading this thread:

It is commonly accepted that these newsgroups are for free
exchange of information. Please be aware that PC Datasheet
is a notorious job hunter. If you are considering doing
business with him then I suggest that you take a look at
the link below first.

http://home.tiscali.nl/arracom/whoissteve.html

Randy Harris

[David Gatheral]

The whoissteve website is excellent.

Very well done to those that put the time and effort into defeating the
idiot that is PC Datasheet.

David.

[Keith Wilby]

"David Gatheral" <da***********@ yahoo.co.uk> wrote in message
news:11******** **************@ u72g2000cwu.goo glegroups.com.. .

The whoissteve website is excellent.

Very well done to those that put the time and effort into defeating the
idiot that is PC Datasheet.

David.

Take a bow Arno R. To be fair, PC D's contribution to this thread is
actually accurate and useful for a change, pity about that sig line.

Keith.

[PC Datasheet]

Another idiot from the UK!!!
"David Gatheral" <da***********@ yahoo.co.uk> wrote in message
news:11******** **************@ u72g2000cwu.goo glegroups.com.. .

The whoissteve website is excellent.

Very well done to those that put the time and effort into defeating the
idiot that is PC Datasheet.

David.

[Tom van Stiphout]

On Wed, 10 May 2006 12:00:30 +0100, "Keith Wilby" <he**@there.com >
wrote:

However, I'm thinking that "...an option group bound to Status on your
form. This will give you multiple checkboxes..." is not good advise.
In an option group you typically want multiple radio buttons, allowing
for exclusive selection of one option among several. Checkboxes should
only be used where multiple can be selected.,

-Tom.

"David Gatheral" <da***********@ yahoo.co.uk> wrote in message
news:11******* *************** @u72g2000cwu.go oglegroups.com. ..

The whoissteve website is excellent.

Very well done to those that put the time and effort into defeating the
idiot that is PC Datasheet.

David.

Take a bow Arno R. To be fair, PC D's contribution to this thread is
actually accurate and useful for a change, pity about that sig line.

Keith.

[Keith Wilby]

"Tom van Stiphout" <no************ *@cox.net> wrote in message
news:1r******** *************** *********@4ax.c om...

On Wed, 10 May 2006 12:00:30 +0100, "Keith Wilby" <he**@there.com >
wrote:

However, I'm thinking that "...an option group bound to Status on your
form. This will give you multiple checkboxes..." is not good advise.
In an option group you typically want multiple radio buttons, allowing
for exclusive selection of one option among several. Checkboxes should
only be used where multiple can be selected.,

I'm being generous and assuming that "multiple checkboxes" should have read
"numerous radio buttons". :-)

Keith.

[Larry Linson]

"PC Datasheet" <No****@Spam.Co m> wrote

Another idiot from the UK!!!

Q: "Why is ever'body always pickin' on Steve?"