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.googlegr oups.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******@pcdatasheet.com
"Bob Quintal" <rq******@sympatico.ca> wrote in message
news:Xn**********************@207.35.177.135...

"SK******@gmail.com" <SK******@gmail.com> wrote in
news:11**********************@y43g2000cwc.googlegr oups.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.googlegr oups.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.googlegr oups.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.googleg roups.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.com...

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.Com> wrote

Another idiot from the UK!!!

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

[Bob Quintal]

"PC Datasheet" <No****@Spam.Com> wrote in
news:lp**************@newsread2.news.pas.earthlink .net:

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.
A scare tactic? the "will experience" is incorrect, "might
experience" is the truth. But thanks for pointing out the
possibility.

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.
I said:
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.

Steve, if you had spent 15 seconds thinking about the
implications of what I wrote, you would see the total redundance
of your reply.
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.

checkboxes? maybe radio boxes, maybe a combobox, but never
checkboxes for something like this.

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******@pcdatasheet.com

And over 2286 of those have come to the newsgroups afterwards
seeking help to fix your "solutions".

--
Bob Quintal

PA is y I've altered my email address.

[Keith Wilby]

"Bob Quintal" <rq******@sympatico.ca> wrote in message
news:Xn*********************@207.35.177.135...

Steve, if you had spent 15 seconds thinking about the
implications of what I wrote, you would see the total redundance
of your reply.

Bob, my apologies, I actually didn't read your post before I read PCD's.
Valuable lesson learned. :-)

Keith.