Creating a one to many relationship in a Access College Database

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

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

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

[@bennyjagroop2688]

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

[@AbdurRahim-ot5gp]

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

[@MegaJesseman]

3:50 is where it starts getting important.

[@mhreteabalemayhu3625]

Thanks a lot that is cool i will pass my exam

[@patrickbrefo642]

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

[@loneerwoof]

Thank you sir...its very helpful 💕

[@samdc3000]

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

[@neerajmahapatra5239]

Wow you are really awesome dude....

[@QVisible]

Thanks for the love man!

[@nicoleoro6468]

Thank you for explaining this so well

[@aailee0029]

Thank you so much it helps me a lot

[@anyzzas7149]

A very clear explanation. Thanks!!!

[@butrinthaliti2942]

Thanks man this was really helpful

[@Josh2121ify]

Great video + explanation.

[@ameliorategibberish8027]

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

[@balochx]

This helped me a lot. Thank you!

[@cybilebenedict]

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

[@QVisible]

What do you prefer instead of access?

[@Karicula2012]

Very nicely done

[@tishanyamckenzie7653]

Amazing Video!!

[@QVisible]

Amazing comment. Thanks!!

[@ajwahijazi7070]

thankyou so much man you saved my life

[@QVisible]

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

[@DoraemonNobita_G25]

Nice video

[@meliodasssds8833]

you helped me alot thx bro

[@antoinej.augustine2589]

this dude voice scares the living hell out of me

[@blungazz]

Thanks for this video. Big help.

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

[@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 ua-cam.com/video/R7QaBqm323g/v-deo.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

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

[@mayomayo9557]

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

[@kylesurf321]

Good job wex good job

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

[@kemieshaforrest5601]

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

[@QVisible]

Hi. Here is the previous video: ua-cam.com/video/z655HOd2gHs/v-deo.html

[@niroshanbandara5147]

You should increase the volume. Everything else is perfect

[@Shortsfootball.2]

Thank you so much !!

[@Ty-lp7ew]

Thank you help me a lot!!

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

[@kileford2297]

Can you rename the relationship from Relationship to something else?

[@QVisible]

Are you talking about the relationship view?

[@sujanmgr3359]

Thanks for remained....

[@LinhNguyen-xx5fg]

God bless you.

[@qurrat-ul-ainzaheer5533]

thanks u soo much
it helped a lot

[@Tayyhayrayyaymeem]

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

[@mannemvarshithrocks]

very nice thanks

[@AbdiKebede-y1s]

Best education

[@neimael3182]

Thanks you

[@shadazad4506]

thank you brother ;)

[@QVisible]

And you. Happy Christmas.👍

[@chathurikadmd3771]

thank you

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

[@TheKhan9191]

thank you very much

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

[@Limited00]

Cool voice :)

[@tec9820]

respect brogad

[@QVisible]

Thanks.

[@rehabzaidalzahrani1976]

thanks teacher

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

[@naziajasmeen4203]

thanx!

[@nehasohu4576]

❤❤❤

[@tanishgupta783]

It helped in cca

[@QVisible]

Yes!!!!! Thanks for coming back!

[@mc-eu8sr]

Thanks

[@rajmandal9143]

thnx

[@Tayyhayrayyaymeem]

thanks

[@jordanhuusy]

"Ironclad"

[@praladyadav900]

nice vd

[@rcnut5112]

didn't help me with class project

[@QVisible]

What was your class project 🤔?

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

[@rishimalhotra7331]

Thankssssssssss

[@nikolarakita2401]

Narrated by Arnold Schwarzenegger xD

[@dangerousxyzgamer]

Jjd

[@ash81818]

3:48

[@locust25VI]

holy shit your voice

[@QVisible]

+LocustHD Good or Bad? :-)

[@locust25VI]

good

[@jasminstrozier9831]

African? :)

[@Abudursh]

lovely Simple & Clear
U R SO Nice gay
thankx Remained

[@CoreReaper1]

helpful but speak up.

[@hriday.m8015]

Thank you 😊 a lot