I have a table that shows all employees who were trained and what classes they took. Each area requires a different set of trainings and I need to create a query that identifies who is qualified for what area. Also an employee may have taken a class twice. Two questions. What is the best way to set up the table(s) for the list of trainings and how do I build the query?

Employee table

Name1 - Class1
Name1 - Class1
Name3 - Class1
Name4 - Class1


Name2 - Class1
Name1 - Class2
Name3 - Class3
Name1 - Class3

Area 1 requires class 1 and 2
Area 2 requires class 1 and 3
Area 3 require class 1, 3 and 5

I want a return of
Name1 - Area1
name1 - Area2
Name2 - Area2


I have over 25 classes on the list and about 15 areas to work in
Thanks