I think you're struggling because you don't understand normalization, or at least, you're not applying it here. What you show looks like a spreadsheet, which is column based data layout while Access is row based. You might need tables for bag types, items, locations, bagItems and bagLocations - the latter 2 being junction tables. The old maxim is worth repeating - if you can't design it on paper so that it will work, you can't build it in Access. In other words, you need to be able to put your vision on to paper first. Maybe start here
Normalization Parts I, II, III, IV, and V
http://rogersaccessblog.blogspot.com...ng-part-i.html
and/or
http://holowczak.com/database-normalization/
or find other sources that you like better. You could post back with your suggested design or just go for it.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.