nutshell: Access expects denormalization.
Anything "more complicated" (which, to the experienced developer, is actually less complicated), doesn't fit built-with-a-wizard-cut-n-paste forms.
Many fears are born of stupidity and ignorance -
Which you should be feeding with rumour and generalisation.
BOfH, 2002 "Episode" 10