Sorry to say that your table design is all wrong - it's like a spreadsheet. Access (tall) is not Excel (wide) and you should not create tables that way (e.g. repeating data in fields - 1D, 2D etc).
My suggestion is to study and understand normalization. Then design the db schema. Even doing so on paper is a common approach by many db developers before diving in to table creation. One attempts to validate that design by working through scenarios. You could post a pic of your db relationships when done in Access for feedback, but be prepared for questions because understanding the process that the db supports is key.
If you don't fix the design, your problems will only continue.
Normalization Parts I, II, III, IV, and V
http://rogersaccessblog.blogspot.com...on-part-i.html
and/or
http://holowczak.com/database-normalization/
Entity-Relationship Diagramming: Part I, II, III and IV
http://rogersaccessblog.blogspot.com...ng-part-i.html
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.