How about I just throw everything out here given that I suspect it will all be news. Start with the normalization. If it doesn't sink in, find your own links that 'speak' to you. If you do not grasp normalization you will always struggle. I'm not saying you have to be a wizard at it, just understand enough to succeed.
Normalization is paramount. Diagramming maybe not so much for some people.
Normalization Parts I, II, III, IV, and V (make sure to follow the links - they're not obvious)
Thoughts, opinions, samples, tips, and tricks about Microsoft Access
rogersaccessblog.blogspot.com
and/or
holowczak.com
Entity-Relationship Diagramming: Part I, II, III and IV
Thoughts, opinions, samples, tips, and tricks about Microsoft Access
rogersaccessblog.blogspot.com
How do I Create an Application in Microsoft Access?
Thoughts, opinions, samples, tips, and tricks about Microsoft Access
rogersaccessblog.blogspot.com
Naming conventions
-
http://access.mvps.org/access/general/gen0012.htm
-
https://www.access-programmers.co.uk/forums/showthread.php?t=225837
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
About Multi Value Fields -
http://www.mendipdatasystems.co.uk/multivalued-fields/4594468763