Access 2007 Demo: Set the relationship between 2 tables

See more Microsoft Office Access demos at http://office.microsoft.com/en-us/help/FX100485311033.aspx If you use table relationships in your Office Access 2007 database, you can enter new data once and then use this data in the other tables of your database. You won't have to worry about updating other tables when you change the data in a record that is related to those tables.

Category:

Science & Technology

Tags:

• Microsoft
• Office
• 2007
• training
• access
• databases
• relationship
• relational
• data

[videogaga999]

One 7min video made me understand relationships in Access and how to go about do it which 2 days of reading didn't allow me to do...

[Rodney1953]

great job. very helpful!

[bundaeggi]

Richard Stallman must have seen this video... ;-)

[rexcro]

Thanks from Croatia!

[KnightsEyes]

Plain spoken and easy to understand. Thanks for the assistance.

[marriyumh]

Thanks you! xx

[Tubekickass]

very helpfull thanks alot :)

[bestoOofriends]

OMG .. you are so right ,, the stupid man that came to examen us at access told us to make both fields at the new table FK ..and told us that it's wrong to make them pk and his excuse was that we cant add the same student to the same class as you did ,he said that because we cant do that it's wrong to put them PK ..we kept telling him he was wrong but he wont listen !! he told us to make them us FK

[gulkickonmyass]

sexy voice....sexy explained.....thanks

[Phoerocks]

thatnks great video :) but umm the hilariously long student names??? XD