G
Guest
I need to write a database that will keep track of student evaluations. I
want to have one table for the Class, Semester, and Year. Another table for
the Students, and a third for the evaluations. The Evaluations can be a
little different for each class. What I envision is a series of tabs. One for
each Class and one for Students. On the Students page I want to be able to
list them as active or non active and assign them to a class and keep track
of which classes they have completed and which they have left. When they have
completed all the required classes they should be deactivated. All students
will have a unique ID number.
For each class the students have to perform clinical activities. These
activities are evaluated and graded for each patient case they work on. There
may be several cases handled and evaluated by each student. When a sufficient
number of passing evaluations is made then the student moves on to the next
class.
The idea here is that the Evaluating instructor can use a tablet or note
book PC to walk around the clinic and perform the evaluations. They should be
able to click on a class tab, choose the correct Semester and Year then
select a student from the list of active enrolled students for that class, as
was pre-entered under the student tab (or create new student on the spot).
The form should let the instructor fill out the evaluation data fields. As
they will be going from student to student they should be able to use a drop
down to select the current eval form for a student, put the info in then go
to the next student and quickly switch to them, then back to the original
student for more input, then close the eval when all work with that patient
is done, and print it, and open a new one for the student as needed until the
class is over and every one is passed or fails, etc. All past evals are kept
and student records are kept, and past classes are keep for historical
analysis etc. Reports will need to be generated on currently undetermined
criteria etc. Each eval will automatically compute the student grading score
for that patient encounter.
The main problem I am having is how to set up the tabs, the table
relationships and the binding that needs to be done. I see a one to many
relationship with the class/semester/year table and the evals and a one to
many relationship with the students to evaluations. I should be able to go to
any class tab and choose the semester/year then student and be able to scroll
through all the evals they have.
Can this be done, any ideas as to how to setup the tables and tabs (which I
can not figure out to bind like I can a form, but I only want one form) and
do the relationships? Any examples or samples, would be very helpful.
I know this is a tall request for a lot of advanced setup, but I would think
that Access is capable of doing it. I would try to do this in Visual Basic
6.0, but I need the reporting and ease of movement within the database that
is native to Access etc.
Any and all help and suggestions will be greatly appreciated.
Thanks to all,
Ralph Malph
want to have one table for the Class, Semester, and Year. Another table for
the Students, and a third for the evaluations. The Evaluations can be a
little different for each class. What I envision is a series of tabs. One for
each Class and one for Students. On the Students page I want to be able to
list them as active or non active and assign them to a class and keep track
of which classes they have completed and which they have left. When they have
completed all the required classes they should be deactivated. All students
will have a unique ID number.
For each class the students have to perform clinical activities. These
activities are evaluated and graded for each patient case they work on. There
may be several cases handled and evaluated by each student. When a sufficient
number of passing evaluations is made then the student moves on to the next
class.
The idea here is that the Evaluating instructor can use a tablet or note
book PC to walk around the clinic and perform the evaluations. They should be
able to click on a class tab, choose the correct Semester and Year then
select a student from the list of active enrolled students for that class, as
was pre-entered under the student tab (or create new student on the spot).
The form should let the instructor fill out the evaluation data fields. As
they will be going from student to student they should be able to use a drop
down to select the current eval form for a student, put the info in then go
to the next student and quickly switch to them, then back to the original
student for more input, then close the eval when all work with that patient
is done, and print it, and open a new one for the student as needed until the
class is over and every one is passed or fails, etc. All past evals are kept
and student records are kept, and past classes are keep for historical
analysis etc. Reports will need to be generated on currently undetermined
criteria etc. Each eval will automatically compute the student grading score
for that patient encounter.
The main problem I am having is how to set up the tabs, the table
relationships and the binding that needs to be done. I see a one to many
relationship with the class/semester/year table and the evals and a one to
many relationship with the students to evaluations. I should be able to go to
any class tab and choose the semester/year then student and be able to scroll
through all the evals they have.
Can this be done, any ideas as to how to setup the tables and tabs (which I
can not figure out to bind like I can a form, but I only want one form) and
do the relationships? Any examples or samples, would be very helpful.
I know this is a tall request for a lot of advanced setup, but I would think
that Access is capable of doing it. I would try to do this in Visual Basic
6.0, but I need the reporting and ease of movement within the database that
is native to Access etc.
Any and all help and suggestions will be greatly appreciated.
Thanks to all,
Ralph Malph