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.

[@ayazakhtarkhan7535]

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

[@vattanaktv5082]

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

[@QVisible]

Thanks!

[@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!

[@omar2561999]

This video is so helpful.I will get better grades bec of you thanks 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!

[@samdc3000]

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

[@anyzzas7149]

A very clear explanation. Thanks!!!

[@nicoleoro6468]

Thank you for explaining this so well

[@ameliorategibberish8027]

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

[@patrickbrefo642]

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

[@balochx]

This helped me a lot. Thank you!

[@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
?

[@Josh2121ify]

Great video + explanation.

[@mhreteabalemayhu3625]

Thanks a lot that is cool i will pass my exam

[@bennyjagroop2688]

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

[@blungazz]

Thanks for this video. Big help.

[@loneerwoof]

Thank you sir...its very helpful 💕

[@aailee0029]

Thank you so much it helps me a lot

[@butrinthaliti2942]

Thanks man this was really helpful

[@AbdurRahim-ot5gp]

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

[@shaukatali7665]

no doubt, it was really very helpful

[@MegaJesseman]

3:50 is where it starts getting important.

[@Ty-lp7ew]

Thank you help me a lot!!

[@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 th-cam.com/video/R7QaBqm323g/w-d-xo.html

[@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

[@qurrat-ul-ainzaheer5533]

thanks u soo much
it helped a lot

[@kylesurf321]

Good job wex good job

[@meliodasssds8833]

you helped me alot thx bro

[@antoinej.augustine2589]

this dude voice scares the living hell out of me

[@Karicula2012]

Very nicely done

[@Shortsfootball.2]

Thank you so much !!

[@LinhNguyen-xx5fg]

God bless you.

[@narayansinghfacts7569]

Nice video

[@kemieshaforrest5601]

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

[@QVisible]

Hi. Here is the previous video: th-cam.com/video/z655HOd2gHs/w-d-xo.html

[@neerajmahapatra5239]

Wow you are really awesome dude....

[@QVisible]

Thanks for the love man!

[@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.

[@TheKhan9191]

thank you very much

[@ajwahijazi7070]

thankyou so much man you saved my life

[@QVisible]

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

[@hriday.m8015]

Thank you 😊 a lot

[@tishanyamckenzie7653]

Amazing Video!!

[@QVisible]

Amazing comment. Thanks!!

[@sujanmgr3359]

Thanks for remained....

[@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.

[@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.

[@Tayyhayrayyaymeem]

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

[@user-ko7fl3eu5g]

Best education

[@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 .

[@kileford2297]

Can you rename the relationship from Relationship to something else?

[@QVisible]

Are you talking about the relationship view?

[@neimael3182]

Thanks you

[@mannemvarshithrocks]

very nice thanks

[@cybilebenedict]

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

[@QVisible]

What do you prefer instead of access?

[@rehabzaidalzahrani1976]

thanks teacher

[@chathurikadmd3771]

thank you

[@naziajasmeen4203]

thanx!

[@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

[@shadazad4506]

thank you brother ;)

[@QVisible]

And you. Happy Christmas.👍

[@Limited00]

Cool voice :)

[@niroshanbandara5147]

You should increase the volume. Everything else is perfect

[@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

[@mc-eu8sr]

Thanks

[@nehasohu4576]

❤❤❤

[@rajmandal9143]

thnx

[@Tayyhayrayyaymeem]

thanks

[@mayomayo9557]

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

[@jordanhuusy]

"Ironclad"

[@rishimalhotra7331]

Thankssssssssss

[@praladyadav900]

nice vd

[@tanishgupta783]

It helped in cca

[@QVisible]

Yes!!!!! Thanks for coming back!

[@tec9820]

respect brogad

[@QVisible]

Thanks.

[@ash81818]

3:48

[@Abudursh]

lovely Simple & Clear
U R SO Nice gay
thankx Remained

[@rcnut5112]

didn't help me with class project

[@QVisible]

What was your class project 🤔?

[@nikolarakita2401]

Narrated by Arnold Schwarzenegger xD

[@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

[@dangerousxyzgamer]

Jjd

[@locust25VI]

holy shit your voice

[@QVisible]

+LocustHD Good or Bad? :-)

[@locust25VI]

good

[@jasminstrozier9831]

African? :)

[@CoreReaper1]

helpful but speak up.