A Nigtmare!

Hello,
I don't really know if this is possible! I was instructed to create a
database and one of the requirements is as follows, bare with me.

Table involved:
tbl Associate - associate ID, FirstName, LastName, StartStep, Program Start
Date

Query involved:
Certificates Earned - Certificate Code

Here is where it gets interesting!

This is for our training program at work. There are a total of 8 steps in the
program. Each step has a certificate. Associates must complete the
certificate plus have 6months of job experience for each step. Before the
associate starts the program they are required to take a placement test which
they can place out of the first five steps.Depending on where they place
(step1-5) is where there program start date begins. This date is every six
months (3/1/07 , 9/1/07, and so on) untill they have completed the program.

What I am needing to do is have the database see what the start step is,
begin the program start date, add additional dates for the remaining steps,
check which certificates each associate has earned and maybe color that date
field of that step or use a checkbox.

I am not sure how this can be done, form,report, I am lost.
I will provide more info if this is not clear enough. Any help would be great.
Thanks
GREG

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/200703/1