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