Question Access Training Database

[Mark_]

If I were to not worry about the revision on the actual training document and just modify the date when a revision occurs, could I then create a conditional format (like in excel) that would highlight/ red flag any employee that needs retraining?

Thanks in advance!

Yes, but I personally wouldn't recommend doing this.

You can have a query return all classes. This query would be joined to your "Version" table (child table) to return the latest version date (top 1). This does what you are asking for, but still allows you to keep your version history.

 

[AGNewton5]

I think that I may have all the tables that I need to begin this process. I am very new at this and was hoping to get some pointers as to what I need to do next. Any help would be greatly appreciated.

 

[AGNewton5]

That wasn't quite what I meant. What I meant was that when you were defining which courses were required, you would do it at the course level. However, when someone completed the training, you would log it as the specific version.

I don't know what prompts you to look for new training, maybe, once per year, you run a query that finds everyone who has any outdated courses and schedule them to take the new version. Maybe, whenever you add a new version, you trigger producing a list at that time and scheduling all people who are required to take that master course, to take the new version.

I wasn't sure what I would do in order to trigger when retraining was needed. We currently retrain all employees after 5 years. Often times one of the many training classes that are required for a specific job is revised. When that happens, all Employees need to retake that specific class even if the 5 years isn't up.