OK. I've had a quick look now. Just a couple of questions.
Are you using the 2 forms based on queries to input data or view data or both?
Is one person ever going to have more than one Career Progression form filled in? Same question for Training Tasks form.
My initial thoughts are that you've got your joins slightly wrong in your queries. If you right click on the join line in your query, click on join properties, the change choice 1 to choice 2 (Include all records from Personnel Info and only those from Career Progression where the joined fields are equal). Try searching for joins (in particular left join) on the forums for more info.
This means that the query will bring back everyone's records, even if they don't yet have any entries in the career progression table. That way you can use the form to add details for people without any already which you couldn't before.
At the moment your forms open completely independently, which means there's nothing to stop someone opening the career progression form and trying to enter details of someone who doesn't yet have a record in the Personnel Info form. This won't work because they don't yet have a SSN entered which you are using to link the records. That's something else to think about.
Another thing to think about is if you have two people with the same name there's no way of distinguishing between them by looking at your career progression and training tasks forms. You're using the SSN as your unique person reference, but you're not showing that on those forms. You don't necessarily have to show it on them, but it might be worth (and this relates to my previous point as well) thinking about possibly opening the career progression and training tasks forms from the personnel info form. That way you can tell it to open the form at the same person you're already looking at.
I hope this gives you a few pointers. If you still have problems with your original question, let me know and I'll look into it a bit further.
As for the other suggestions I've made, you'll find plenty of advise about those things on the forums. Normalization is also well worth reading up on. I'm not going to go into it here as there is loads posted on it already and there's a lot of people who have explained it much better than I could ever hope to (Pat Hartman for one).
Just one last point, it should be career, not carreer. I'm not saying that to be picky, I just know how frustrating it is to build an entire database only to find out later on that you've spelt something wrong all the way through it. It's not too crucial for your tables etc as no-one should see them anyway, but you might like to alter it on labels on your forms.
