Note your goal should be to get the information displayed how you want in a form, not on the table. You don't want to be just messing around working in the tables, something bad will happen accidentally eventually. So on a form, you would use a Relational Combo to display the name rather than the ID.

Also refer to Evil Access Stuff, lookup fields are not good, again with working directly in the tables, use relational combos on forms instead.

Yep - What Adam said.
You as the developer can see the tables.  Tables are for storage.  It is your job to make it look pretty for the End-User.
Forms, Queries, and Reports are how you show the end user stuff.

From the images above many of your problems have to do with your field names.  See the stuff on Naming in the OTHER POST

I know it seems counter intuitive, but now that you are seeing these issues and what happens, I think you would really find value in going back to the beginning of the courses and going through them again.
Even if you play them at a faster speed.  You will pick up so much that went over your head the first time you watched them.
Like NOT putting spaces in field names. ---Silly Rabbit, Spaces are for Labels (and TRIX are for Kids) ;)

Thanks guys, I am trying to break the thought from excel spreadsheet. I have already started back at the beginning. I too think I need to watch that series again. Thanks