[stevedh]

Bit of a nitpick.

Relations are another name for the tables, relations are not the joins between them.

[mikewarot]

If you have a master table with detail records, access just handles it, you don't have to do any SQL yourself to be able to just have a form that accesses them and lets you do all the CRUD operations.

The information about this is stored in the "Relationships Window"

[stevedh]

Yes I'm familiar with it. What I'm saying is that :

relation = table. join = relationship.