How to create Relationship between two tables or more in ms access MS Access for beginners 7

Поділитися
Вставка
  • Опубліковано 21 жов 2024
  • you learn in this video How to create Relationship between two tables or more in ms access MS Access for beginners 7. Relational Database Concepts
    #msaccess #relationshipdatabase #tablerelationship #computergyanguruji
    Our second channel
    / computergurujitechnical
    www.amazon.in/shop/computergyanguruji
    Follow us on
    instagram
    / computergyanguruji
    Twitter
    / c_g_guruji
    Facebook
    / computer-gyan-guruji-1...
    MS Excel Videos
    • Hindi English Dictiona...
    MS Word
    • MS Word
    MS PowerPoint
    • MS Power Point
    MS Access
    • MS Access tutorial for...
    MS Paint
    • MS Paint
    MSW Logo
    • MSWLogo
    Notepad & HTML
    • Notepad complete tutor...
    Computer Education
    • Education
    Other
    • Other video
    Tally
    • Tally ERP.9 Rules of D...
    Internet
    • internet
    Computer GK
    • GK
    Reasoning
    • Reasoning
    Airthmatics
    • Airthmetic

КОМЕНТАРІ • 95

  • @anandgrewal8567
    @anandgrewal8567 Рік тому +4

    Superrrrrr Sirji thnks my problem solve 🙏

  • @trinita5748
    @trinita5748 Рік тому +5

    Thank you so much sir , it has helped me when I was truly in need !!!

  • @parvrakha5678
    @parvrakha5678 2 роки тому +4

    Thanks so much sir solve my problems but I can do

  • @MeenaDavi-xp9rm
    @MeenaDavi-xp9rm Місяць тому

    Thank you sir clearly explained

  • @alamin_7
    @alamin_7 2 роки тому +3

    How educative tutorial it is!!!!!!!

  • @namansingh5163
    @namansingh5163 Місяць тому

    Thanks sir, must watch video

  • @vikasgawaria5330
    @vikasgawaria5330 Рік тому

    Good video sir thankyou so much

  • @behindthescene2727
    @behindthescene2727 3 роки тому

    bahut aasaan #access

  • @sanchitaarya9476
    @sanchitaarya9476 4 роки тому +1

    Very nice sir plz continue series

  • @morchattishgadhonkarsen1566
    @morchattishgadhonkarsen1566 2 місяці тому +1

    Thank you sir

  • @shivamtiwari7821
    @shivamtiwari7821 Рік тому

    Very nice sir🙏

  • @PradeepKumar-zb9lt
    @PradeepKumar-zb9lt 3 роки тому +1

    Tanks Sir....Clearly Explained

  • @asifahussain6664
    @asifahussain6664 Рік тому

    Thank uh so much sir

  • @djbhi3701
    @djbhi3701 2 роки тому

    Jabardast sir

  • @chandnisahu8535
    @chandnisahu8535 2 роки тому

    Tq sir m bahut confused thi aapne meri problem solved kr di aap dtp k bhi vidios bnate h

  • @digitalaayam2503
    @digitalaayam2503 2 роки тому

    unbeatble dear

  • @javedahmed8343
    @javedahmed8343 3 роки тому

    You put in g8 effort to simply the teaching

  • @vinodsinghal1247
    @vinodsinghal1247 3 роки тому

    Nice explanation sir heads off

  • @jiganeshbarot95
    @jiganeshbarot95 3 роки тому

    Very nice video sir 🙏🙏

  • @Catsruleforever
    @Catsruleforever 2 роки тому +4

    Thank you so much sir 🙏
    Tomorrow is my computer exam
    This is extremely helpful 🙏

  • @ishumiglani0
    @ishumiglani0 3 роки тому

    Nice explained sir.

  • @brijeshkumarsharma3062
    @brijeshkumarsharma3062 Рік тому

    Very good

  • @navalkumar9164
    @navalkumar9164 20 днів тому

    Nice video

  • @RahulYadavStudio
    @RahulYadavStudio 3 роки тому

    Very nice sir

  • @sachinpatel2420
    @sachinpatel2420 3 роки тому

    Nice video sir

  • @manudhan4155
    @manudhan4155 3 роки тому

    Thanks sir.

  • @statusking6382
    @statusking6382 2 роки тому

    Super sir

  • @bluelagoondblue5647
    @bluelagoondblue5647 3 роки тому

    Sir your explanation power is slow clear and good understanding for a student having little knowledge of access sir I have little knowledge I have looked your 7 vedio I am very much understand and I hope if person having little knowledge he can increase his knowledge by looking and understanding and become good knowledge able peson thanks sir salute you

  • @dsinharay
    @dsinharay 4 роки тому +1

    Now its ok, thanks.

  • @Pritambhatt17
    @Pritambhatt17 3 роки тому

    sir kindly many to many relationship ka video upload kijiyega please. achchi turorial h.

  • @saudkhan8376
    @saudkhan8376 8 місяців тому

    Thank you

  • @infinityzgaming8859
    @infinityzgaming8859 26 днів тому

    Thanks

  • @bilalaziz9431
    @bilalaziz9431 Рік тому

    Hello Sir
    I see your videos it's very helpful i make a complaint management system using excel and vba but now i want to make a tools inspection software so can you help me related this?

  • @asifsiddiqui2539
    @asifsiddiqui2539 10 місяців тому

    Thanks sir

  • @bhartikaushal6867
    @bhartikaushal6867 2 роки тому

    Nyc video sir

  • @shameekbose5424
    @shameekbose5424 2 роки тому

    Very helpful. Thanks Sir. Please create form with vba code.

  • @govindjuneja2100
    @govindjuneja2100 Рік тому

    Badiya

  • @themahad4061
    @themahad4061 3 роки тому

    Thanks From Pakistan 🇵🇰

  • @dhaval022
    @dhaval022 4 роки тому +4

    sir access per ek application based software banana chaahata hu... mere business dairy farm ka hai toh main chaahata hu ki main khud ek khudka software vba ki madad se access ke zariye bana saku please aap ek aisa hi tutorial pesh kijiye

  • @shivaninargesh130
    @shivaninargesh130 Рік тому

    Tq sir

  • @officenoproblem
    @officenoproblem 27 днів тому

    आपने बहुत अच्छा समझाया सर इसके लिए धन्यवाद ... लेकिन मेरा एक सवाल है , एक्सेस 2007 मे जब हम मोबाइल नमबर का कालम जोड़ते हैं और डाटा टाइप "Number" रखते हैं तो डाटा इन्सर्ट करते समय एरर देता है और इस कालम के लिए सही डाटा टाइप के रूप मे "Text" सेलेक्ट करने के लिए मेसेज आता है । तो इसे कैसे साल्व करें, क्योंकि मोबाइल नंबर तो "Number" टाइप का डाटा है, तो फिर "Text" डाटा टाइप की क्या जरूरत है ? क्योंकि यदि हम "Text" डाटा टाइप सेट करते हैं तो डाटा इन्सर्ट करते समय इस कालम मे अल्फाबेट वैल्यू भी जुड़ सकती है । तो कृपया इसका समाधान बताने का कष्ट करें ।

  • @ArvindYadav-nb1ce
    @ArvindYadav-nb1ce 3 роки тому

    Like hogye sir

  • @brijeshkumarsharma3062
    @brijeshkumarsharma3062 Рік тому

    Good

  • @archanaaa2514
    @archanaaa2514 3 роки тому +1

    Well explained sir.. plse tell me what is the meaning of enforce referential integrity n cascade update related fields e.t.c how it works?

  • @NirmalaTanwar-lc6zy
    @NirmalaTanwar-lc6zy Рік тому +1

    " Exams are near"
    "Nothing is clear"
    "No need to fear"
    "When manoj sir is here"
    ☺☺☺😈😈

  • @neerajgousar7403
    @neerajgousar7403 2 роки тому

    👌👌👌

  • @rafiksk096
    @rafiksk096 2 роки тому

    I want pros and cons of school database like individual certificate, marksheet design making, printing, report of each and every thing,all formulas in access

  • @ArvindYadav-nb1ce
    @ArvindYadav-nb1ce 3 роки тому

    Ms access ki or practice vedio banaye sir🙏

  • @alifootball1026
    @alifootball1026 3 роки тому

    Best Best

  • @revision_classesTM
    @revision_classesTM 10 місяців тому

    👍👍👍👍👍

  • @zahidali1111
    @zahidali1111 3 роки тому +1

    Sir my ny bht bar relationship bnany ki koshish ki hy but wo bar bar yehi kehta hy k database engine does not lock the tables properly because they are being used or processed by another person or process.sir please guide karden

    • @mashaal6187
      @mashaal6187 2 роки тому

      Uss table ko close karo
      Phir ho jaye ga
      Sirf relationship walay table ko open rakho

  • @saurabh17sharma68
    @saurabh17sharma68 4 роки тому

    Namaste sir
    me aapse pura ms access sikhana chahta hu

  • @Tarun_sharma_Next
    @Tarun_sharma_Next 2 роки тому

    Sir ye aapne kaunse version mein samjhaya hai

  • @sarartipari9119
    @sarartipari9119 3 роки тому +1

    How sir you linked roll no to each other, becz both table have different roll no

    • @devuji6914
      @devuji6914 2 роки тому

      Vo registration no h Roll no or R no alag h

  • @khadijahlaywad7744
    @khadijahlaywad7744 2 роки тому

    How did kept the primary on

  • @muhammadans-ob2tp
    @muhammadans-ob2tp Рік тому

    If relationship type is one-to-one in edit relationship bar how could I change it to one-to-many?

  • @ajitvyas19
    @ajitvyas19 Рік тому

    Sir I want to contact u howcan I?

  • @hogerrauf7152
    @hogerrauf7152 3 роки тому

    Please, can you create a table with limit row number
    like a table with one row (record) and without increasing record during data entry

  • @ricecomputerinstitute1055
    @ricecomputerinstitute1055 2 роки тому

    Calculation in access video upload kije

  • @monimagicrestaurant4103
    @monimagicrestaurant4103 2 роки тому +1

    Sir report ya datatable bnane ke baad design view mai default value mai kuch type krte h too type nhi hota 🤔why🤗reply me my first question 🙇🙇

  • @nikhildhage2828
    @nikhildhage2828 Рік тому

    Costoms contact database in access video

  • @mohammedmoinkhan4010
    @mohammedmoinkhan4010 3 роки тому

    Sir table karne se nai ho rha usme aata hai ki "database engine could not lock table "table name" because it is already in use by another person or process......lekin aisa kuch use nai ho tha mai to khud link kar rha

  • @jemilmangukiya8134
    @jemilmangukiya8134 2 роки тому

    How to close table while in relationship

  • @ankitadey2742
    @ankitadey2742 3 роки тому

    Sir kis kaam mein yee 'Relationship between two or more tables' aata hain batainyega jarur..Taki mujhe v paataa chalein. Pls Sir tell me I don't know this .

  • @ocaacademy4054
    @ocaacademy4054 2 роки тому

    How to get the practice file

  • @Pritambhatt17
    @Pritambhatt17 3 роки тому

    sir Acces mey marksheet kese banau mere se nehi ho raha kindly bataye.

  • @PriyadarshiChakraborty
    @PriyadarshiChakraborty 9 місяців тому

    6.15

  • @nacym1004
    @nacym1004 2 роки тому

    Sir contact mai jab hum number lete hai tho os mai pehle hamare pas zero q nahi ata. Ye hum kis tarah laenge?

  • @sapnaahirwar8036
    @sapnaahirwar8036 Рік тому +1

    Sir ji ko kese likhe

  • @pawanbhaskar2078
    @pawanbhaskar2078 4 роки тому

    Sir Automatic ID Card Banate Samay ID card m Photo nahi aa Rahi h
    sir Plz. Help me. Sir
    Baki Sara Kaam Ho Raha H . plz. sir

  • @shivakant4698
    @shivakant4698 4 роки тому

    Please give me FoodStore database tables details to practice me.

    • @ComputerGyanGuruji
      @ComputerGyanGuruji  4 роки тому

      I will upload the file. You can be downloaded from the description of this video on 1st Sep.

  • @sehralbaloshi7569
    @sehralbaloshi7569 3 роки тому

    Sir Mera relationship ni bun raha tables ka plz koe hal Bata dey

  • @sandipmore1419
    @sandipmore1419 4 роки тому

    Office 2019 में access नहीं है क्या ? मैने अभी नया लॅपटॉप लिया है..... उसमे office 2019 में access नहीं है I office licence कॉपी है I

    • @ComputerGyanGuruji
      @ComputerGyanGuruji  4 роки тому +1

      hota hai aapke pass office me full features update nahi hain

  • @premanandapatel4874
    @premanandapatel4874 Рік тому

    One to one relationship ha na

  • @devsaini3589
    @devsaini3589 2 роки тому

    This table in MS ACCESS yes - no

  • @nageshwarsinghbaghel5881
    @nageshwarsinghbaghel5881 3 роки тому

    रिलेशनशिप को डिलीट कैसे करें ??

  • @pirtisingh8810
    @pirtisingh8810 2 роки тому +1

    Sahi nahi dikh raha hai sir

  • @mariammurtaza9825
    @mariammurtaza9825 6 місяців тому

    Please translate in english

  • @Pratik1Aher417-r9c
    @Pratik1Aher417-r9c 3 роки тому

    Very much video sir 😒

  • @sitaramrathi7483
    @sitaramrathi7483 2 роки тому

    *दशरथ पुत्र रघु रघुवंशी अयोध्या*
    दशरथ स्वयं
    कौशल्या पत्नी
    सुमित्रा पत्नी
    कैकेयी पत्नी
    राम पुत्र
    लक्ष्मण पुत्र
    भरत पुत्र
    शत्रुघन पुत्र
    शान्ति पुत्री
    सन्तोष पुत्री
    सरला पुत्री
    यह एक जोड़ा है
    राम पुत्र दशरथ रघुवंशी अयोध्या
    राम स्वयं
    सीता पत्नी
    लव पुत्र
    कुस पुत्र
    यह दुसरा जोड़ा हैं
    शान्ति-राधेश्याम पुत्र........... राठौड़ रामपुर
    शान्ति स्वयं
    राधेश्याम पति
    दीपक पुत्र
    राधा पुत्री
    यह तीसरा जोड़ा है
    राधेश्याम पुत्र........... राठौड़ रामपुर
    राधेश्याम स्वयं
    शान्ति पत्नी
    दीपक पुत्र
    राधा पुत्री
    यह चोथा जोड़ा है
    जनक पुत्र............ सीसोदिया जनकपुर
    जनक स्वयं
    कर्तिका पत्नी
    जय पुत्र
    सीता पुत्री
    यह पांचवा जोड़ा है
    मोतीलाल पुत्र......... चौधरी मथुरा
    मोतीलाल स्वयं
    मणका पत्नी
    गायत्री पुत्री
    लोकेश पुत्र
    यह अलग छठा जोड़ा है
    यह सब कुछ सत्य कुछ काल्पनिक है

  • @vinodsinghal1247
    @vinodsinghal1247 3 роки тому

    Nice explanation sir heads off

  • @TarabatikumariKeuto
    @TarabatikumariKeuto 10 місяців тому

    Thank you sir

  • @nisarahmed5869
    @nisarahmed5869 2 роки тому

    Very good

  • @ADITYASINGH-kx2wb
    @ADITYASINGH-kx2wb Рік тому

    Good

  • @nikkikesharwani8518
    @nikkikesharwani8518 Рік тому

    Thank you sir

  • @entertainment-cu9ld
    @entertainment-cu9ld Рік тому

    Thank you sir