Training Tracker

[Fireman Joe]

Hello,
I need to set up a tracking system for Firefighter Certification Classes. I
have a "Firefighters" Table; Classes Table; Certification Table. Each
firefighter takes many required Classes to achieve a Certification. There are
many Certifications that each Firefighter is in the process of or has
acquired.

Firefighter Table: name, address, etc with a FirefighterID as the primary key
Classes Table: ClassID as primary key, Class Description; CertificationID
from Certificaton Table
Certification Table: CertificationID, Certification Name

That is where I get stuck. Here is what I ultimately want to know.

I want to know each class and completion date that a firefighter has taken
in each certification track. I want to know which class they still need in a
certification track. I want to know which classes would benefit the most
firefighters.

Any suggestions would be appreciated.

Thanks

 

[John W. Vinson]

Hello,
I need to set up a tracking system for Firefighter Certification Classes. I
have a "Firefighters" Table; Classes Table; Certification Table. Each
firefighter takes many required Classes to achieve a Certification. There are
many Certifications that each Firefighter is in the process of or has
acquired.

Firefighter Table: name, address, etc with a FirefighterID as the primary key
Classes Table: ClassID as primary key, Class Description; CertificationID
from Certificaton Table
Certification Table: CertificationID, Certification Name

That is where I get stuck. Here is what I ultimately want to know.

I want to know each class and completion date that a firefighter has taken
in each certification track. I want to know which class they still need in a
certification track. I want to know which classes would benefit the most
firefighters.

You need another table: Attendance let's call it. This would have fields for
FirefighterID, ClassID, DateTaken, and perhaps a comment field or a yes/no
"passed satisfactorily" field or any other fields you need to record this
person's interaction with this class.

YOu could then create queries joining these tables to see which certifications
each person has completed, or use the Unmatched Query wizard to see which they
haven't.

John W. Vinson [MVP]