Hello, World!
By no means am I an Access expert but I've used it in previous roles and I know it's quite powerful. I have to send notifications to 165 managers that they have specific team members who are out of date on certain trainings. All 165 managers email me back with notes like "this person left the company, that person is on leave, the third just completed the training." In total, I have almost 1,000 records, so you can imagine how stressful it is to keep all of this up to date. I think its going to be much easier for everyone to self-manage their team's compliance responses.
Can I use Access to:
(1) hold a "primary table" that has all the pertinent data for each record
(2) assign each manager a 4-digit "passcode." The pass code will be useful for the next step
(3) create a single form where the manager inputs their passcode and presses a "Run" button which retrieves all the records (team members) under them, show what training their out of date on, and a combo box to disposition that training, options being "Incomplete (the default), Complete, Exempt, On Leave, and Separated."
(4) once the manager dispositions each record, they hit update, this updates the records in the primary table's "disposition" column, if they close out and come back in, and hit run, the new dispositions should show/be saved
(5) I can then run a few reports, one for each disposition, so I can then tell the appropriate parties to update their records for employees who have left the company, are on leave, etc.