I was wondering if anyone could help. I have been looking around the net for good websites/articles that explain, with examples, the above clearly and simply.

I am looking into constructing macro groups using the automated macro function in Access and want to set these up properly (using StopMacro etc.).

Also regarding Relational Database Design theory, a good explanation of Join Types (1, 2 and 3 - one to one, one to many, many to one) as well as Referential Integrity (including Cascade Update and Delete).

I have noticed even some IT graduates having problems with Access databases, so would like to sort this out!!!!!