Re: Ideas on how to determin a specific value with varied parameters

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" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> 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.
>
>
>