Hope you are all well and getting geared up for the holidays.
I'm relatively new to access and am looking to either download a employee training database template, or, create my own.
I'm not 100% sure what access can do but i'm looking for the following (quite a big ask i think)
Employee details (ie ID, name, address, payroll no, establishment)
Training completion (not required, required, complete (date), refresher required (date - some will be yearly, some every three years) and possibly some flag for those overdue
I would also like to run reports on individual courses, individual employees, establishments etc, as well as by course status (ie completed, overdue, required)
Is this kind of thing possible, or does it already exist? I have all the data ready so know what fields are required. I just don't know where to start in creating it.
Thanks in advance