seeking ideas on how to determin a specific value with varied

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.