Hindi – Microsoft Access

(Hindi) Microsoft Access 2007/2010/2013 pt 1 (Tables, Form)
(Hindi) Microsoft Access 2007/2010/2013 pt 2 (Table, Query, Report)
(Hindi) Microsoft Access 2007/2010/2013 pt 3 (Table Relationships)
(Hindi) Microsoft Access pt 4 (query expression builder, append/update/delete query)
(Hindi) Microsoft Access pt 5 (Form, Create Tab, Navigation form, Calculate fields)
(Hindi) Microsoft Access pt 6 (Report Invoice, Macro: Find, Email, Print, Search)
(Hindi) Microsoft Access pt 7 (Auto Complete & input box on form)
(Hindi) Microsoft Access pt 8 Add Password
(Hindi) Microsoft Access pt 9 Cascading Combo box
(Hindi) Microsoft Access pt 10 Invoice Dlookup
(Hindi) Microsoft Access pt 11 Forms Button to open Report

Sample Files:

(Hindi) Microsoft Access pt 3 Sample
(Hindi) Microsoft Access pt 4 Sample
(Hindi) Microsoft Access Pt 5 Sample
(Hindi) Microsoft Access pt 6 Sample
(Hindi) Microsoft Access pt 7 Sample
(Hindi) Microsoft Access pt 10 Invoice Dlookup
(Hindi) Microsoft Access pt 11 Sample

86 thoughts on “Hindi – Microsoft Access”

  2. Hiren Modasiya

    Dear Sir,

    Your videos are very helpful. I could learn entire access with the help of these videos.
    Thanks.

    Reply ↓
    1. Rehan Qureshi

      hello amir bahi mera nam rehan qureshi hai main pakistan se hon.
      app videos mujhay buhat pasand hain or buhat esay bhi hain . bahi ek request hai main ek pharma company main job kar karta hon . mujhay ak medicine ka program bana hai medicine invoice database
      as ka complete process bata dain videos or hindi main thanks

      Reply ↓
      1. amir parmar Post author

        medicine invoice itna difficult nahi hai, par uske advance feature main issue aa sakte hai. aur automatic inventory reduction bhi thoda complicated hai. Aapko products, customers, orders, order detail, payment, ke tables banane padege.

        Reply ↓
  4. Sayeed

    Dear Mr. Ameer,
    Greetings,

    You have done a great job, really appreciated and for sure it is going to be in welfare of Hindi speaking peoples.

    Thanks a lot and please keep it up
    .

    Take Care,
    God Bless you,
    Sayeed

    Reply ↓
  5. Khajahussain

    I really appreciate you for your nice vedios which are really understand able by any person. I learn ms access by your vedios without any pain. Keep going on other programming languages also I am very thankful to you.

    Reply ↓
  7. Sajjad Ashraf

    Great effort,every one can understand and get help easily…………..I appreciate you for this excellent job,plz keep it up and share more knowledge in other programming languages to youngsters to develop the nation……….thanx

    Reply ↓
    1. amir parmar Post author

      Good job Sudeep, you did well. And if you ever need a complicated Access database, look into freelancer online. you can hire them at a good rate at freelancers.com or elance.com fiverr.com
      all the best.
      Amir

      Reply ↓
  11. RAJESH

    IT IS WONDERFULL VIDEO SIR, WE LEARN A LOT FROM IT, B’COUSE IT IS IN OUR LANGUAGE, , PL GIVE SOME MORE VIDEO CLASSES LIKE THIS,THANK YOU VERY MUCH SIR.

    Reply ↓
  12. Sheikh Hafizur Rahman

    Dear Amir,
    I got lot of help from your precious videos. I always see your hindi video whenever I face any difficulties. May your life be delightful. Can you upload video about Microsoft Access with SQL in hindi language? It will be more helpful for me.

    Thanking you,

    Sheikh Hafizur Rahman
    Dhaka, Bangladesh
    +8801817075238

    Reply ↓
      1. Sheikh Hafizur Rahman

        Dear Amir,
        I am still looking for your hindi videos about SQL through MS Access. May Allah help you in your all success.

        Thanking you,

        Sheikh Hafizur Rahman
        Dhaka, Bangladesh
        +8801817075238

        Reply ↓
  16. Binod kumar

    sir
    jab hm file bnane ke baad Phir folder se open karte hai to wha pe block baar baar aa jata hai
    please reply me sir

    Reply ↓
    1. amir parmar Post author

      agar file main koi macro ya VB statement hai toh Access woh warning deta hai. Toh uske liye “enable content” karna padta hai, nahhi toh vb run nahhi hoga. Agar aap options main jaoge to waha “Trust settings” go change kar de.

      Reply ↓
    1. amir parmar Post author

      you can write statements using VB commands. When you create a Macro, it is made up of VB commands. In using a Macro say for Print or anything else, Access makes it easy for us by putting the VB code. But to get more out of macro it is best to understand VB, this way you can get more done and automate your tasks.

      Reply ↓
  18. Binod kumar

    sir mujhe hindi version me power point se college presentation and animation kaise bnate hai hai. wo bataye sir

    Reply ↓
  19. Dinesh Kumar

    Thanks Sir for this videos
    Sir tell me more about stock inventory like atta, dal, suger, or general store

    Reply ↓
    1. amir parmar Post author

      The stock database requires some extra work as you have to subtract sold items and also add returned items. It can be done easily with Update Query at the end of the day but it is not real time. You might find a company that sells a database with all the features. Or look at freelancer.com and find someone who can create the database for you, as this is beyond my understanding.

      Reply ↓
  20. Haidery

    salam sir
    after salam i am from pakistan then N W AGENCY now a days we are IDPs in bannu in the camp sir i used ur ms access english tutor i learnt lots but i have some deficiency by my self in vba in access please inform me that have arranged any tutor about it or not if u have not then please tell me about tutor of vba in access like u

    thanks for so good deed

    Reply ↓
    1. amir parmar Post author

      Hi, I have no clue about anyone who is good in VBA. I have never been exposed to it, so don’t know much. If you are good with programming, you can learn a lot from vba samples. Here are links:
      http://www.functionx.com/vbaccess/ (look on left for lessons, have not had a chance to try it myself)
      http://vbahowto.com/

      also check out http://www.lynda.com/search?q=vba&f=producttypeid%3a2%094%092015%3bmeta_topic_facet%3aDatabases
      this website is not free, but they have 10 day trial, so you can learn and cancel it. or continue to learn.

      All the best.
      Amir

      Reply ↓
  22. amit

    Sir Me Govt. employee hu mujhe mere field me daily data match krne padte he to use access me kese match krwa skta hu…………………….Ex. Number to Number isme jo pahle se enter he wo nhi aae or nahi enter he wo dikhaye….

    Reply ↓
  26. Bhupesh

    I am from Hindi medium. Your videos are really helpful to learn especially “Access”. Thanks. Keep on making Hindi videos. Well wishes.

    Reply ↓
    1. amir parmar Post author

      Hi Uday, my knowledge of Access is limited, don’t get to use it, so don’t get to learn much about it. Everything I know is in my tutorial videos. All the best.

      Reply ↓
  29. Rahul Baghel

    thnx bro apke videos or teaching ka way excellent hai.
    ek request hai ap ye videos continue kariye…
    thnx…

    Reply ↓
  31. Satish

    Dear Sir,

    Your videos are very helpful. I could learn entire access with the help of these videos.
    Thanks.

    Satish Langaliya
    Mobile 9428078722
    Bhavnagar Gujarat India

    Reply ↓
  32. Rajnish Kumar

    Sir, Thank You,

    Your video is very use full

    Please make another video coral draw/photo shop and etc if possible

    Reply ↓
  36. RISHU KUMAR

    thanks sir, your hindi tutorial is very helpful for us. so i requested you . you provided us photoshop,coreldraw &pagemaker tutorial in hindi.

    Reply ↓
  40. Ramesh

    Dear sir,

    Your hindi video tutorial are very easy to learn access and useful.
    When you are producing next part after part 7.

    Reply ↓
  43. Mahaveer Jain

    Mr. Amir Parmarji, Your Video is really nice, helpful and easily understandable to learn M.S. Access on self.
    Thanks

    Reply ↓
  44. suraj kumar

    Thanks sir.
    may ek computer teacher uh aapka is video SE may aapne student to bahut hi acha quality DE raha uh.
    sir mera ek question hai ki query critria (and) x, y ka use kab karate hai

    Reply ↓
    1. amir parmar Post author

      Hi Suraj,
      Jaan kar kushi hui ko aap ko meri videos bacho ko sihane main help kar rahi hai. Query criteria records search karne main kaam aati hai. Jaise ki Like sabd ka use hota hai. Toh City ka field hai to Like Mumbai likh sakte ho.
      Between [Start date] And [End date]
      is criteria se 2 sawal Prompt hote hai. dono prompt main date dalte hai. jisse us date ke bich ke records milte hai.

      Reply ↓
  45. Amit Kumar

    Aamir Bhai,

    please is formal ko mujhe samjha do hindi me kisi ne mujhe se pucha hai iske bare me.

    IIf((Day(Date()))<[BC_Details]![Bill_Day],(Month(Date()-30) & "/" & [BC_Details]![Bill_Day] & "/" & (Year(Date()))),(Month(Date()) & "/" & [BC_Details]![Bill_Day] & "/" & (Year(Date()))))

    Reply ↓
    1. amir parmar Post author

      Amit, If function ke 3 bhaag hote hai. Pehla If statement, yani ki kya test ho raha hai. Doosra, agar yeh statement True (Sach) hai toh kya karna. Aur Teesra bhag, agar If statement False (galat) ho toh kya karna.
      Pehla: IIf((Day(Date()))<[BC_Details]![Bill_Day] Doosra: (Month(Date()-30) & "/" & [BC_Details]![Bill_Day] & "/" & (Year(Date()))) Teesra: (Month(Date()) & "/" & [BC_Details]![Bill_Day] & "/" & (Year(Date())))) Teeno bhag ke beech comma (,) ka pryug hota hai, use alak karne ke liye. Excel ki 6th video main maine If function ka basic cover kiya hai https://www.youtube.com/watch?v=okZ8ptCKHC0&list=PLcQsBFJvoyLawI-6WtKV5wPlhY9NnAZ8C&index=6

      Reply ↓
    1. Amit Kumar

      Pehla: IIf((Day(Date()))< [BC_Details]![Bill_Day] mujhe ye samjh nhi aayor haa ek baat btao true or false ki value to " " ke ander hoti hai

      exp: IIf((Day(Date()))4″)

      par isme to kahi bhi ” ” ander value nhi rakhi.

      Reply ↓
  48. Amit Kumar

    IIf((Date()-[Dunning_Data]![ServiceStrtDt])/365*12 Is Null,Null,IIf((Date()-[Dunning_Data]![ServiceStrtDt])/365*12 04 Months”))

    Reply ↓
    1. amir parmar Post author

      Maine aapke comment delete nahi kiye hai. Woh pending hote hai, kyu ki bahut sara spam/junk comment aate hai. toh mai unhe approve karta hu. Aur aap ko naragi dikhani ko zarrorat nahi hai, main Canada mai rehta hu. Toh hamare bheech samay ka difference hai. aur mujhe kafi comment aate hai, jisko main reply karne ki koshish karta hu. So thank you permission dene ke liye, ki main aapko answer na du. All the best.

      Reply ↓
    1. amir parmar Post author

      mere pass aur koi explanation nahi hai. Aapko us query ko run kar dekhna padega, aur result se learn kar le. query Current Date aur koi uar date se calculation kar rahi hai.

      Reply ↓
  54. PKG Nair

    Dear Mr Parmar,
    I am a retired person and have computer knowledge. However, I never tried to do any programming in Access. These days I am sitting at home and thought will do something and accordingly started to do programming in Access 2007. I took lot of help from your wonderful videos and was quite successful. I feel you should have been a faculty in a training institute. Your teaching style is excellent. I have noticed some problem in the AutoNumber. While checking the duplicate record, it add numbers in the form but record is not getting entered in the database. I just wanted to stop entry of duplicate records in the database. If possible kindly help me with a solution
    Keep continuing your caliber in the Access programming and continue to make videos which will help lot of people in learning/mastering in Access programming. Thanks and best wishes + Happy New Year

    Reply ↓
  56. Hafiz yasir

    Sir,
    I m a priffessiomal accountant. I took ur lecture and it is so easy to understand for me. I designed an account softwear in wrritten form. I have some problems to creat it. So would u like to help. I would be thankful to you. Please!
    I m waiting ur reply………
    Hafiz Yasir

    Reply ↓
  57. Amir Shahzad

    Amir bhai, only your videos are understandable, i want to learn more, like expression building , like i want to move records from one table to another etc.

    Reply ↓
  58. Chandresh Somaiya

    Excellent your presentation.
    Maine YouTube me jitne bhi access ke video dekhe usme aapke video best hai.
    Aapke jitna perfect aur detai se koi nahi sikhata.
    Very very nice

    Reply ↓

Leave a Reply

Your email address will not be published. Required fields are marked *