C
Chip
Hey Everyone, its me again..
My question today involves writing to multiple tables. My project is
an Access program that will be used to oversee practical
examinations. Each student (tblStudents) must pass each of 4
stations. There are 3 states for each station; Not Tested Yet (the
default), Pass, Fail. In the tblStudents I have fields that
correspond to each of the four stations, and a combo box with each of
the three states listed.
Each practical exam attempt, has associated with it, a date, a skills
examiner, the station, the class and the state window. One of the
requirements of my project is to look at the in multiple ways. Not
only do I want to record when a student passes or fails, but I want to
know how many times the student had to take that station. I also want
to measure class peformance as a whole. I want to measure how
individual evaluators do. There are limitless ways in which I can
forsee me chopping this data up.
So, the exam coordinator (me and my coworkers) come to a Practical
exam. We have a list of students as a subform in the Class. The
class itself has multiple things attached to it, the practical exam is
only a small part of it. When we start getting results of the
Practical exam back, we dbl click on the student name, and a form
opens that has the following items in it.
Student (populated, based on which student I dbl click)
Evaluator (combo box)
Class Number (populated based on which student I dbl click)
Exam Level (combo box)
Station (combo box)
Outcome (combo box, Not Tested Yet, Pass Fail)
Date (populated with Now())
These data points are then written to a table, tblPR. That table is
then used to populate other fields. In this example, each student has
a record. I record demographic data, paperwork items, etc.. One of
the things in the Student record is a history of the Practical Exam
attempts, complete with date, evaluator etc. all based on the tblPR.
This is a subform, that is only displayed on the student record.
Up to this point, everything works fine. However, when a student
passes or fails, I want my database to record the date and teh outcome
and do so on each student record. For example, if you take a station
today, 3/4/2009 and you fail. I want your current status for that
station to read Fail and the date of status to read 3/4/2009. Then if
you return next week and take the station and Pass, I want the Fail
status to be overwritten to Pass with teh corresponding date. That
would be on each studen trecord.
Then again, on the class record, I want the class record to be updated
as well. So my question is, is my structure appropriate for the
task? I think it is, since each Practical Exam attempt is its own
entity and can be measured, I was always told that if it can be
measured, it deserves its own table. If I can overcome this hurdle, I
believe I can replicate that logic on other fronts as well. We also
adminstered Written exams in the same way.
Your thoughts?
chip
My question today involves writing to multiple tables. My project is
an Access program that will be used to oversee practical
examinations. Each student (tblStudents) must pass each of 4
stations. There are 3 states for each station; Not Tested Yet (the
default), Pass, Fail. In the tblStudents I have fields that
correspond to each of the four stations, and a combo box with each of
the three states listed.
Each practical exam attempt, has associated with it, a date, a skills
examiner, the station, the class and the state window. One of the
requirements of my project is to look at the in multiple ways. Not
only do I want to record when a student passes or fails, but I want to
know how many times the student had to take that station. I also want
to measure class peformance as a whole. I want to measure how
individual evaluators do. There are limitless ways in which I can
forsee me chopping this data up.
So, the exam coordinator (me and my coworkers) come to a Practical
exam. We have a list of students as a subform in the Class. The
class itself has multiple things attached to it, the practical exam is
only a small part of it. When we start getting results of the
Practical exam back, we dbl click on the student name, and a form
opens that has the following items in it.
Student (populated, based on which student I dbl click)
Evaluator (combo box)
Class Number (populated based on which student I dbl click)
Exam Level (combo box)
Station (combo box)
Outcome (combo box, Not Tested Yet, Pass Fail)
Date (populated with Now())
These data points are then written to a table, tblPR. That table is
then used to populate other fields. In this example, each student has
a record. I record demographic data, paperwork items, etc.. One of
the things in the Student record is a history of the Practical Exam
attempts, complete with date, evaluator etc. all based on the tblPR.
This is a subform, that is only displayed on the student record.
Up to this point, everything works fine. However, when a student
passes or fails, I want my database to record the date and teh outcome
and do so on each student record. For example, if you take a station
today, 3/4/2009 and you fail. I want your current status for that
station to read Fail and the date of status to read 3/4/2009. Then if
you return next week and take the station and Pass, I want the Fail
status to be overwritten to Pass with teh corresponding date. That
would be on each studen trecord.
Then again, on the class record, I want the class record to be updated
as well. So my question is, is my structure appropriate for the
task? I think it is, since each Practical Exam attempt is its own
entity and can be measured, I was always told that if it can be
measured, it deserves its own table. If I can overcome this hurdle, I
believe I can replicate that logic on other fronts as well. We also
adminstered Written exams in the same way.
Your thoughts?
chip