Hi, new to the forums, but have been browsing here for awhile. Would consider my self a beginner Access user.
I have a question I was hoping I could get some assistance with(access 2013).
I'm working on a database that stores information concerning mandatory training employees must complete.
Separate tables exist for Students, Instructors, Training Topics, and Training Completion information
Some, but not all, of the mandatory training requires the generation of a training certificate upon completion.
Let's say that I have 10 Training Topics that require a certificate when complete.
What I would like to do is have a form with 10 checkboxes, each one of which would be true, or "checked" if a training subject were complete.
For example, if a student completed 8 out of the 10 trainings, 8 checkboxes would become "checked", I could then print a certificate containing the information related to the 8 checkboxes, and the students would get a second certificate once they completed the remaining tasks.
So lets say the student/completed a training called "Orientation", it was recorded in a table, how could I get a checkbox to reflect "true" for this condition?
Thanks in advance.