Access Access 2007 How to create a roster

Joined
Oct 29, 2012
Messages
3
Reaction score
0
I have a db table with a list of employees. I have a form to enter the employee and all of their training requirements, it also contains a calculated field. The calculated field checks all of the employees' training req's then returns with a "yes" or "no".

I want to build a roster that I can bar code scan the employee's badge into. I want the person scanning people in to automatically see if the employee is a "yes" or "no" by auto checking that calculated field in the form.

I know i can't have the result of the calculated field stored in my table (though i would like to for this purpose).

Any thoughts on how I should build this roster? Should I use excel or access? Is it even possible to build such a thing? I do not have a lot of experience with programming. Thanks for any help.
 
Back
Top