|
|
Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
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?
--
Bruce 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.
"Brucear" wrote:
[Quoted Text] > 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?
> --
> Bruce Rae
|
|
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!
--
Bruce Rae
"Klatuu" wrote:
[Quoted Text] > 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.
>
>
> "Brucear" wrote:
>
> > 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?
> > --
> > Bruce Rae
|
|
It would be an additional table as I described in my previous post.
What are the ClassDayPeriod and TeachingDays tables for?
"Brucear" wrote:
[Quoted Text] > 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!
> --
> Bruce Rae
>
>
> "Klatuu" wrote:
>
> > 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.
> >
> >
> > "Brucear" wrote:
> >
> > > 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?
> > > --
> > > Bruce Rae
|
|
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.
--
Bruce Rae
"Klatuu" wrote:
[Quoted Text] > It would be an additional table as I described in my previous post.
> What are the ClassDayPeriod and TeachingDays tables for?
>
> "Brucear" wrote:
>
> > 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!
> > --
> > Bruce Rae
> >
> >
> > "Klatuu" wrote:
> >
> > > 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.
> > >
> > >
> > > "Brucear" wrote:
> > >
> > > > 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?
> > > > --
> > > > Bruce Rae
|
|
Okay, neither of those would be involved in this.
"Brucear" wrote:
[Quoted Text] > 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.
> --
> Bruce Rae
>
>
> "Klatuu" wrote:
>
> > It would be an additional table as I described in my previous post.
> > What are the ClassDayPeriod and TeachingDays tables for?
> >
> > "Brucear" wrote:
> >
> > > 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!
> > > --
> > > Bruce Rae
> > >
> > >
> > > "Klatuu" wrote:
> > >
> > > > 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.
> > > >
> > > >
> > > > "Brucear" wrote:
> > > >
> > > > > 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?
> > > > > --
> > > > > Bruce Rae
|
|
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
--
Bruce Rae
"Klatuu" wrote:
[Quoted Text] > Okay, neither of those would be involved in this.
>
> "Brucear" wrote:
>
> > 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.
> > --
> > Bruce Rae
> >
> >
> > "Klatuu" wrote:
> >
> > > It would be an additional table as I described in my previous post.
> > > What are the ClassDayPeriod and TeachingDays tables for?
> > >
> > > "Brucear" wrote:
> > >
> > > > 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!
> > > > --
> > > > Bruce Rae
> > > >
> > > >
> > > > "Klatuu" wrote:
> > > >
> > > > > 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.
> > > > >
> > > > >
> > > > > "Brucear" wrote:
> > > > >
> > > > > > 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?
> > > > > > --
> > > > > > Bruce Rae
|
|
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.
"Brucear" wrote:
[Quoted Text] > 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
> --
> Bruce Rae
>
>
> "Klatuu" wrote:
>
> > Okay, neither of those would be involved in this.
> >
> > "Brucear" wrote:
> >
> > > 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.
> > > --
> > > Bruce Rae
> > >
> > >
> > > "Klatuu" wrote:
> > >
> > > > It would be an additional table as I described in my previous post.
> > > > What are the ClassDayPeriod and TeachingDays tables for?
> > > >
> > > > "Brucear" wrote:
> > > >
> > > > > 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!
> > > > > --
> > > > > Bruce Rae
> > > > >
> > > > >
> > > > > "Klatuu" wrote:
> > > > >
> > > > > > 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.
> > > > > >
> > > > > >
> > > > > > "Brucear" wrote:
> > > > > >
> > > > > > > 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?
> > > > > > > --
> > > > > > > Bruce Rae
|
|
|