 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / August 2006I need help with setting up an attendance register
I have 10 classes that I see for 1, 2 or 3 hours per week. Each class has about 30 students. I have set up tables for the student details (FirstName, LastName, ClassGroup, etc (personal details, etc....). What I want to do is set up an attendance register that brings up the classes (determined by the day of the week), capture the date, record who was present, absent (or Late but attended) and then append this data to the master attendance table. At the moment, I just cant see the "wood for the trees". Can anyone give me a few pointers?  SignatureBruce Rae Hopefully you will have the following tables: Student - Info on each student is will be taking any class Class - Info on each class you offer Session - One record for each time a class is offered, (date, time, location, etc) Attendance - Intersection of Student and Session. Should have: StudentID ClassID SessionID Status (attended, late, absent, left early, etc) Now you can create a query based on the Attendance table. This should be the record source for your form. You will probably want to include the Student and Class tables so you will have the names for each. Now you will be able to view, modify, add, or delete records for the Session table. > I have 10 classes that I see for 1, 2 or 3 hours per week. > Each class has about 30 students. [quoted text clipped - 5 lines] > At the moment, I just cant see the "wood for the trees". Can anyone give me > a few pointers? Sorry about that - I realised the minute I sent the post that I had forgotten to include the rest of the tables! Age catches up! I have the following tables set up: Student data (Name, class, personal details.....) Classes ClassDayPeriod TeachingDays I am just having a little difficulty putting it all together. How do I creat the intersection of student and session? Thanks! SignatureBruce Rae > Hopefully you will have the following tables: > Student - Info on each student is will be taking any class [quoted text clipped - 22 lines] > > At the moment, I just cant see the "wood for the trees". Can anyone give me > > a few pointers? It would be an additional table as I described in my previous post. What are the ClassDayPeriod and TeachingDays tables for? > Sorry about that - I realised the minute I sent the post that I had forgotten > to include the rest of the tables! Age catches up! [quoted text clipped - 33 lines] > > > At the moment, I just cant see the "wood for the trees". Can anyone give me > > > a few pointers? The ClassDayPeriod table shows what classes I have on each day and the time slot allocated is call the Period. The Teaching days table lists all the days we are actually at school. SignatureBruce Rae > It would be an additional table as I described in my previous post. > What are the ClassDayPeriod and TeachingDays tables for? [quoted text clipped - 36 lines] > > > > At the moment, I just cant see the "wood for the trees". Can anyone give me > > > > a few pointers? Okay, neither of those would be involved in this. > The ClassDayPeriod table shows what classes I have on each day and the time > slot allocated is call the Period. [quoted text clipped - 40 lines] > > > > > At the moment, I just cant see the "wood for the trees". Can anyone give me > > > > > a few pointers? I don't know enough to be able to comment here. Can you give me an example of the fields that would be in Session? Can you do the same for Status? Regards SignatureBruce Rae > Okay, neither of those would be involved in this. > [quoted text clipped - 42 lines] > > > > > > At the moment, I just cant see the "wood for the trees". Can anyone give me > > > > > > a few pointers? This would be a layout for the table: Session - One record for each time a class is offered, (date, time, location, etc) Not knowing for sure how your ClassDayPeriod is layed out, it may be that it would be related to the Attendance table. Attendance - Intersection of Student and Session. Should have: AttendanceID (primary key - autonumber) ClassDayPeriodID (foreign key - primary key of ClassDayPeriod) StudentID (foreign key - primary key of Student table) Status (attended, late, absent, left early, etc) The Status field will tell you whether the student attended the class that day, was late, was absent, and whatever other info you want to take for the students. > I don't know enough to be able to comment here. > Can you give me an example of the fields that would be in Session? [quoted text clipped - 47 lines] > > > > > > > At the moment, I just cant see the "wood for the trees". Can anyone give me > > > > > > > a few pointers? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.