Creating a one to many relationship in a Access College Database

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

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

[@aailee0029]

Thank you so much it helps me a lot

[@samdc3000]

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

[@ameliorategibberish8027]

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

[@nicoleoro6468]

Thank you for explaining this so well

[@mhreteabalemayhu3625]

Thanks a lot that is cool i will pass my exam

[@patrickbrefo642]

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

[@anyzzas7149]

A very clear explanation. Thanks!!!

[@butrinthaliti2942]

Thanks man this was really helpful

[@MegaJesseman]

3:50 is where it starts getting important.

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

[@balochx]

This helped me a lot. Thank you!

[@loneerwoof]

Thank you sir...its very helpful 💕

[@Josh2121ify]

Great video + explanation.

[@neerajmahapatra5239]

Wow you are really awesome dude....

[@QVisible]

Thanks for the love man!

[@ajwahijazi7070]

thankyou so much man you saved my life

[@QVisible]

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

[@tishanyamckenzie7653]

Amazing Video!!

[@QVisible]

Amazing comment. Thanks!!

[@blungazz]

Thanks for this video. Big help.

[@meliodasssds8833]

you helped me alot thx bro

[@cybilebenedict]

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

[@QVisible]

What do you prefer instead of access?

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

[@Karicula2012]

Very nicely done

[@DoraemonNobita_G25]

Nice video

[@antoinej.augustine2589]

this dude voice scares the living hell out of me

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

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

[@Ty-lp7ew]

Thank you help me a lot!!

[@kylesurf321]

Good job wex good job

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

[@sujanmgr3359]

Thanks for remained....

[@Shortsfootball.2]

Thank you so much !!

[@shadazad4506]

thank you brother ;)

[@QVisible]

And you. Happy Christmas.👍

[@AbdiKebede-y1s]

Best education

[@kileford2297]

Can you rename the relationship from Relationship to something else?

[@QVisible]

Are you talking about the relationship view?

[@mannemvarshithrocks]

very nice thanks

[@qurrat-ul-ainzaheer5533]

thanks u soo much
it helped a lot

[@LinhNguyen-xx5fg]

God bless you.

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

[@neimael3182]

Thanks you

[@Tayyhayrayyaymeem]

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

[@mayomayo9557]

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

[@chathurikadmd3771]

thank you

[@niroshanbandara5147]

You should increase the volume. Everything else is perfect

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

[@TheKhan9191]

thank you very much

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

[@nehasohu4576]

❤❤❤

[@tanishgupta783]

It helped in cca

[@QVisible]

Yes!!!!! Thanks for coming back!

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

[@tec9820]

respect brogad

[@QVisible]

Thanks.

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

[@rehabzaidalzahrani1976]

thanks teacher

[@Limited00]

Cool voice :)

[@mc-eu8sr]

Thanks

[@naziajasmeen4203]

thanx!

[@Tayyhayrayyaymeem]

thanks

[@rajmandal9143]

thnx

[@rcnut5112]

didn't help me with class project

[@QVisible]

What was your class project 🤔?

[@praladyadav900]

nice vd

[@jordanhsy]

"Ironclad"

[@ash81818]

3:48

[@nikolarakita2401]

Narrated by Arnold Schwarzenegger xD

[@rishimalhotra7331]

Thankssssssssss

[@dangerousxyzgamer]

Jjd

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

[@locust25VI]

holy shit your voice

[@QVisible]

+LocustHD Good or Bad? :-)

[@locust25VI]

good

[@jasminmalave98]

African? :)

[@Abudursh]

lovely Simple & Clear
U R SO Nice gay
thankx Remained

[@CoreReaper1]

helpful but speak up.

[@hriday.m8015]

Thank you 😊 a lot