Ideas on how to determin a specific value with varied parameters

[Laurence Nixon]

Hello all.
I am seeking ideas on how to determin a specific value with varied
parameters.

This will be for students who have taken modules in a course for
pre-certification. So it will be like this:

StudentA
ModuleA + ModuleC + ModuleD + ModuleE = (Completetion of this COURSE1)

StudentB
ModuleA + ModuleE + ModuleB + ModuleF = (Completetion of COURSE1)

If these values (Module??) were static then it really wouldnt be an
issue I dont think, but the model is based on electives chosen by the
student so a varying module sets should produce the completion of a
specified course.

How would I go about doing this within Access 2000, or is this more of
a VBA or VBS type problem.

Thanks all for there help in advance.

[DFS]

Laurence,

Your problem is going to be solved by application of whatever tool best
suits the issue. You can do most of it using Access/Jet database tables and
queries. You might need a few user interfaces.

You'll first need to build a database structure to capture the data.
Something like:
Students
------------
* StudentID
StudentName
Courses
--------------
* CourseID
CourseName
Modules
------------------
* ModuleID
ModuleName
CourseModules (modules valid for the course)
------------------------
* CourseID
* ModuleID
StudentCourseModule (modules chosen by the student in fulfillment of the
course requirements)
------------------------------------
* StudentID
* CourseID
* ModuleID
ModuleCompletedDate
ModuleGrade
etc.
* = primary key. And of course enforce appropriate indexes and required
fields and referential integrity so only valid data can be input.

The student would use the CouseModules table when choosing the Modules for
the Courses they're interested in. (likely done from a screen using
drop-down lists)

You would use the StudentCourseModule table to determine when the student
has fulfilled the course requirements. (a query to determine that each
Module for the Student has a CompletedDate).

That should get you started.


"Laurence Nixon" <ln****@ldnconsulting.com> wrote in message
news:3F***************@printnplay.com...

Hello all.
I am seeking ideas on how to determin a specific value with varied
parameters.

This will be for students who have taken modules in a course for
pre-certification. So it will be like this:

StudentA
ModuleA + ModuleC + ModuleD + ModuleE = (Completetion of this COURSE1)

StudentB
ModuleA + ModuleE + ModuleB + ModuleF = (Completetion of COURSE1)

If these values (Module??) were static then it really wouldnt be an
issue I dont think, but the model is based on electives chosen by the
student so a varying module sets should produce the completion of a
specified course.

How would I go about doing this within Access 2000, or is this more of
a VBA or VBS type problem.

Thanks all for there help in advance.