I enjoyed learning access from your website. I like the fact that you are quite methodical and you do not assume a lot like many videos I have watched including stellar websites like in Lynda.com. You explain in a very simplified way which is beneficial for a beginner. I will not use Access to organise my contact list for a community organisation I work with. Kind regards from Glasgow UK. http://www.sauti-nexus-projects-and-training.co.uk
Very glad that you liked the Microsoft Access videos. Check out my Youtube page I have videos for Word, Excel, PowerPoint & Outlook. http://www.youtube.com/simpletektoronto
All the best.
Amir
Dear sir, 1) how to lock the report of Company,address, tel no..etc.
2) I am using query to key in the period 1/1/18 to 31/5/18 and how to show the period in the report
3) There are two reports one is profit & loss a/c another is Balance sheet , from the profit & loss a/c I
have get profit amount , and now how to put this amount to Balance sheet report
Thank you Brother
I watched your first video and was really helpful, i am taking Database Management, and i have no experience of building table, thank you for you supporting videos, I will continue watching until i learn.
I really enjoyed very much coz your way of teaching is really amazing! it’s quire simple, direct, clear, and easy to understand with very logical way and steps to follow..
Many Many thanks my dear for this great effort!
Ahmed Alsaffar
Saudi Arabia – Qatif
Hi Ahmed,
Very glad that the tutorials video have been useful in your learning. Thanks for taking the time to post a comment, messages like your make it all worth it.
Amir
Dear sir, 1) how to lock the report of Company,address, tel no..etc.
2) I am using query to key in the period 1/1/18 to 31/5/18 and how to show the period in the report
3) There are two reports one is profit & loss a/c another is Balance sheet , from the profit & loss a/c I
have get profit amount , and now how to put this amount to Balance sheet report
I really enjoyed your Access videos. Everything about your way of teaching is amazing. Thank you so much.
I wonder if it would be possible for you making some on the SharePoint designer SW.
DS
Dear Amir,
Thanks a lot for the video on MS Access.it was very informative and everything was explained in a very clear way.It has given me a good base to go for advances Access.Keep it up… 🙂
Brilliant, really very clear. I haven’t watched No.4 yet but hope it explains how to print labels from a table, not all records, in my case I just want to pull out those to whom I want to send a Christmas card. Also how to format a field. I have cracked it in a record but not labels. Thanks, Marco
Hi,
Thanks for the comment. The 4th video does not show how-to print labels. I never thought about it. But I looked at it quickly. To create Labels, click on CREATE tab and click on LABELS. Choose the Manufacturer of the Label paper and choose the Product number. Follow the steps and choose the way you want to arrange the Name and Address using the arrow (remember to add spaces). Then finish the wizard and print it.
Hope this helps. The other option would be use Mail Merge to create labels and use the Database as your Source data.
Amir
Im a prinicipal of a Govt College in Bangalore India. out of some academic interest I i happened to stumpble upon your website and watch videos on access. Videos made by you are really educative and simple to understand. I think that even a high school student can learn a lot from your basic videos. you have a mastery of the topic and blessed with a real good voice.
I want you to do videos on dotnet programming as well as tutorials on sql 2008. This would really help people like me.
Thanks a lot again for this wonderful video set. May god bless you with health wealth and happiness.
Hi,
Thanks for your comment. I have never spent any time learning programming, in fact I have recently taken on to learn computer programming using Python from Khanacademy.org. I would highly recommend anyone trying to learn Math/Science skills to visit Khanacademy.org.
I will think about looking into .net and sql programming. My background being in networking and tech support & training; I have gained a lot of experience in teaching Microsoft Office.
I really impressed watching your videos in Access and I benefited a lot from these videos. I watched all the four videos which were clear and very simple manner. I hope more from you about it. Can I get more videos about access through you.
I have suggested many of my friends to get watch your videos. Thanks a lot for such your social and educational attempts.
Hi Ram Prasad,
Thanks for your message. I added a 5th video for MS Access on my YouTube channel, but forgot to add it to my website. Here is the link http://www.youtube.com/watch?v=h8TM240tpBM
You can also check my YouTube channel for other videos. http://www.youtube.com/user/simpletektoronto
Also watch my video on Lines to Free Online Courses. It lists many websites online where you can learn many things for free.
Will continue to add more videos on different topics.
Thanks
Amir
Dear Amir,
I am working in ADNOC (Abu Dhabi National Oil Company) at Ruwais (240 KM far from Abu Dhabi) I was surfing the internet/YouTube and came across your tutorials about MS Access. I must appreciate you for such a nice tutorials you uploaded on YouTube. In fact long back (in 2002) I tried to learn it in an academy; I had to give up due to lake of timing (I had to travel 240 KM) on weekends as well as maintaining my family. Another fact was that I was not much more familiar with YouTube at that time.
Now I got a very good understanding of MS Access. Once again thanks a lot.
Regards,
Hi,
Thanks for your message. I am very happy that these tutorial videos have been helpful in your learning. I had added a 5th video for Access on my YouTube channel, but forgot to add it to my website. Link is below. I also added 6 videos for Microsoft Access 2003.
Microsoft Access 2007/2010 Basic 5: http://www.youtube.com/watch?v=h8TM240tpBM
Access 2003: http://www.youtube.com/playlist?list=PLcmYWY91gQNebBu9x8NaxKtEEgfAVYSQc
With regards and all the best.
Amir
Hi Amir ! Thank you very much for your video tutorials on you tube.I am from a small village in Maharashtra,India.
I am looking for tutorials for visual basic 2008 express edition. If you have please send me links.Thanks again.
Thank you Amir for your Acess 2007 Tutorials.
It has enabled me to write a Asset Tracking Database.
I have “Users”, “Locations” and “Equipment”.
I now want to do an Audit.
Input User
Input Location
Input Equipment (Several pieces)
I then need to report on what is now missing from a location and if it is at another location.
Can you help?
It was very knowledgeable tutorial and most importantly the way you tried to explain each and every thing.
I was new to the access and now i started making few tables and report for my job related purpose.
Thanks a lot
Hi, sorry for the delay in responding. Have been busy with work and comments on YouTube. Your project is very big and I don’t consider myself an expert in Microsoft Access, I can try to answer some questions. But this will take a long time to get done.
All the best.
Amir
I have just started watching these and am finding them very useful. Since this is new to me, and I need to use it for my job, I was struggling to begin, but these videos have made it helped a lot.
Thanks a lot for your effort!!
I have a query and wanted to know if you could please guide me:
I need to populate various fields for more than a 1000 companies – company name, year of establishment, geographic presence, telephone numbers, website. out of all these fields, Geographic presence and telephone numbers have more than one entry for most companies.
Since I have to capture all such information for every company, should I make seperate tables (like different sheets) of is there a way to tabulate them in one sheet.
I an excel file, I would have probably merged the number of cells for the company name for it to appear as one block. Not really sure, how it should be done in acess.
Wanted to send you a quick THANK YOU note for the MS Access tutorial you setup on Youtube. I never leave comments, but felt compelled to tell you how EASY your tutorial is to follow. Also, I’ve wanted to learn Access for quite some time, but all the videos I’ve seen, just never explained it as WELL as you have. So I finally understand the basics and will DEFINITELY be looking at your MS Project videos. And I will probably look at your Excel videos as well, even though I am pretty good at Excel, I have a feeling you will go over something I may have overlooked.
Your a gifted teach. Thanks for your taking your time to help me/us all out.
Really great videos helo in passing my IT Practical of Institute of Chartered Accountant of Pakistan. Really great work. Please make a list of all lectures on youtube as well in a sequence.
Amir, thanks so much for your Access tutorials. I have watched all 6 and “played along” in Access, and in just one morning I can do everything I wanted to be able to do with my data, with zero prior knowledge in Access. I’m generally computer savvy, but I’m so glad I watched your videos instead of trying to figure it out myself! Thanks again and keep up the good work, you have a great teaching style.
I have watched several of your videos on 2007/2010 Access……….I am try to build a data base that will allow me to use a form to store multiple completition dates. For instance, maintenance completed on 2 Oct 13, 10 Oct 13, 16 Oct 13……..But once I mark it completed the date will be saved in a table, but show blank the next time I open the form for that piece of equipment. And be able to run a query and report of all the dates maintenance was completed.
I just put a number in the Capta block, I’m not sure what it is……
i am very new to access though i was using MS office for a long but access is an Optional in MS office.
Only after watching your video it interested me to go deep into it. ( I was familiar with Fox pro2.6)
congrats for simple way of teaching access.
Well I want to know how to use number field . I use it with 2 decimal .5v
my issue is while entering the data say 12.35 it round up to 12 or say 12.65 turns to 13 ?
how to resolve it . at present I using with currency data .
No 2 :
In form usiing calculation -calculated amount to replace in respected field.
say unit 3
rate 4
amount 12 ( in form it calculate and show in amount ) but in database instead of 12 it show blank ?
I really enjoyed very much coz your way of teaching is really amazing!
it’s quire simple, direct, clear, and easy to understand with very logical way and steps to follow..
Many Many thanks my dear for this great effort!
If you give instructions in Hindi Language your videos are much useful for Indians coz they understand better in hindi.
Thanks for the videos. However, the 4th video doesn’t show us how the relationship is been created and i think that is the primary purpose of the video.
We will appreciate it if my message is responded to soon.
Hi Dear Amir, How r you hope doing well……. i’m very glad an thankful of you for very very valuable video tutorials. these videos helped me a lot. if you don’t mind i have very humble request to you. Please video tutorial for AUTO CAD is possible..? i’ll be very thankful to you if you help me in AUTO CAD……………….
If its is not possible then please can you tell me any nice(like your method) video tutorial link that really help me
I have seen your access 2007 tutorials on YouTube. Heads off to you mate.
I was a very very useful to me. Your way of presentation is best. I will follow the same in your website.
I can’t believe that I am actually learning Microsoft Access from Youtube tutorials (in this case your tutorials). To the point, lots of great information but not boring, great pace. Thank you soooo much.
Keep it up !!!!!!
Hello Amir,
First of all, thank you very much for helping the people by such a nice way. really your video training is excellent among all the video tutorials i have ever seen.
you are the best one ….
it is really help me to lot to understand the ACCESS very well.
I was very new in access, I mean I don’t know even how to start access, but after your training I have completely understood what is an access is and now I have created so many projects in access.
Thank you very much for your absolutely free training.
I’m an expert using MS-Office especially (Excel), however I’m completely [NULL] on Access even I’m trying to learn it from so many months but which was not done till date. But today from afternoon I’ve watched all your 6 videos (of course will watch the 7th by 2morrow morning) and I started using Access just like the Excel. In our world there are few people are blessed with such amazing talents and you are one of them. May god bless you with health and wealth.
*Once again Thanks a lot for those wonderful tutorial videos.
Hi Mr. Parmar
I am rally thank you very much for your tutorials videos, I am 66 years-old and I am retired now, I studied Microsoft Access 3 long time ago but, unfortunately, neglect it for 15 years since I did emigrate to USA.
I am very interested of Microsoft Access so I tried to refresh my knowledge to match Microsoft Access 7 I have on my computer and I found difficulties to read books, then I look-up for some tutorials may help me to obtain my goal, and you did that in a very easy and clear way, your videos are truly helpful, your efforts are truly appreciated. we need you to complete doing favors by more explanation to relations between tables and more focusing on module.
Thank you again
Hi, in query Criteria you can type this
Between [Enter Start Date] And [Enter Last Date]
when you run this Query 2 prompts will pop up for the start and end date. And the words [enter start Date] [Enter end date] you can add any words you like to help the user to understand how they are supposed to enter the dates.
Hope this answers you question.
Amir
Wonderfull,…..I want to usu Microsoft Access, Because i want to make a Database For My Item, so I want to say Thank You Verry Much For You Tutorial….and…Always Success….!
Hi Moataz,
If you can get your information from Excel, I would not bother with Access. It might require lot of work to get Access to get things done. And some people might be taking their data from Access and Export it to Excel to do some work. You could look around and see if someone in Financial Analysis is using Access, as I don’t have much knowledge on that topic.
All the best.
Amir
I have a task in access and i can not find a function for it. I have a table like this:
ID Team Leader Agent Name Reason 1 Reason 2 Reason 3
1 a b 1.1 1.2 1.3
2 a b 2.1 2.2 2.3
3 c d 1.1 1.2 1.3
4 e f 2.1 2.2 2.3
The table contains the interactions of some agent with the customers and the reason for interaction. I need to make a query that contains the agents(no duplicate), team leaders and the total interactions for each agent.
In Excel I used count ifs, but in acces i’m confused.
Can you help me?
Hi Ana,
Create a query with Agent, Team leaders and the interactions field. in the design view of the query go to “Property sheet” and in there you will see an option for “unique” make it yes.
Another thing you could also try is create a Report based on this query and during the wizard, try to Group it by Agent. And you will also get an option to choose “summary” and you choose the Count option. Or later in Report Design you can add the Count.
hello sir,
my name is akhilesh and i am from haryana india sir apki help chahiye sir maine apke saare access ke video dekhe hain aur bahut kuchh seekh gaya hun and ab main apna work easily kar pa raha hun but ek aur help mil jaye agar apki to bahut mehrbani hogi sir actually like koi hum table banate hain and us table me kuchh value default rakhni hain like date and name etc. but ek hi date ya name nahi like maine 6-aug-2015 likha to next entry me bhi automatically same date aani chahiye jab tak ke main khud date change na karu yahi chij name me bhi honi chahiye ki maine koi name likha like akhilesh to next entry me bhi akhilesh aana chahiye matlab jo main default chahta hun vo every entry me date ya name same aane chahiye and jab main date like 7-aug-2015 likhi ya name change kiya to fir vahi same every entry me ani chahiye matlab last time jo main value enter karu vahi same aani chahiye saaree entries me please sir help me please.
Hi Akhilesh,
Field properties main ek option hain “Default Value.” Waha par jo bhi date ya, words likho ge, wo automatically har ek record me aa jayenga.
hello sir
sir field properties me jo option hai default value ka vo to sir ek field value ke liye hota hai jo hum default value set karte hain but sir main janana chahta hun ki main name field me “ajay” likhta hun aur entry karta hun fir next entry jo ayegi usme bhi “ajay” aana chahiye fir next entry karu to fir usme mujhe “karan” likhna hai “karan” likh kar entry karu to fir next entry me “karan” aana chahiye automatically mujhe baar-baar field properties me default na set karna pade koi aisa option hai sir default ka….!
like……!
both field default rakhni hai.
Date Name
1-Aug-15 ajay
1-Aug-15 ajay
1-Aug-15 karan
1-Aug-15 karan
2-Aug-15 karan
I am not sure about how to do that. Ctrl + ` ko press karne se record main last entry to repeat kiya jaata hai. Par automacially karne ke liye VB karna padega. Mujhe kuch mila to batata hu.
List kis format main hai? Agar excel main hair toh use ek Text file main convert kar de. Fir unko ek dusre ke baju main comma ke saath join kar de. Jab sabhi ko comma se join kar diya, use copy kar ke Access me paste kar de. Access ki field properties main “Lookup” section ke 3rd line main List hota hai. Wahi peh paste kar de. Koi aur tarika bhi ho sakta hai excel main, par mujhe pata nahi.
hii sir
sir mujhe 1000 name ki attedance table banani hai but main lookup wizard me agar saare name likhta hun to
usme 300 tak hi name accept karta hai aur row source me bhi nahi accept kar raha hai koi aisa tarika hai jisase jada list accept kar sake drop down banane ke liye
hello amir sir
sir ek question puchha tha apse lookup wizard ka list add karni hai sir apne jo bataya tha ki list row ko badane liye vo bhi maine kar ke dekha but usase koi fayada nahi hua aur koi tarika hai sir.
Thank you VERY much for your tutorials—these have been EXTREMELY helpful! I am operating on Access 2007 and this has been a huge help. The one particular thing I am trying to do is make an electronic dictionary using the Form feature of Access. This is a large database for a large dictionary with over 80,000 specialized entries. Video 8 so far has been the closest and most informative instruction to being able to replicate what I want. However, in entering in the string that you had in the video, I get back the error of a “Type mismatch” and then the Action Failed box appears. I downloaded the .zip file and when tried to open the .accdb file, was given the following error message: “Unrecognized database format ‘\\…” So I’m at something of an impasse. Could you please help me direct me on this? I can see that I’m very close to having the fundamental skill down on this and just need to complete it to start my overall project of making the dictionary.
Thank a lot for all your tutorials. I have learnt a lot from them. I do have a question though. I created the split access DB and is in the share drive. my backed opens in read only mode for other users which i dont want it to be. How can i fix it?
Hi Amir Bro.
apki in Data Access ki video ko dekh kar thoda bahut chalana aa gya hai Data Access.
Mera ek Question hai apse kya isme hum hindi k Font use nhi kar sakte kya jaise “DevLys 010” “Kruti Dev 010”
HI Rohit, kya aap Word main Hindi font use kar sakte ho? Agar Ha, toh Access main bhi type kar sako ge. Control Panel main Hindi Language or Keyboard add kar lo, fir hind main type kar sako ge.
Amir
Hi Amir,
I am a fan of all your Access video tutorials, from which I have refreshed a lot about and in Access. Thanks a lot for this and for the lucid and concise explanation of several features of MS Access 2007/10. I have seen your videos upto 6. Have you uploaded thereafter? Please continue doing the good work. All the very best.
Regards,
Dr D Rajan
Dear Amir,
In Access, the Forms are for users while database tables are not made available to them, so the user can input more rows to the table ( for which the form is provided); also the form cannot update other tables, if I am correct! Now my question is how can you make the table(s) inaccessible to the users inputting the data thru the Forms? The Encrypt PW option blocks the entire database and its objects including the forms, queries and reports! So how this is overcome to allow users use only the Forms and the DBAs handle the DBMS.
Dr Rajan
Thanks for both the methods as tips for my question; i have not tried them yet; let me try them and will surely let u know my experience reg. restricting users from using the database tables while they input data thru Forms.
Thanks,
Dr S.Durairajan
your learning videos are great. they are very helpfull for my next exam. I want a favour from you. can u help me to learn VB & java. if u have any video or material for learning basic of both then plz share. I have exam next month and i never done programming. I want to understand basics first. After that I can practice and learn. Thanx in advance
I watched your videos and was really helpful, and i have no experience in ms access but now i am in good position, thank you for you supporting videos, please continue your videos in other aspects also. Thank you very much
Respected sir,
your lectures are really treat to have.
i am learning with step by step and definately gaining every day.
thanks..
is it possible in access to flash the files/data which are more than a specified days?
Hi Vinay, what do mean by Flash the files/data? Do you mean to remove, move, or delete records? You can create queries that will either Append your data to another table, or create a brand New table or even Delete records. You can also Append and then Delete the records, for this you will create 2 queries, now create a macro that will run both those queries.
respected sir,
thanks for replying..
sir for an example let suppose i have created an account dataabse of employees in access and there are so many entry . one of the entry is for showing the EMI for amount of the loan taken by the loan. in real world some time we need to have a glance to check the list . is it possible whenever i open the database that “entry” is flashing itself in the list . clearly flashing will be treated as a reminder.
Since a while I am searching internet for Access Tutorial and I watched many teaching videos in YouTube to learn some basics of Access; a few days ago I watched your 1st vedio it was so useful for learning and then I searched and watched all the vedios you shared in the net, it is so useful and you really done a best job.
Hi amir,
I watched your video and previously i don’t know about access much more. But after your all Hindi video I learn a lot.
I am pharma sales professional.
I require your help…for few query.
Thanks
Waiting……
Hello dear brother
Hope you will be fine
I saw you tutorials and I fell in love with you
I found your style much easy to follow the complex concepts of access.
I love to learn more trick and logics on how to write code, expressions and formulas in access to build some program for my personal use, but I am not a developer, with zero knowledge of programming I have developed a very nice piece of tool that helps me in my practical life.
You are requested to give me tips on how to write codes, expressions or mathematical formulas to work flawlessly. I want to learn basics of on this so that I can become professional in writing and building.
Awaiting for your kind cooperation and help on the project. I have sincere prayers in my soul for you
Hi M Mukhtar, thanks for your comment. Very happy to see you have found my YouTube videos useful. I have not gotten too far in programming, still on my to do list, trying to get a hand of Python programming. However, I give you some tips, hope it will help you.
Learning any programming language will be good, as they will help in learning Access VB programming. https://www.sololearn.com/ (learn whatever you like, I would suggest Python)
Learn SQL: https://www.codecademy.com/catalog/language/sql https://www.tutorialspoint.com/sql/index.htm
Thanks Amir. Your teaching style is simple and yet powerful.
I am a senior citizen. i wished to learn access always got confused in some matters and gave up.
I tried many times and give up. Now I got once again interest after watching your lesson 6.
May God Bless you with good health and happy life.
Thanks.
Shabbir
I want to study access database and i’m a student in Cambodia.
so sorry you can send soft database to me.
thanks you please good luck for you.
I enjoyed learning access from your website. I like the fact that you are quite methodical and you do not assume a lot like many videos I have watched including stellar websites like in Lynda.com. You explain in a very simplified way which is beneficial for a beginner. I will not use Access to organise my contact list for a community organisation I work with. Kind regards from Glasgow UK. http://www.sauti-nexus-projects-and-training.co.uk
Very glad that you liked the Microsoft Access videos. Check out my Youtube page I have videos for Word, Excel, PowerPoint & Outlook.
http://www.youtube.com/simpletektoronto
All the best.
Amir
Dear sir, 1) how to lock the report of Company,address, tel no..etc.
2) I am using query to key in the period 1/1/18 to 31/5/18 and how to show the period in the report
3) There are two reports one is profit & loss a/c another is Balance sheet , from the profit & loss a/c I
have get profit amount , and now how to put this amount to Balance sheet report
HOPE YOU CAN SOLVE IT! THANKS
Thank you Brother
I watched your first video and was really helpful, i am taking Database Management, and i have no experience of building table, thank you for you supporting videos, I will continue watching until i learn.
I really enjoyed very much coz your way of teaching is really amazing! it’s quire simple, direct, clear, and easy to understand with very logical way and steps to follow..
Many Many thanks my dear for this great effort!
Ahmed Alsaffar
Saudi Arabia – Qatif
Hi Ahmed,
Very glad that the tutorials video have been useful in your learning. Thanks for taking the time to post a comment, messages like your make it all worth it.
Amir
Dear sir, 1) how to lock the report of Company,address, tel no..etc.
2) I am using query to key in the period 1/1/18 to 31/5/18 and how to show the period in the report
3) There are two reports one is profit & loss a/c another is Balance sheet , from the profit & loss a/c I
have get profit amount , and now how to put this amount to Balance sheet report
HOPE YOU CAN SOLVE IT! THANKS
I really enjoyed your Access videos. Everything about your way of teaching is amazing. Thank you so much.
I wonder if it would be possible for you making some on the SharePoint designer SW.
DS
Dear Amir,
Thanks a lot for the video on MS Access.it was very informative and everything was explained in a very clear way.It has given me a good base to go for advances Access.Keep it up… 🙂
Brilliant, really very clear. I haven’t watched No.4 yet but hope it explains how to print labels from a table, not all records, in my case I just want to pull out those to whom I want to send a Christmas card. Also how to format a field. I have cracked it in a record but not labels. Thanks, Marco
Hi,
Thanks for the comment. The 4th video does not show how-to print labels. I never thought about it. But I looked at it quickly. To create Labels, click on CREATE tab and click on LABELS. Choose the Manufacturer of the Label paper and choose the Product number. Follow the steps and choose the way you want to arrange the Name and Address using the arrow (remember to add spaces). Then finish the wizard and print it.
Hope this helps. The other option would be use Mail Merge to create labels and use the Database as your Source data.
Amir
Hi Rakesh,
Im a prinicipal of a Govt College in Bangalore India. out of some academic interest I i happened to stumpble upon your website and watch videos on access. Videos made by you are really educative and simple to understand. I think that even a high school student can learn a lot from your basic videos. you have a mastery of the topic and blessed with a real good voice.
I want you to do videos on dotnet programming as well as tutorials on sql 2008. This would really help people like me.
Thanks a lot again for this wonderful video set. May god bless you with health wealth and happiness.
Hi,
Thanks for your comment. I have never spent any time learning programming, in fact I have recently taken on to learn computer programming using Python from Khanacademy.org. I would highly recommend anyone trying to learn Math/Science skills to visit Khanacademy.org.
I will think about looking into .net and sql programming. My background being in networking and tech support & training; I have gained a lot of experience in teaching Microsoft Office.
Thanks again. Please visit my Youtube channel as I have posted more videos there, which I have not added to my website.
Amir
http://www.youtube.com/user/simpletektoronto
I really impressed watching your videos in Access and I benefited a lot from these videos. I watched all the four videos which were clear and very simple manner. I hope more from you about it. Can I get more videos about access through you.
I have suggested many of my friends to get watch your videos. Thanks a lot for such your social and educational attempts.
Ram Gurgagain , Pokhara, Nepal
7 feb, 2013
Hi Ram Prasad,
Thanks for your message. I added a 5th video for MS Access on my YouTube channel, but forgot to add it to my website. Here is the link http://www.youtube.com/watch?v=h8TM240tpBM
You can also check my YouTube channel for other videos. http://www.youtube.com/user/simpletektoronto
Also watch my video on Lines to Free Online Courses. It lists many websites online where you can learn many things for free.
Will continue to add more videos on different topics.
Thanks
Amir
Dear Amir,
I am working in ADNOC (Abu Dhabi National Oil Company) at Ruwais (240 KM far from Abu Dhabi) I was surfing the internet/YouTube and came across your tutorials about MS Access. I must appreciate you for such a nice tutorials you uploaded on YouTube. In fact long back (in 2002) I tried to learn it in an academy; I had to give up due to lake of timing (I had to travel 240 KM) on weekends as well as maintaining my family. Another fact was that I was not much more familiar with YouTube at that time.
Now I got a very good understanding of MS Access. Once again thanks a lot.
Regards,
Dear Sir,
AWESOME VIDEOS, watching your videos of Access made me more and more confident on me, I benefited a lot from these videos like others.
Yours videos are in very useful for every one and clear to understand. if possible, request you to upload more videos about access.
Thank you, Thank you so much for your videos.
Thanks & Regards
Hi,
Thanks for your message. I am very happy that these tutorial videos have been helpful in your learning. I had added a 5th video for Access on my YouTube channel, but forgot to add it to my website. Link is below. I also added 6 videos for Microsoft Access 2003.
Microsoft Access 2007/2010 Basic 5: http://www.youtube.com/watch?v=h8TM240tpBM
Access 2003: http://www.youtube.com/playlist?list=PLcmYWY91gQNebBu9x8NaxKtEEgfAVYSQc
With regards and all the best.
Amir
Hi Amir ! Thank you very much for your video tutorials on you tube.I am from a small village in Maharashtra,India.
I am looking for tutorials for visual basic 2008 express edition. If you have please send me links.Thanks again.
Thank you Amir for your Acess 2007 Tutorials.
It has enabled me to write a Asset Tracking Database.
I have “Users”, “Locations” and “Equipment”.
I now want to do an Audit.
Input User
Input Location
Input Equipment (Several pieces)
I then need to report on what is now missing from a location and if it is at another location.
Can you help?
Regards
Brian
Thanks Amir. Your teaching style is simple and yet powerful.
Thanks Mohsin, appreciate you taking the time to send your thanks.
Great job man
Thanks a lot
Hi Amir,
It was very knowledgeable tutorial and most importantly the way you tried to explain each and every thing.
I was new to the access and now i started making few tables and report for my job related purpose.
Thanks a lot
hey Amir.please help.
Hi, sorry for the delay in responding. Have been busy with work and comments on YouTube. Your project is very big and I don’t consider myself an expert in Microsoft Access, I can try to answer some questions. But this will take a long time to get done.
All the best.
Amir
Hi Amir,
I have just started watching these and am finding them very useful. Since this is new to me, and I need to use it for my job, I was struggling to begin, but these videos have made it helped a lot.
Thanks a lot for your effort!!
I have a query and wanted to know if you could please guide me:
I need to populate various fields for more than a 1000 companies – company name, year of establishment, geographic presence, telephone numbers, website. out of all these fields, Geographic presence and telephone numbers have more than one entry for most companies.
Since I have to capture all such information for every company, should I make seperate tables (like different sheets) of is there a way to tabulate them in one sheet.
I an excel file, I would have probably merged the number of cells for the company name for it to appear as one block. Not really sure, how it should be done in acess.
Your help would be much apprecieated.
Regards,
Pooja
Excellent!!
Please, keep us get going and uncover the surprising effect of ‘’Simple Tek’’
Tariku A
San Jose ,California
Hi Amir,
Wanted to send you a quick THANK YOU note for the MS Access tutorial you setup on Youtube. I never leave comments, but felt compelled to tell you how EASY your tutorial is to follow. Also, I’ve wanted to learn Access for quite some time, but all the videos I’ve seen, just never explained it as WELL as you have. So I finally understand the basics and will DEFINITELY be looking at your MS Project videos. And I will probably look at your Excel videos as well, even though I am pretty good at Excel, I have a feeling you will go over something I may have overlooked.
Your a gifted teach. Thanks for your taking your time to help me/us all out.
All the best,
Ben
East Coast, USA
Really great videos helo in passing my IT Practical of Institute of Chartered Accountant of Pakistan. Really great work. Please make a list of all lectures on youtube as well in a sequence.
Amir, thanks so much for your Access tutorials. I have watched all 6 and “played along” in Access, and in just one morning I can do everything I wanted to be able to do with my data, with zero prior knowledge in Access. I’m generally computer savvy, but I’m so glad I watched your videos instead of trying to figure it out myself! Thanks again and keep up the good work, you have a great teaching style.
Hi,
Thanks for the email and it also reminded me that I had not added the 2 more Access videos to my list. I had added 2 more videos to the Access 2007/2010 series. I have added them to the page and also pasted the links to this email.
https://www.youtube.com/watch?v=FhqufQgnC9s&list=PLF9EEC64682C23B99&index=7
https://www.youtube.com/watch?v=TCaZ7AFZjpY&list=PLF9EEC64682C23B99&index=8
Amir
I have watched several of your videos on 2007/2010 Access……….I am try to build a data base that will allow me to use a form to store multiple completition dates. For instance, maintenance completed on 2 Oct 13, 10 Oct 13, 16 Oct 13……..But once I mark it completed the date will be saved in a table, but show blank the next time I open the form for that piece of equipment. And be able to run a query and report of all the dates maintenance was completed.
I just put a number in the Capta block, I’m not sure what it is……
Dear Amir
i am very new to access though i was using MS office for a long but access is an Optional in MS office.
Only after watching your video it interested me to go deep into it. ( I was familiar with Fox pro2.6)
congrats for simple way of teaching access.
Well I want to know how to use number field . I use it with 2 decimal .5v
my issue is while entering the data say 12.35 it round up to 12 or say 12.65 turns to 13 ?
how to resolve it . at present I using with currency data .
No 2 :
In form usiing calculation -calculated amount to replace in respected field.
say unit 3
rate 4
amount 12 ( in form it calculate and show in amount ) but in database instead of 12 it show blank ?
pls reply me .
Thanks u very much Amir Brother. very easy and nice way of teaching…….. i like the way u make Access so easy for us. May Allah Bless u.
Hi Amir Bhai,
I really enjoyed very much coz your way of teaching is really amazing!
it’s quire simple, direct, clear, and easy to understand with very logical way and steps to follow..
Many Many thanks my dear for this great effort!
If you give instructions in Hindi Language your videos are much useful for Indians coz they understand better in hindi.
Dinesh Kedia
India
Hello there,
Thanks for the videos. However, the 4th video doesn’t show us how the relationship is been created and i think that is the primary purpose of the video.
We will appreciate it if my message is responded to soon.
Cheers
Hi Dear Amir, How r you hope doing well……. i’m very glad an thankful of you for very very valuable video tutorials. these videos helped me a lot. if you don’t mind i have very humble request to you. Please video tutorial for AUTO CAD is possible..? i’ll be very thankful to you if you help me in AUTO CAD……………….
If its is not possible then please can you tell me any nice(like your method) video tutorial link that really help me
Waiting for your prompt reply
Thanks and Best Regards
USMAN BASHIR
Hi,
Thank you very much for your video for access 2007/2010.
can you complete all the tutorials for this section.
for orders it will be help if you create order form where customers, product details, and total price come on one form.
Thanks again.
RJ
I Amir,
I have seen your access 2007 tutorials on YouTube. Heads off to you mate.
I was a very very useful to me. Your way of presentation is best. I will follow the same in your website.
Cheers……
Suresh Negi
I can’t believe that I am actually learning Microsoft Access from Youtube tutorials (in this case your tutorials). To the point, lots of great information but not boring, great pace. Thank you soooo much.
Keep it up !!!!!!
Thank you Amir. I really enjoyed and I learned a lot from your videos.
Hello Amir,
First of all, thank you very much for helping the people by such a nice way. really your video training is excellent among all the video tutorials i have ever seen.
you are the best one ….
it is really help me to lot to understand the ACCESS very well.
Thanking you.
With kind regards,
Patel.
Hi Amir,
I was very new in access, I mean I don’t know even how to start access, but after your training I have completely understood what is an access is and now I have created so many projects in access.
Thank you very much for your absolutely free training.
Hi Amir,
I’m an expert using MS-Office especially (Excel), however I’m completely [NULL] on Access even I’m trying to learn it from so many months but which was not done till date. But today from afternoon I’ve watched all your 6 videos (of course will watch the 7th by 2morrow morning) and I started using Access just like the Excel. In our world there are few people are blessed with such amazing talents and you are one of them. May god bless you with health and wealth.
*Once again Thanks a lot for those wonderful tutorial videos.
Naveen Kumar Rayana
HR & MIS Manager.
Hi Mr. Parmar
I am rally thank you very much for your tutorials videos, I am 66 years-old and I am retired now, I studied Microsoft Access 3 long time ago but, unfortunately, neglect it for 15 years since I did emigrate to USA.
I am very interested of Microsoft Access so I tried to refresh my knowledge to match Microsoft Access 7 I have on my computer and I found difficulties to read books, then I look-up for some tutorials may help me to obtain my goal, and you did that in a very easy and clear way, your videos are truly helpful, your efforts are truly appreciated. we need you to complete doing favors by more explanation to relations between tables and more focusing on module.
Thank you again
really its very helpful..thns to upload videos…..
Thanx a lot sir……u r great …what a way to teach and make things simple and elegant…. superb..
thanks
hello sir please upload one access titoriyal in hindi ( qeury by date ) like 1oct 14 15 nov 14
passbook entry titoriyal
Hi, in query Criteria you can type this
Between [Enter Start Date] And [Enter Last Date]
when you run this Query 2 prompts will pop up for the start and end date. And the words [enter start Date] [Enter end date] you can add any words you like to help the user to understand how they are supposed to enter the dates.
Hope this answers you question.
Amir
Wonderfull,…..I want to usu Microsoft Access, Because i want to make a Database For My Item, so I want to say Thank You Verry Much For You Tutorial….and…Always Success….!
Thanks. All the best. Amir
dear sir ,
is Access useful for Financial Analysis ? , Like i put financial Report and extract Ratios .
moataz
Hi Moataz,
If you can get your information from Excel, I would not bother with Access. It might require lot of work to get Access to get things done. And some people might be taking their data from Access and Export it to Excel to do some work. You could look around and see if someone in Financial Analysis is using Access, as I don’t have much knowledge on that topic.
All the best.
Amir
Your videos help me lot to understand ms access. Please issue some more advance level videos also.
Thanks,
Subhash
Hi, Amir!
I have a task in access and i can not find a function for it. I have a table like this:
ID Team Leader Agent Name Reason 1 Reason 2 Reason 3
1 a b 1.1 1.2 1.3
2 a b 2.1 2.2 2.3
3 c d 1.1 1.2 1.3
4 e f 2.1 2.2 2.3
The table contains the interactions of some agent with the customers and the reason for interaction. I need to make a query that contains the agents(no duplicate), team leaders and the total interactions for each agent.
In Excel I used count ifs, but in acces i’m confused.
Can you help me?
Thanks,
Ana
Hi Ana,
Create a query with Agent, Team leaders and the interactions field. in the design view of the query go to “Property sheet” and in there you will see an option for “unique” make it yes.
Another thing you could also try is create a Report based on this query and during the wizard, try to Group it by Agent. And you will also get an option to choose “summary” and you choose the Count option. Or later in Report Design you can add the Count.
Amir
I love ur tutorials, they r realy helpful. Thanks 4 ur good work.
hello sir,
my name is akhilesh and i am from haryana india sir apki help chahiye sir maine apke saare access ke video dekhe hain aur bahut kuchh seekh gaya hun and ab main apna work easily kar pa raha hun but ek aur help mil jaye agar apki to bahut mehrbani hogi sir actually like koi hum table banate hain and us table me kuchh value default rakhni hain like date and name etc. but ek hi date ya name nahi like maine 6-aug-2015 likha to next entry me bhi automatically same date aani chahiye jab tak ke main khud date change na karu yahi chij name me bhi honi chahiye ki maine koi name likha like akhilesh to next entry me bhi akhilesh aana chahiye matlab jo main default chahta hun vo every entry me date ya name same aane chahiye and jab main date like 7-aug-2015 likhi ya name change kiya to fir vahi same every entry me ani chahiye matlab last time jo main value enter karu vahi same aani chahiye saaree entries me please sir help me please.
akhilesh kumar
india.
Hi Akhilesh,
Field properties main ek option hain “Default Value.” Waha par jo bhi date ya, words likho ge, wo automatically har ek record me aa jayenga.
Amir
hello sir
sir field properties me jo option hai default value ka vo to sir ek field value ke liye hota hai jo hum default value set karte hain but sir main janana chahta hun ki main name field me “ajay” likhta hun aur entry karta hun fir next entry jo ayegi usme bhi “ajay” aana chahiye fir next entry karu to fir usme mujhe “karan” likhna hai “karan” likh kar entry karu to fir next entry me “karan” aana chahiye automatically mujhe baar-baar field properties me default na set karna pade koi aisa option hai sir default ka….!
like……!
both field default rakhni hai.
Date Name
1-Aug-15 ajay
1-Aug-15 ajay
1-Aug-15 karan
1-Aug-15 karan
2-Aug-15 karan
I am not sure about how to do that. Ctrl + ` ko press karne se record main last entry to repeat kiya jaata hai. Par automacially karne ke liye VB karna padega. Mujhe kuch mila to batata hu.
thanks sir
for make my work easy
hello sir
sir main ms access table me lookup wizard me 1000 above list add karni hain kaise karenge…!
akhilesh
List kis format main hai? Agar excel main hair toh use ek Text file main convert kar de. Fir unko ek dusre ke baju main comma ke saath join kar de. Jab sabhi ko comma se join kar diya, use copy kar ke Access me paste kar de. Access ki field properties main “Lookup” section ke 3rd line main List hota hai. Wahi peh paste kar de. Koi aur tarika bhi ho sakta hai excel main, par mujhe pata nahi.
hii sir
sir mujhe 1000 name ki attedance table banani hai but main lookup wizard me agar saare name likhta hun to
usme 300 tak hi name accept karta hai aur row source me bhi nahi accept kar raha hai koi aisa tarika hai jisase jada list accept kar sake drop down banane ke liye
Hi Akhilesh, field properties ke Lookup section mein ek “List Rows” ki line hain. Is line ke number ko bada do.
hello amir sir
sir ek question puchha tha apse lookup wizard ka list add karni hai sir apne jo bataya tha ki list row ko badane liye vo bhi maine kar ke dekha but usase koi fayada nahi hua aur koi tarika hai sir.
akhilesh
Yeh tum Table main ho ke form. Agar form main ho to form ki properties main me properties “list row” ko badle. Aap ko ek scroll milna chaiye.
Dear Amir,
Thank you VERY much for your tutorials—these have been EXTREMELY helpful! I am operating on Access 2007 and this has been a huge help. The one particular thing I am trying to do is make an electronic dictionary using the Form feature of Access. This is a large database for a large dictionary with over 80,000 specialized entries. Video 8 so far has been the closest and most informative instruction to being able to replicate what I want. However, in entering in the string that you had in the video, I get back the error of a “Type mismatch” and then the Action Failed box appears. I downloaded the .zip file and when tried to open the .accdb file, was given the following error message: “Unrecognized database format ‘\\…” So I’m at something of an impasse. Could you please help me direct me on this? I can see that I’m very close to having the fundamental skill down on this and just need to complete it to start my overall project of making the dictionary.
I hope you got my email reply.
Hi,
Is it possible to send email to more then one person using email database object macro?
you could add a comma , or a ; between each email address.
Hi Amir
Thanks a lot for such a highly useful videos…
your style of teaching is really very fantastic…..
Bless u !
Hi Amir,
Thank a lot for all your tutorials. I have learnt a lot from them. I do have a question though. I created the split access DB and is in the share drive. my backed opens in read only mode for other users which i dont want it to be. How can i fix it?
Hi Aarthi, you said the backend opens in read only mode? Do you mean the Front end? Do all users have “full permission” to the shared drive?
Hi Amir Bro.
apki in Data Access ki video ko dekh kar thoda bahut chalana aa gya hai Data Access.
Mera ek Question hai apse kya isme hum hindi k Font use nhi kar sakte kya jaise “DevLys 010” “Kruti Dev 010”
HI Rohit, kya aap Word main Hindi font use kar sakte ho? Agar Ha, toh Access main bhi type kar sako ge. Control Panel main Hindi Language or Keyboard add kar lo, fir hind main type kar sako ge.
Amir
thank you very much Sir,
to post this access video
thank you very much for your videos…
Briliant video so thak you so much aamir sir
kya aap tally ke videos bna skte hai
Tally kabhi use nahi kiya.
Sir,
how do i download all videos at a time
Not sure if it is possible. The videos are on YouTube, so you can watch it anytime.
Hi Amir,
I am a fan of all your Access video tutorials, from which I have refreshed a lot about and in Access. Thanks a lot for this and for the lucid and concise explanation of several features of MS Access 2007/10. I have seen your videos upto 6. Have you uploaded thereafter? Please continue doing the good work. All the very best.
Regards,
Dr D Rajan
There are more videos, here is the link to the playlist for Access https://www.youtube.com/playlist?list=PLF9EEC64682C23B99
And here are all the play list https://www.youtube.com/user/simpletektoronto/playlists
Very happy to know that you have found my YouTube tutorials useful in your learning.
All the best.
Amir
Dear Amir,
In Access, the Forms are for users while database tables are not made available to them, so the user can input more rows to the table ( for which the form is provided); also the form cannot update other tables, if I am correct! Now my question is how can you make the table(s) inaccessible to the users inputting the data thru the Forms? The Encrypt PW option blocks the entire database and its objects including the forms, queries and reports! So how this is overcome to allow users use only the Forms and the DBAs handle the DBMS.
Dr Rajan
There is an option by which you can Hide all the tables and queries. Another option is to split the database, so the backend all the data etc on the Server and front end on the users pc has only the things they need.
https://support.office.com/en-us/article/Split-an-Access-database-3015ad18-a3a1-4e9c-a7f3-51b1d73498cc
Hiding tables: http://www.techrepublic.com/blog/microsoft-office/hide-access-tables-to-safeguard-them-from-users/
Hope this helps. All the best.
Amir
Thanks for both the methods as tips for my question; i have not tried them yet; let me try them and will surely let u know my experience reg. restricting users from using the database tables while they input data thru Forms.
Thanks,
Dr S.Durairajan
Dear amir,
your learning videos are great. they are very helpfull for my next exam. I want a favour from you. can u help me to learn VB & java. if u have any video or material for learning basic of both then plz share. I have exam next month and i never done programming. I want to understand basics first. After that I can practice and learn. Thanx in advance
Hi Hemant, I am sorry but I have never learned any programming language. it is on my to-do list, but never get excited about learning it. I am really hoping to get into .Net and VB. Maybe soon. I am hoping that you know about good resources online Khanacademy.org has a good foundation in Python, Codecademy.com is also good. And also these
https://www.edx.org/course/subject/computer-science
https://www.coursera.org/browse/computer-science?languages=en
https://www.futurelearn.com/courses/upcoming
all the best.
Amir
Dear Sir,
your All video is excellent but please suggest how is it download
Hi Raj, all my videos are on YouTube, you can watch it whenever you want or make it Offline on your smartphone.
Very nice work and helping stuff.. thanks aamir
Hi dear Amit,
II am a fan of all your Access video tutorials, from which I have refreshed a lot about and in Access.
Please provide all access soft database.
Hi Ranji,
What do you mean by Soft Database? I don’t have many database, the samples I have are on my website.
I watched your videos and was really helpful, and i have no experience in ms access but now i am in good position, thank you for you supporting videos, please continue your videos in other aspects also. Thank you very much
All the best.
Dear Amir
thak u for ur jobe good
thanks
Respected sir,
your lectures are really treat to have.
i am learning with step by step and definately gaining every day.
thanks..
is it possible in access to flash the files/data which are more than a specified days?
Hi Vinay, what do mean by Flash the files/data? Do you mean to remove, move, or delete records? You can create queries that will either Append your data to another table, or create a brand New table or even Delete records. You can also Append and then Delete the records, for this you will create 2 queries, now create a macro that will run both those queries.
Amir
respected sir,
thanks for replying..
sir for an example let suppose i have created an account dataabse of employees in access and there are so many entry . one of the entry is for showing the EMI for amount of the loan taken by the loan. in real world some time we need to have a glance to check the list . is it possible whenever i open the database that “entry” is flashing itself in the list . clearly flashing will be treated as a reminder.
Hi Vinay, I have never done that, but see this link for instructions on doing that
http://www.databasedev.co.uk/control_flash.html
this is for Access 2003 but it seems clear: https://www.techonthenet.com/access/forms/flashing.php
amir
Thankyou sir. Am seen all video, your good teach .
Since a while I am searching internet for Access Tutorial and I watched many teaching videos in YouTube to learn some basics of Access; a few days ago I watched your 1st vedio it was so useful for learning and then I searched and watched all the vedios you shared in the net, it is so useful and you really done a best job.
Thanks
Sayed Wali Safi
All the best Sayed. All my videos can be found easily via the YouTube Playlist
https://www.youtube.com/user/simpletektoronto/playlists
There are also some Hindi tutorials: https://www.youtube.com/user/ComputersHindi/playlists
Sir please sent me database file
file is on the website.
Hi I Learn ms Access i am Primary Teacher in Z.p. solapur state maharashtra
Hye Amir can u make tuto using Access 2016?
tutorial with access 2016? The ideas in Access 2013 applies to 2016, there is not much difference.
Hi amir,
I watched your video and previously i don’t know about access much more. But after your all Hindi video I learn a lot.
I am pharma sales professional.
I require your help…for few query.
Thanks
Waiting……
Hello dear brother
Hope you will be fine
I saw you tutorials and I fell in love with you
I found your style much easy to follow the complex concepts of access.
I love to learn more trick and logics on how to write code, expressions and formulas in access to build some program for my personal use, but I am not a developer, with zero knowledge of programming I have developed a very nice piece of tool that helps me in my practical life.
You are requested to give me tips on how to write codes, expressions or mathematical formulas to work flawlessly. I want to learn basics of on this so that I can become professional in writing and building.
Awaiting for your kind cooperation and help on the project. I have sincere prayers in my soul for you
Hi M Mukhtar, thanks for your comment. Very happy to see you have found my YouTube videos useful. I have not gotten too far in programming, still on my to do list, trying to get a hand of Python programming. However, I give you some tips, hope it will help you.
Learning any programming language will be good, as they will help in learning Access VB programming.
https://www.sololearn.com/ (learn whatever you like, I would suggest Python)
Learn SQL: https://www.codecademy.com/catalog/language/sql
https://www.tutorialspoint.com/sql/index.htm
Have sense of functions available in Access and what they do https://support.office.com/en-us/article/Access-Functions-by-category-b8b136c3-2716-4d39-94a2-658ce330ed83
https://blogs.msdn.microsoft.com/mapo/2008/06/15/newbie-to-coding-want-to-do-some-net-development/
All the best.
how can i subscribe to join your page
Hi, it might be better to subscribe to my YouTube channel
Hindi: https://www.youtube.com/user/ComputersHindi/playlists
English: https://www.youtube.com/user/SimpleTekToronto/playlists
Thanks Amir. Your teaching style is simple and yet powerful.
I am a senior citizen. i wished to learn access always got confused in some matters and gave up.
I tried many times and give up. Now I got once again interest after watching your lesson 6.
May God Bless you with good health and happy life.
Thanks.
Shabbir