Microsoft Access Database: Understanding Microsoft Access Relationships And Foreign Keys

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.

This entry was posted in Database Theory, MS Access, Tables and tagged , , , , . Bookmark the permalink.

One Response to Microsoft Access Database: Understanding Microsoft Access Relationships And Foreign Keys

  1. ben beitler says:

    Using primary and secondary (or foreign) keys are often over looked which can help with running and sppeding up your reports.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>