IMHO, you need to research normalization and some other basic, but very important, design principles and post back in this forum. Either start a new thread and link back to this one, or continue on with this one, the idea being to post your schema in some way. However, unless they're prepared to allow you a long learning and development curve, you are looking at a lengthy process to do it right. If you need to campaign for change, you'd better come up with a new and better wheel lest you damage your credibility and deeply entrench those who like the status quo. Your comment about simply transporting a spreadsheet to a table says to me that you don't grasp the difference between Excel (column based data) and Access (row based). If you do not grasp the entity/attribute relationship and forge forward, I believe you will fail (sorry). Also suggest you look for existing database templates/models and see if any are similar to what you need. With any luck, you might find one that's usable out of the box. If not, they can at least help to make sense of that relationship. Try some of these links, or search based on Access database design, etc. and then maybe post back with a schema. A very good approach to design is, believe it or not, pencil and large paper.
Data models
http://www.databaseanswers.org/data_models/
Normalization is paramount. Diagramming maybe not so much for some people.
Normalization Parts I, II, III, IV, and V
http://rogersaccessblog.blogspot.ca/...on-part-i.html
and/or
http://holowczak.com/database-normalization/
Entity-Relationship Diagramming: Part I, II, III and IV
http://rogersaccessblog.blogspot.ca/...ng-part-i.html
How do I Create an Application in Microsoft Access?
http://rogersaccessblog.blogspot.ca/...cation-in.html
Important for success:
One source about how to name things - http://access.mvps.org/access/general/gen0012.htm
What not to use in names - http://allenbrowne.com/AppIssueBadWord.html
About Auto Numbers
- http://www.utteraccess.com/wiki/Autonumbers
- http://access.mvps.org/access/general/gen0025.htm
The evils of lookup fields - http://access.mvps.org/access/lookupfields.htm
Table and PK design tips - http://www.fmsinc.com/free/newtips/primarykey.asp
About calculated table fields - http://allenbrowne.com/casu-14.html
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.