does anyone have a attendence database ??

[Guest]

I am looking for an attendence database to track the attendence at a sunday
school.

Thanks

 

[Michael Gramelspacher]

I am looking for an attendence database to track the attendence at a sunday
school.

Thanks

Microsoft has a classroom management database template for Access 2003.
http://office.microsoft.com/en-us/templates/TC010184071033.aspx?
CategoryID=CT011366821033

You could modify it to keep attendance. Possibly add tables:

AttendanceCodes
----------------
attend_code Char(1) -- code P=present (default), A=Absent, L=Late
attend_name Varchar (15) -- present, absent, late

ClassDates
-----------
class_date DATETIME -- every Sunday, every Wednesday evening, ?

ClassAttendance
----------------
ClassID long integer FOREIGN KEY REFERENCES Classes(ClassID)
StudentID long integer FOREIGN KEY REFERENCES Students(StudentID)
class_date DATETIME Foreign KEY REFERENCES ClassDates(class_date)
attend_code CHAR(1) FOREIGN KEY REFERENCES AttendanceCodes(attend_code)
Primary KEY (ClassID, StudentID, Class_date)

You would creating a query in the interface linking whatever tables are
necessary, and then make that the record source of an attendance roster
form. After updateing the attendance codes, insert the fields into the
ClassAttendance table.

Just some ideas. Also perhaps
http://www.psci.net/gramelsp/temp/Attendance2.zip
But this is very rough as it was just a learning practice to pull up a
class attendance roster based on the time of day and week day. So, it is
not very likely to pull any records on Wednesday evening. Just the
tables and 3 queries.

Mike Gramelspacher

 

[Guest]

Thanks I will give it a try.
--
CChandonnet

Microsoft has a classroom management database template for Access 2003.
http://office.microsoft.com/en-us/templates/TC010184071033.aspx?
CategoryID=CT011366821033

You could modify it to keep attendance. Possibly add tables:

AttendanceCodes
----------------
attend_code Char(1) -- code P=present (default), A=Absent, L=Late
attend_name Varchar (15) -- present, absent, late

ClassDates
-----------
class_date DATETIME -- every Sunday, every Wednesday evening, ?

ClassAttendance
----------------
ClassID long integer FOREIGN KEY REFERENCES Classes(ClassID)
StudentID long integer FOREIGN KEY REFERENCES Students(StudentID)
class_date DATETIME Foreign KEY REFERENCES ClassDates(class_date)
attend_code CHAR(1) FOREIGN KEY REFERENCES AttendanceCodes(attend_code)
Primary KEY (ClassID, StudentID, Class_date)

You would creating a query in the interface linking whatever tables are
necessary, and then make that the record source of an attendance roster
form. After updateing the attendance codes, insert the fields into the
ClassAttendance table.

Just some ideas. Also perhaps
http://www.psci.net/gramelsp/temp/Attendance2.zip
But this is very rough as it was just a learning practice to pull up a
class attendance roster based on the time of day and week day. So, it is
not very likely to pull any records on Wednesday evening. Just the
tables and 3 queries.

Mike Gramelspacher

 

[Guest]

This database does not track attendence only grades.

 

[Michael Gramelspacher]

This database does not track attendence only grades.

Craig,

I doubt that there is a ready-made solution tailored specifically to
your need. Some people here develop solutions and other like me just do
simple things to fill our own needs. Take a look at my link again:
http://www.psci.net/gramelsp/temp/Attendance2.zip I added a form to
make this example somewhat useful, but it is only a starting point. I
only did this because I found a question posed in this newsgroup
challenging and no solution was offered.

Mike Gramelspacher