Back to lesson
1. When relationships are created, be sure to check the _________________ box.
Cascade Delete Related Fields
Enforce Referential Integrity
Cascade Update Related Fields
2. When you create a relationship:
Data types do not have to match.
Access will always show it on the diagram.
Drag from the Primary Key in the main table to the Foreign Key in a related table.
3. When you make design changes to a table that is displayed on the relationships diagram:
Changes will show on the Relationships Diagram when you Save the table.
Close the relationships diagram and open it again to see changes.
Add the table to the diagram again to show the changes.
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement