This might be a lot to ask about
You got that part right and probably don't quite comprehend the scope of that work.
Speaking for myself, sometimes similar requests are fulfilled because it involves charity organizations, although I cannot recall such an involved charity request. However, you are running a business and would probably make better use of your time running that and leave such things to paid developers. That is because the Access learning curve is quite significant and db's made without adequate knowledge of Access usually end up being big time kludges. We're not here to create apps for everybody, we're here to assist with issues in ones that have been started already.
If you are determined to build your own, I'd suggest the following for learning the fundamentals. If you don't get normalization right you will continually have issues.
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
How do I Create an Application in Microsoft Access?
http://rogersaccessblog.blogspot.com...cation-in.html
Important for success:
Naming conventions - http://access.mvps.org/access/general/gen0012.htm
https://www.access-programmers.co.uk...d.php?t=225837
What not to use in names
- http://allenbrowne.com/AppIssueBadWord.html
About Auto Numbers
- 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
About Multi Value Fields - https://www.isladogs.co.uk/multivalu...lds/index.html
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.