Creating a one to many relationship in a Access College Database

one to many relationships are the basic relationship of all relational databases. It allows database designers to split different entities of a system into different tables and then relate individual records with others in other tables. It is one of the foundations of relational databases as set out by EF Codd in the 70s.

[@vattanaktv5082]

Your explanation is straightforward, no bullshit, and very effective for us to catch the main points. You should be a professor.

[@QVisible]

Thanks!

[@ayazakhtarkhan7535]

great sir I understand completely and this is best Ms Access teaching Channel ever

[@niloofar3463]

i was struggling for an hour with this and finally found this video, omG perfect explanation and tutorial, thanks a lot

[@helennunnally1552]

I was totally confused! Now I know exactly how to perform these steps in Access and understand in my Database Mgmt. course. Thank you so very much!

[@CrochetCracker]

Thankyou thankyou thankyou. I have a database project to hand in Monday and I just wanted a simple two table relationship. I looked everywhere and you are just what I needed

[@QVisible]

Cool. Thanks!

[@omar2561999]

This video is so helpful.I will get better grades bec of you thanks very much.

[@mhreteabalemayhu3625]

Thanks a lot that is cool i will pass my exam

[@samdc3000]

God dam this is really fantastic, finally a great method of explanation of relationships

[@MegaJesseman]

3:50 is where it starts getting important.

[@AbdurRahim-ot5gp]

I highly requested you make stock control tutorial video from product table, customer table and suppliers in Microsoft Access.

[@antoinej.augustine2589]

this dude voice scares the living hell out of me

[@patrickbrefo642]

You are very good with explanation, made it easy to understand

[@narayansinghfacts7569]

Nice video

[@loneerwoof]

Thank you sir...its very helpful 💕

[@neerajmahapatra5239]

Wow you are really awesome dude....

[@QVisible]

Thanks for the love man!

[@Karicula2012]

Very nicely done

[@aailee0029]

Thank you so much it helps me a lot

[@nicoleoro6468]

Thank you for explaining this so well

[@anyzzas7149]

A very clear explanation. Thanks!!!

[@Josh2121ify]

Great video + explanation.

[@butrinthaliti2942]

Thanks man this was really helpful

[@user-ko7fl3eu5g]

Best education

[@bennyjagroop2688]

Thank you. Has the next clip come out yet???

[@ameliorategibberish8027]

Thank you! I only needed help from about 4:00 to 5:30, but it really helped!

[@cybilebenedict]

I hate access but my teacher forces me to use it! Clear video thanks!

[@QVisible]

What do you prefer instead of access?

[@balochx]

This helped me a lot. Thank you!

[@tishanyamckenzie7653]

Amazing Video!!

[@QVisible]

Amazing comment. Thanks!!

[@blungazz]

Thanks for this video. Big help.

[@ajwahijazi7070]

thankyou so much man you saved my life

[@QVisible]

ha ha...! sounds like the stakes are high! Thanks.

[@meliodasssds8833]

you helped me alot thx bro

[@shaukatali7665]

no doubt, it was really very helpful

[@GoodGuyGrasu]

I need help on how to place more than one course for a student, essentially making a many to many relationship and I don't know how. Would someone be able to guide me through it?

[@QVisible]

I have a video for this kzbin.info/www/bejne/iGi0knWnophlack

[@GoodGuyGrasu]

@@QVisible Thank you for your help. I managed to figure it out before I saw your reply and what I did is exactly what is shown in the video. Thank you again

[@neimael3182]

Thanks you

[@kylesurf321]

Good job wex good job

[@Jenmag1]

This does mean when you input the information in to one table, that it will impact the other table? Meaning that it will show up automatically ?

[@mannemvarshithrocks]

very nice thanks

[@parastooJoseph]

I've watched a lot of videos but you are the one who has explained all clearly , Thank you so much . I have one question , what if we want to design a table which every student can have more than a book ?

[@QVisible]

Thanks. Do you mean how does a student have more than one course? You will need to do a many to many relationship. I have a video about this. look for many to many.

[@parastooJoseph]

@@QVisible Yes . Thank you . I'll check it out now .

[@sujanmgr3359]

Thanks for remained....

[@niroshanbandara5147]

You should increase the volume. Everything else is perfect

[@LinhNguyen-xx5fg]

God bless you.

[@Ty-lp7ew]

Thank you help me a lot!!

[@Shortsfootball.2]

Thank you so much !!

[@nehasohu4576]

❤❤❤

[@Tayyhayrayyaymeem]

tomorrow is my paper and finally I made it!!!!!!!!!!!!!!!!!!!!!

[@shadazad4506]

thank you brother ;)

[@QVisible]

And you. Happy Christmas.👍

[@rm9994]

Thanks. But why not just put the course in the student table. Then there is no need to create relationships. Eg instead of Keith and then the number for physics (and then connecting to the course to the number) why not just write Keith and physics. It’s like if you write your name you don’t write your first name then a number for your surname and then create a relationship to find what name the number stands for.

[@chathurikadmd3771]

thank you

[@qurrat-ul-ainzaheer5533]

thanks u soo much it helped a lot

[@mayomayo9557]

Beautiful! Other videos are too long and not to the point

[@hriday.m8015]

Thank you 😊 a lot

[@kileford2297]

Can you rename the relationship from Relationship to something else?

[@QVisible]

Are you talking about the relationship view?

[@TheKhan9191]

thank you very much

[@kemieshaforrest5601]

may i ask where is the previous video wanna see from start

[@QVisible]

Hi. Here is the previous video: kzbin.info/www/bejne/sGeYZnuFmZeaftU

[@Limited00]

Cool voice :)

[@rehabzaidalzahrani1976]

thanks teacher

[@michaelwalters4749]

Im building a very tiny database, and what I am doing is adding each different blend of tea and herbs I can find, and attributing properties to it. For example, lavender is soothing, and also clarifying. I want something where I can match these keywords to the herb/tea. How can I go about doing that in a one-to-many?

[@QVisible]

+Michael Walters it would be better to do this using a many to many relationship. I have another video somewhere on my channel that deals with this. This will allow a property such as soothing to be related to many differt herbs. But also can allow a single herb to be related to many property's.

[@tec9820]

respect brogad

[@QVisible]

Thanks.

[@praladyadav900]

nice vd

[@naziajasmeen4203]

thanx!

[@mc-eu8sr]

Thanks

[@tanishgupta783]

It helped in cca

[@QVisible]

Yes!!!!! Thanks for coming back!

[@Tayyhayrayyaymeem]

thanks

[@rajmandal9143]

thnx

[@manlikezakaado6135]

Can I make a relationship between a table I created in excel and another one that I created in access

[@QVisible]

not that I know of.

[@manlikezakaado6135]

Now it's working perfectly ,Actually it was refusing the different tables that I created from excel and access Thank you

[@jordanhuusy]

"Ironclad"

[@geraldvinuya340]

I have a ms access database.mdb I need to change the location my access database, i used link table manager, i need to change by 192.168.1.1 by mapped network, can you help me thanks

[@QVisible]

Sorry. I don't know about this. mdb is an old format. It may complicate things.

[@boost321gaming6]

i cant choose on to many or many to one why

[@QVisible]

It all depends on which table holds the primary key. This will always be the 'one' part of the relationship.

[@boost321gaming6]

@@QVisible yes i know but my problem is it doesnt tell me one to many or many to one it tells me intermediate

[@rishimalhotra7331]

Thankssssssssss

[@ash81818]

3:48

[@Energysunn2215]

Anyone watching this because of GCSE ICT?

[@QVisible]

+ERIC SUN are you studying for a practical? When is it?

[@-o-itscharli]

A-level now

[@nikolarakita2401]

Narrated by Arnold Schwarzenegger xD

[@dangerousxyzgamer]

Jjd

[@rcnut5112]

didn't help me with class project

[@QVisible]

What was your class project 🤔?

[@Abudursh]

lovely Simple & Clear U R SO Nice gay thankx Remained

[@locust25VI]

holy shit your voice

[@QVisible]

+LocustHD Good or Bad? :-)

[@locust25VI]

good

[@jasminstrozier9831]

African? :)

[@CoreReaper1]

helpful but speak up.