Office 2010 Class #43: Access One To Many Relationship Between Tables

Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn216.htm
This video goes with the Highline Community College Busn 216 Computer Applications Class Access 2010.
Topics Covered In Video:
1. Join Two Tables In Access
2. Create Relationships One to many
3. Enforce Referential Integrity
4. Jokes about the Relationship Window in Access

Category:

Science & Technology

Tags:

• Office
• 2010
• Access
• Mike
• Gel
• Girvin
• excelisfun
• Highline
• Community
• College
• Ron
• Davidson
• Computer
• Information
• Systems
• Busn
• 216
• Applications
• Class
• Join
• Two
• Tables
• In
• Create
• Relationships
• One
• to
• many
• Enforce
• Referential
• Integrity

[xmcMaEc]

@ExcelIsFun Mike, what if I have 2 columns that will define an ID? how can I create relationships for that? joining 2 columns in table1 with 2 columns for table2?

Thanks in advance!

[ExcelIsFun]

@xmcMaEc , I do not know. The only place I know to ask Access questions is:

mrexcel [dot] com/forum

Then click on the Access forum

[Pyarapradip]

Sir,I could only find this video on msaccess. Have you created any channel or play list for access as welll. If yes request you to let me know the same. Just to let you know that i have been following your channel since a year atleast. I really appreciate your hardwork in creating those videos and uploading it for free for the world.

Thanks a ton

[ExcelIsFun]

I am glad that the videos help! That is why i post them. I have 8 Acces videos. Search for:

Office 2010 Class #41

Office 2010 Class #42

Office 2010 Class #43

Office 2010 Class #44

Office 2010 Class #45

Office 2010 Class #46

Office 2010 Class #47

Office 2010 Class #48

[FiveBlackGuyz]

You saved me! Thanks!

[ExcelIsFun]

Glad it helped!

[YinlunUsa]

Thank you! This is great!

[ExcelIsFun]

You are welcome!

[ExcelIsFun]

I know, I know, but it is funny. I always get a good laugh when I do it live in class...