Many-to-many Relationships in Access

In reality the relationship between the students table and the courses table is a many-to-many relationship, meaning, a course can be done by many students and a single student can do many courses at the same time. In MS Access you need to handle this relationship carefully by creating a link or join table. What is the job of this extra link table? It converts the many-to-many relation between Access tables into two easy to handle one-to-many relationships. You'll encounter such situations in many domains while creating tables and relationships. Therefore it becomes important to understand the concept thoroughly before moving ahead.
Now we use the database tools and its 'relationships' feature for converting the many to many relationship in MS Access to two one-to-many relationships after creating the third table.
Once the relationship has been properly converted we can use the power of the relationships to do interesting queries or create forms as shown in the training video. The form, of course, will be discussed in detail in the coming videos. Note here that we generally use forms to enter data into our tables.
In this video you'll also understand the importance of 'Enforce Referential Integrity' feature while creating relationships.

Видео Many-to-many Relationships in Access канала Dinesh Takyar