How to create relationships in Access 2010

A relationship between tables in an Access database, is a link enabling records within different tables to reference each other.

We can simplify our data recording and entry by creating separate tables and create relationships between these separate tables so that they can reference each other. This will reduce the amount of data stored, entered and minimise opportunities for data entry mistakes.

If you have any questions regarding this video please leave a comment.

[AmaanNaidu]

thanks it was very helpful for my project

[trippyadapt]

hi phil great video! i liked the way you made the use of media, such as audio, text and editing techniques the video was very enjoyable

[amritasarkar]

Thank you so much for this video . Love' from India

[tootrue]

Hi Phil, great video! Thank you so much... One question though: When dragging the primary key from the "parent" table for the purpose of establishing the relationship between tables, does there already have to be an associated foreign key field in the "child" table to drop it on? Or is it possible to create a foreign key in the child table merely by dropping the primary key somewhere in the child table's box?

[quintuckyy]

finals about to start in 1 hour. about to clutch this mf

[khakalijoy]

Àaah what if you don't have same items in those tables how will you do it??

[gulshanharode]

Relationship Ko hatana Hai To kaise hataye