Microsoft Access Beginner 2, Lesson 04: Intro to Relationships, Primary & Foreign Keys, More

In Lesson 4, we will get an introduction to relationships, one of the most important features of an Access database. We will learn what relationships are, why we want to use them, and about the different types of relationships. We'll learn about primary and foreign keys. We'll build a table to track appointments for each customer. We'll learn how to set default values using the Now and Date functions.
NEXT LESSON (05): • Video
PREVIOUS (03): • Microsoft Access Begin...
TOPICS COVERED
Why Relationships
Relationship Types
One-to-Many
One-to-One, Many-to-Many
Primary Key, Foreign Key
AppointmentT Table
Default Value
Date() Now()
Multiple Appointments per Customer
FULL FREE COURSE PLAYLISTS ON KZbin:
Access Beginner 1: • Microsoft Access Begin...
Access Beginner 2: • Microsoft Access Begin...
FULL COURSES ON MY WEB SITE:
Access Beginner 1: 599cd.com/ACB1
Access Beginner 2: 599cd.com/ACB2
ADDITIONAL RESOURCES:
Get on my Mailing List: 599cd.com/YTML
Consulting Help: 599cd.com/Consulting
Twitter: / learningaccess
en.wikipedia.org/wiki/Microso...
products.office.com/en-us/access
microsoft.com/en-us/microsoft...
Contact Me: 599cd.com/Contact
BECOME A MEMBER:
KZbin: / @599cd
or My Site: 599cd.com/THMember
KEYWORDS:
microsoft access tutorial, #msaccess, ms access, access 2016, access 2019, access 2021, access 365, #msaccess, #microsoftaccess, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, relationships, one-to-many, one-to-one, many-to-many, primary key, foreign key, appointment table, default value, now, date
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[@SheriOrloff]

I'd like the next lesson, please. These lessons have been incredibly helpful! Thank you for your largesse.

[@bestswimmer1916]

I would love more lessons. I love your teaching style. I have learned more from your KZbin videos than I learned in an entire quarter of database architecture. Thank you so much!

[@599CD]

Happy to hear that!

[@MiamiHeat872]

I noticed you got a lot of similar comments, and I just wanted to post so you know not all comments are mindless. I tried using the Access Bible for learning, but your method and teaching system is just so much better than reading a book and much more thorough and in depth compared to all the other videos on KZbin. So, thanks for your system!

[@599CD]

Thanks! I appreciate your kind words. I love the Access Bible. For many years it was my goto reference guide (before Google). I even did a review of it: kzbin.info/www/bejne/enLVeHairLSWgqs

[@malumokawewa7735]

I've watched all level 1 videos can't wait to watch begginers level 2 videos

[@599CD]

:)

[@stephenbeswick2163]

I would the next lesson please thank you, steve

[@599CD]

You got it

[@timbo4127]

Videos are excellent.

[@599CD]

Thanks

[@christophermckissick2089]

Awesome work. I’d like the next lesson please.

[@599CD]

You got it!

[@colinhursell9176]

I’d like the next lesson please.

[@599CD]

K

[@user-vh6uo2el7r]

Many thanks for you. I'd like the next lesson please.

[@599CD]

You got it!

[@shahramahmadzadeh5285]

I Would Like The Next Lessons Please

[@599CD]

K

[@Ravdspoel]

i would like the next lesson

[@gabornagy3984]

Awesome series! Can I have the next one, please?

[@599CD]

Sure!

[@nirmalkoonoolal9764]

Well explained. I'd like the next lesson please.

[@599CD]

Thx

[@gregoryjeffries8475]

I'd like to see the next lesson please.

[@599CD]

K

[@perthomsen8274]

Thabnk you! Next level please!

[@599CD]

K... you don't have to ask after EVERY video. :)

[@adamdeliso8100]

I’d like the next lesson please! Thanks

[@599CD]

You got it. As a member, you know you get Level 2 free and one additional level free each month, right? Sign up on my web site at 599cd.com/YTFU

[@stevencracknell6204]

I would like the next lesson please. Many thanks

[@599CD]

YW

[@hwykat]

Awesome I'd like the next lesson please.

[@599CD]

You got it!

[@malumokawewa7735]

I've watched the video would like to watch the next video please💜🙏

[@599CD]

K

[@ahmedkamon9123]

You are so generous. I'd like more lessons ,please.

[@599CD]

K

[@ahmedkamon9123]

@@599CD 'k' what does it mean ?

[@599CD]

@@ahmedkamon9123 short for "OK"

[@golfrep2584]

I'd like the next lesson please

[@599CD]

K

[@philipmcdonnell7168]

Many thanks for the lesson, Richard. My master form is packed with foreign keys and I can see the case for even more if I use modal forms to tidy the design. Can I have the next lesson please?

[@599CD]

Yep!

[@michaellallement1435]

I would like the next lesson please

[@599CD]

K

[@angelapadilla-morrow1042]

id like the next lesson .

[@599CD]

K

[@sandicushion2939]

I'd like the next lesson please?

[@599CD]

You're a member. You get it free on my website. :)

[@craigwhitthread3050]

Superb. 11/10. Please may I have the next lesson please :-)

[@599CD]

Very soon!

[@NFAtoys]

Please add the next lesson Richard

[@599CD]

K

[@samerra5453]

I need the next lossen please

[@wacelhamani]

great

[@599CD]

Thanks

[@mohammedosmankhan3857]

Please let me know can I share the form which I created in Microsoft access to get the data collection from team

[@599CD]

599cd.com/Surveys

[@lion_0077]

Hello sir, I learn many things from you in access,now I am learning Python from other tutorial, but I eagerly want to learn python from you. If you kindly please considerate our request(so many of students like me), because I find that almost VBA and python language is same so kindly please if you try to learn us a python it's very helpful to us, and I am dame sure that python language is not difficult for you!!! we are so many students eagerly want to learn python from you because you are great teacher!!!!!!

[@599CD]

I might do something with Python in the future. Next time, please don't post the same comment on 4 of my videos. That's annoying. I'll see it no matter where you post it.

[@lion_0077]

@@599CD Ok, thanks for your reply and I noted your point, Sorry for the trouble you!!!

[@AH_World_bh]

Next lesson please

[@599CD]

K

[@fredrudolph3301]

next lesdon please

[@599CD]

You can find level 3 at 599cd.com/ACB3

[@carliecumner2100]

What if I don't want to use a Combo box to select the customer either? What if I'm looking at a customer record and I want a cmd button to open an appointment form which automatically fills in the foreign key number for me?

[@599CD]

That's coming. If you're in a hurry: 599cd.com/FormName

[@tutsecret499]

Which video name where you show I think you wanted to edit the unique ID, you copied all the child table and paste on the side, then you did something with the ID editing, then you grabbed the child data you pasted somewhere, and you put back. What's the name of the video, I lost it. One time I had a database already input a lot child data, then the person came to me saying they gave me the wrong number ID of the case like 1000-01-9530 and they wanted me to change to another # 1000-01-9529. When we manage to edit the ID is a kind of cheating?

[@599CD]

No idea... post in my Forum... maybe one of the guys remembers it... 599cd.com/Ask

[@ghost21flare]

I would like the next lesson please

[@599CD]

K

[@erikamartinezhernandez9855]

I would like the next lesson please

[@599CD]

K. It's up there. :)

[@599CD]

You're a member, so you get it for free... make sure you set up your account on 599cd.com/YTFU