I noticed that nobody answered. Your problem in your approach may be the
same one in your post.....you completely skipped over the important stuff.
Turn the computer, Excel and Access off and start by making a list of the
real world entities that you want to database, and of any relationships
between those entities, and then decide your entity situations (One to one,
one to many, many to many) on each side of those relationships. Then design
your table structure from that list, or tell us about if so we can help.