Microsoft Access A to Z: Relating tables

This short screencast covers the steps necessary to relate tables together in proper one-to-many relationships in an Access relational database. It discusses how to determine proper relationships in the first place, how to create primary key fields, the use of the AutoNumber data type, the role of the primary key field in a table, and how to create foreign key fields. Both existing relationships as well as new one-to-many relationships are examined and created.
All of my TH-cams can be found at: learncs.w3spaces.com/

[@erinkavanagh3553]

Thank you for the review.

[@lfriedrichsen]

You're welcome! You can find all of my TH-cams organized at learncs.w3spaces.com/

[@dwihpjavas]

nice,great n simple explanation Lisa. foregin key also you mention, and ofcourse thats same important. when most explantion is just say Primary Key only.

[@lfriedrichsen]

Thank you for the comment. I should have thanked you a long time ago. See all of my TH-cams organized at learncs.w3spaces.com

[@Cracktune]

Fantastic stuff!

[@lfriedrichsen]

You're welcome! You can find all of my TH-cams organized at learncs.w3spaces.com/

[@paolaj.6618]

Hello Lisa ! This is a great course, very clear and well explain, thank you for doing this. I have a database related question regarding the foreign key on the contacts table, if the contacts tables is already populated with data how do I populate the CompanyID column that was just created in order to have accurate information? Does this needs to be manually done or outside Access and then upload or it can be populated with the related Companies table?
Thank you in advance for you time, much appreciated.

[@lfriedrichsen]

You'd have to manually enter the CompanyID for each contact record. Sometimes though, you can sort or filter the data to put the contacts together that belong to the same company so that you can update the foreign key CompanyID field faster. For example, if the contacts for a particular company all had the same email suffix you might be able to isolate the contacts for each company in a query and then use an update query to update the CompanyID field value. Good question. Good luck.

[@paolaj.6618]

@@lfriedrichsen Thanks !

[@SmartLearningAI]

Cool Video. Btw, how to draw those red boxes (live?) or post recording?

[@lfriedrichsen]

I use Camtasia to capture the screen and narration. Camtasia allows you to edit the video and add callouts such as text, arrows, and the red boxes.

[@constantine8601]

any practice files ?

[@lfriedrichsen]

For practice files, I'd recommend you get this textbook, authored by me. It's a comprehensive explanation of Access and each chapter comes chocked full of practice exercises and practice file files covering a wide range of relational database applications.
www.amazon.com/Illustrated-Microsoft-Office-Comprehensive-MindTap/dp/0357025695/ref=sr_1_7?dchild=1&keywords=friedrichsen+microsoft+access&qid=1618076995&sr=8-7

[@lfriedrichsen]

You can also go here to find many sample databases including the Northwind database: onedrive.live.com/?authkey=%21ALpFwFQS2oqbV1E&id=CACFB37191B18A79%21137&cid=CACFB37191B18A79

[@geraldteigrob2683]

@Lisa Friedrichsen Do you have the files necessary for following this textbook? How do I access those files? Thanks.