in Access you have to define those relationships manually if you want to force referential integrity.
You don't have to go to the relational view and create the relationships in access, but you can.
Same with MySQL. You don't have to create the foreign key relationships, but if you want to force referential integrity, you can.