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"
The information about this is stored in the "Relationships Window"