Solved Normalisation

[Gasman]

Micron on here posted a few links on another site, the first one being for Normalisation, which Excel users to come to Access have never heard of.
He also posted a good few other links.

Rather than post to his original post (as it is on another site) anymore, I am posting them here and so will refer to this post from now on.

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

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

 

[DickyP]

How you can build any database without proper design planning including RDA defeats me, and is regularly the core problem with items on this site!

Reminds me of the old Two Ronnies country yokels sketch who when asked for directions reply with "If I was going there I wouldn't start from here".