Employee "who has what" training

[dezenzerrick]

IHi everyone. I am joining this forum to expand my knowledge and skills with database programming.


I've been tasked by my employer to build a database that can display every employee, their training, and generate reports based on a search.
We purchased (or downloaded from somewhere) a template that covers the first requirements. Currently, I can type in an employee, enter their training, where they trained, the date it starts/expires, etc etc. The template also allows us to search by training to see who has that training attached to their file.

What I am to do is to create a separate form that tells me which employees still need to take training.
For instance: John has Fire Evac training, but Bill doesn't. I know that bill doesn't have the training because I entered all of the info in. But it isn't efficient for our safety manager to search each employee and say "he/she doesn't have this/that training." A form that says "here are the people with fire evac training, and here are the people without."

I understand very little about Access, but I can learn. If someone could offer advice or assistance, I would be greatly appreciative.

[pbaldy]

Create a query of who does have the training (you can use a parameter query so you can check different items). Then use the unmatched query wizard to compare that query to the employee table.

[dezenzerrick]

Noob question - how does one make a parameter query?

[pbaldy]

I would create a form with a combo box of the courses, and have the query criteria refer to that form/combo. You can use the Build functionality to get the syntax, or:

Forms Refer to Form and Subform properties and controls