3 ms·
I learned by doing queries in Microsoft Access 2000, then looking at the query in "SQL View". The nice thing about Access is that it managed table relations for
by mikewarot 6y ago
I learned by doing queries in Microsoft Access 2000, then looking at the query in "SQL View". The nice thing about Access is that it managed table relations for you, so master/detail tables are almost trivial.
- stevedh 6y agoBit of a nitpick. Relations are another name for the tables, relations are not the joins between them.
- mikewarot 6y agoIf 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 6y agoYes I'm familiar with it. What I'm saying is that : relation = table. join = relationship.