I am posting to seek your expertise and input regarding the creation of a training tracking base that will be solely dedicated to tracking training completion dates and outstanding employee training. With approximately eighty employees and thirty distinct types of training courses, it is essential for us to establish an efficient system that automates this process as much as possible.
The key requirements for the base include:
- Tracking completion of training courses on a yearly, bi-yearly, or quadrennial basis, based on the completion date of the respective training course.
- Minimizing the number of fields to avoid unnecessary complexity.
- Automatically resetting the due date after an employee completes their training.
- Keep employee records of the last training complete for the specific course.
I am currently in the process of determining the optimal design for this base, but I would greatly appreciate your insights and suggestions. As I am starting from scratch, any ideas to streamline the base design would be invaluable. I am guessing this would be similar to a subscription style base, but again trying to avoid additional work as I normally create extra work myself while designing, and then later realize that I could have made this much simpler with fewer fields and better formulas.