Query to find select columns in several tables....Help!

Here's the situation: I have 22 personnel. Each is in a different category
(Enlisted Air Force, Enlisted Army, Officer Air Force, Officer Army) Each
category has different training requirements. Please note that in my
Personnel Table, each person is actually assigned to one of those categories.
(Hoping that it might be in some way helpful to finding a solution)

What I've done: I created 5 Tables.
Table 1: Personnel Data. The key field is Social Security Number. It does
include a dropdown selection of the 4 categories mentioned above.
Tables 2, 3, 4, and 5: Each one is a different category of training. I
entered the field headings as the course titles, with Yes/No to track
training completion. I did use an ID index, but all tables are linked via
SSN to the Personnel Data table.

I 'assumed' that when I maximize the little '+' sign in the Personnel Data
table, it would show me the record in either of the 4 training tables that
had that person's SSN in it, and only the record from the specific table. I
was wrong. It is requiring that I only pick one table to link to the entire
personnel table. The problem with this is that then I lose the other 3
completely different training requirements tables!

There is not SO MUCH training (maybe 20-25 courses in total) that I cannot
consolidate into one table. The problem is that I need to know what is
required in addition to what is completed. (maybe to a 'training course 1
required, training course 1 complete?) I thought by doing it this way, the
SSN in the table would require that training for that individual, and the
yes/no within the table would indicate if it were complete or not.

How do I get my data back out?!?!?! I'm hoping for something like this:
SSN1, Last Name1, First Name1, List of required courses and completions
SSN2, Last Name2, First Name2, List of required courses and completions

I though a query might work, but I'm only getting results with ALL of the
data or only the ones completed by the individual (yes checked)