(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
Your Video is really nice and easily understandable
archna your comments is also so goood
Dear Sir,
Your videos are very helpful. I could learn entire access with the help of these videos.
Thanks.
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
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.
gr8
nice job for providing vital facility for bigginer
thankk
anand
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
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.
Excellent your presentation. Thanks
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
Excellent Video’s.
Easily understandable.
Million Thanks
Dear Sir,
Your videos are very helpful. I could learn entire access with the help of these videos.
Thanks.
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
thanks
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.
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
Hi,
Thanks for your email. I am currently looking into learning SQL, so if I feel good about it, will make videos soon.
amir
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
Hi Sheikh Hafizur Rahman,
Even I am hoping to add SQL videos, but have not had the chance to study them. Have been away from work, taking care of my father. In the mean time, Khanacademy and codecademy have added very good SQL tutorials. Check them out.
https://www.khanacademy.org/computing/computer-programming/sql
https://www.codecademy.com/learn/learn-sql
All the best.
Amir
Thanks Amir! Wonderful tutorials… awsome!!!
Your Video is really Nice & Easily Understandable. So I would like to thank you very much.
Currently I am learning MS Access through your Tutorial VIdeo
Thanks for your comment Balram Kumar. All the Best.
Your video is very useful. Please keep continues
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
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.
sir vb ya macro statement means
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.
sir mujhe hindi version me power point se college presentation and animation kaise bnate hai hai. wo bataye sir
????? ????????? ?? ?????? ???? ??. ?? ??? ???? https://www.youtube.com/playlist?list=PLcQsBFJvoyLbvcnC-XmEDheQhT5pUOXfG
Thanks Sir for this videos
Sir tell me more about stock inventory like atta, dal, suger, or general store
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.
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
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
You are great sir
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….
I sent you an email. Check your inbox and also check your spam/junk folder.
Your videos are very helpful.
Really a wonderful gift for all the new learners.
Sir Your video is very helpful to learn ms office on self and your hindi voice is very cute
I am from Hindi medium. Your videos are really helpful to learn especially “Access”. Thanks. Keep on making Hindi videos. Well wishes.
Sir
This is a very good.
I learned from this clearly.
Very good sir
Dear Sir,
Please share video of competitive exam of access like including macros with dynamic querys….
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.
thnx bro apke videos or teaching ka way excellent hai.
ek request hai ap ye videos continue kariye…
thnx…
thank you
bahot achhi tarah se sikhate ho..
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
Sir, Thank You,
Your video is very use full
Please make another video coral draw/photo shop and etc if possible
your videos is very helpful for learn
thanks for making videos
Hello sir
Sir access ki only 7 hi videos hai ya aur bhi hai… agr h to plz suggest me
jee ha 7 video hai. mujhe jitna pata hai, woh sab video par hai.
thanks sir, your hindi tutorial is very helpful for us. so i requested you . you provided us photoshop,coreldraw &pagemaker tutorial in hindi.
Thanks Sir Your vidio is good as well as easy to understand thanks again sir
Dear sir mai vba ki full hindi video chahta hu iske liye mai Kya karu pls reply
sorry satyendra, mujhe vba ka knowledge nahi hai.
Your Video is really nice and easily understandable
Dear sir,
Your hindi video tutorial are very easy to learn access and useful.
When you are producing next part after part 7.
sir
my name is surendra chudhary I live at faidabad haryana. I want to be the company’s stock register .
I’m not making entry of the goods in the store to stock register .
plz help me……
Hi, not sure how can I help you. can you explain?
Hi amir Mujhe Apki Madad Chahiye
Mai Ek Data Base bana chah taho jisme
stock in stock out ho
Automatic Stock in and out database, thoda difficult hai. Maine kabhi nahi prepare kiya hai.
Mr. Amir Parmarji, Your Video is really nice, helpful and easily understandable to learn M.S. Access on self.
Thanks
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
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.
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()))))
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
Aamir Sir,
ye condition mujhe access me lagani hai to plesae kya mere liye ek video upload karoge.
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.
comma (,) IF function go separate karte hai. Ab is example main kya ho raha hai, woh toh use run karne ke baad pata chalega.
toh aap meri kese help kar sakte hai. mera number 7011724228
IIf((Date()-[Dunning_Data]![ServiceStrtDt])/365*12 Is Null,Null,IIf((Date()-[Dunning_Data]![ServiceStrtDt])/365*12 04 Months”))
Jo maine abhi apko send kiya hai isko samjha do mujhe please.
sir aapko reply nhi karna to mana kar do yu ese mere comment delete na karo
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.
sir maine to apko mana nhi kiya
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.
apko mai kese dikha sakta hu sir.
Nice video sir
I want to learn access reporting .
I have covered those topics in my videos.
Sir what a nice teaching style,
Pls also issue videos for tally
Thanks again
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
Very nice teacher. Very useful and helpful.
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
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.