Understanding Microsoft Access Relationships And Foreign Keys
This video tutorial (less than 2 minutes) explains the very basics of what Microsoft Access relationships are focusing on the foreign key and where it can be used.
Microsoft Access Relationships With Foreign Keys
Microsoft Access Database – My Thoughts About Microsoft Access Relationships With Foreign Keys
Using the foreign key can be used in several ways not just as the video tutorial demonstrated. It’s also used to mark any field in a table to be indexed for your Access formula query calculations and setting criteria too.
When dealing with Microsoft Access relationships, you are now applying indexing too which speeds up your queries and reports. The foreign key is indexed as ‘Duplicates OK‘ in the property settings from the design view of an Access table.
Want to learn more about Microsoft Access relationships? Take a look at my eBook on Understanding Access Database Relationships (RDBMS) – Joining Tables.