Have watched numerous training videos, bought various books on Access, none of them have the training value Amir's videos have. Microsoft Access has the reputation of being hard to learn, I would agree. Even though I built a very nice sales/inventory program for online selling, I was apprehensive if I had done it right as it was my first Access project. Now that I have found Amir's UA-cam videos, its like a light bulb has come on. I'm seeing Access with a sense of excitement, I get it. So many possibilities now. I'll be going through my project verifying, editing what I have done to this point with confidence. Thanks a million for your efforts Amir, your a great teacher, so easy to understand!
Mr Amir Absolutely the best training video I have used. Everything you have shown me I have been able to adept into my database and use it. I'd recommend your tutorials to anyone.
Amir thank you very much, Not only did you present functionality of Access but also, you have answered WHY we use Access! No matter how many tutorials I've watched no one could clearly pin point WHY we are doing what we're doing. :)
I am so happy i came to your U-Tube channel, Really! I have found your explanations to be helpful for the beginner, like myself. I am a student in the university in San Juan Puerto Rico. Attending class when a new lesson is introduced, helps me understand what the teacher is talking about. Your great!!!!!
Mr. Parmar, You are an excellent instructor. Very smooth video presentation, clear, easy to follow, you've helped me so much already. I will definitely recommend you to friends. Thank you.
Viewing this in October 2020....found everything I was looking for...very thorough and clear Amir!..Thanks a million - you got through such a lot in a short time - most grateful - Thank you !
my subject is all about database (DATAMAN database management) this semester. all of these tutorial you were teaching was everything that we discussed throughout the semester from making tables down to reports..and i honestly didnt get and understand my instructor becausw he talks very fast and most of the time i am absent. 😂 I viewed this video but its already our final examination and were done with this subject. haha too late i only got low low grade. 😭😭 if only i have watched this video early 😭😭😭😭
+Evan de Guzman When creating your report pick your fields from one table, now change the table (you will see a drop down above next to the table name) and pick the fields of the 2nd table. And finish the wizard. You can also create a query with fields from 2 tables and make a Report based on this query.
+Priyanka Sharma I do show how to make a form that has a subform using the wizard, maybe in the next video. Also when you are in the Design view of the form, look for Subform button in the tools, click it and drag it below the form and follow the prompts. all the best.
Hi, I performed the same steps and was able to use the command button wizard, but it has become non-functional now. I am not able to use it, I click on the button option and the command button appears but the wizard is not functional anymore. What I can I do in that case? Thanks a lot for the videos, really helpful.
+Priyanka Sharma It might be due to the way the Mouse is used after clicking on the command button. Once you click on the Button, you drag the mouse on the form, make sure you are using the Left click and that you are not letting go of the mouse click. Close the file and open again and try.
+Priyanka Sharma I hope I made sense about dragging the mouse. You click on the wizard button, let go of the mouse, now bring the mouse where you want to place the button, Now drag the mouse with the Left click and leave once you have the desired shape. And you can always change the shape.
Hi Mr Amir Thanks for your helpfull clips these were really useful for me. I had a question regarding the part where you insert the option button for genders. there is only a value of 1 and 2 showed up. is there any why that we can change it into male or femal as text? if you dont mind shooting a video on that part I will be thankful please.
You can always use the Lookup wizard and choose "I will type the values" and type Male and female and create a list. This way it will say Male or Female when chosen.
+Mudy Ayela Hope you found the next video (4th) which talks about Relationship, here is the link to the playlist ua-cam.com/play/PLcmYWY91gQNcB-9D2him9oNl86FpCxCHc.html
Hi, Amir, Your videos are great but for kids !!! All this and beyond this I did as a kid, I am looking for complex DB where I need assistance with VBA. You have any idea or if you can upload a video for the same. Thanks Bro.
Ya these are pretty much elementary videos. I don't now much about Access; my intention was to help people pass employment tests for basic Access. People asked question, so ended with more videos. Check out some online websites, there might be some paid tutorials.
Mr. Parmar, Thank you once again for your wonderful instructions and replies to my questions and comments. I have a new situation: I created a query from one of my tables and successfully selected certain information everything works beautifully until I ask it to COUNT records. In your example, you use Access 2013 and I have Access 2016 so I do not have the same layout of the Ribbon and when I click on the Sigma it does not allow me to select "Count Records" - it does not exist in my version of Access. Could you p[lease help me once again? I'd appreciate it very much. Thank you in advance once again. Chuck Sotis
Hi Amir, I am new to microsoft access and your videos are big help to me. I have question regarding to "not like statement in queries" I have three tables from external data source and I created a query with some columns from all three data sets. In particular one column name with Job title there are multiple categories and I dont want data with three categories for example A, B and C so I wrote not like "A" or not like "B" or not like "C" but its not working then I wrote not like statement in three different line but its still not working so to get desired data I had to creat three different queries but I believe there must be some efficient way to do it. I will really appreciate if you can help with this.
Hi Jenna, I have not been exposed to SQL. You will find some really good info on SQL on these links www.sololearn.com/Course/SQL/ www.khanacademy.org/computing/computer-programming/sql
Hey buddy, how do I save the previous report ?? the way u do it on the video, if u do a new search u will lose the first report. First u selected Canada and the reports shows Canada, the next u type USA, but where is the Canada u did first ? All the videos looks like the same and doesnt show the main propose of the report that is save all searches u do.
to save the Search criteria, create a simple query and in the Criteria type the Canada or the search criteria of your choice. And save this query, whenever you run this query it will only give you that Results. Create separate one's for other such query. The idea of query is not to save the Results, but just to save the Criteria. To save the Results, you have to save the file separately to Excel or word or pdf. Or you could create a query that will create a separate table, but then you will end up with many tables with data.
Karan Maharjan Create a query based on a table, once created, go to the Design view of query, in there you will see an option "Make table" there is also option for "Append" or "Update" table.
I am trying to make a form that uses a combo box to present a list of contact names and IDs. then when the user chooses one, I woudl like it to populate the rest of the text boxes with the fields for that contact's information. So I'm trying to use it as a look up form. But I cant seem to figure out how to make it work- Help?
BigTimeCrafting you can add a text box add a calculation like =field1*field2 field1 and 2 will be then name of the boxes that have the amount that need to be calculated. I believe in the later videos I talk about it. It is the same like creating calculation in Forms.
I am trying to write code in Data Validation Rule for proper case. syntax- StrConv([Field Name], Number) but i am not geting output , but when i write this code in query form to field option ,then i i get output in particular table's field name.
get any screen capture software to record your screen, voice and mouse strokes. I am using this company, their express version is free www.flashbackrecorder.com/compare-features/
Have watched numerous training videos, bought various books on Access, none of them have the training value Amir's videos have. Microsoft Access has the reputation of being hard to learn, I would agree. Even though I built a very nice sales/inventory program for online selling, I was apprehensive if I had done it right as it was my first Access project. Now that I have found Amir's UA-cam videos, its like a light bulb has come on. I'm seeing Access with a sense of excitement, I get it. So many possibilities now. I'll be going through my project verifying, editing what I have done to this point with confidence. Thanks a million for your efforts Amir, your a great teacher, so easy to understand!
Mr Amir
Absolutely the best training video I have used. Everything you have shown me I have been able to adept into my database and use it.
I'd recommend your tutorials to anyone.
Great comment! I also plan to like you. Learn from it, and implement for my own database!
But
Amir thank you very much,
Not only did you present functionality of Access but also, you have answered WHY we use Access!
No matter how many tutorials I've watched no one could clearly pin point WHY we are doing what we're doing.
:)
I am so happy i came to your U-Tube channel, Really! I have found your explanations to be helpful for the beginner, like myself. I am a student in the university in San Juan Puerto Rico. Attending class when a new lesson is introduced, helps me understand what the teacher is talking about. Your great!!!!!
Mr. Parmar,
You are an excellent instructor. Very smooth video presentation, clear, easy to follow, you've helped me so much already. I will definitely recommend you to friends. Thank you.
Viewing this in October 2020....found everything I was looking for...very thorough and clear Amir!..Thanks a million - you got through such a lot in a short time - most grateful - Thank you !
Really informatic video. This help me to gather knowledge before appearing govt level exam. Thanx Amir too much. A 10 Thumbs Up from Me.
This is great work, I'd recommend your tutorials to anyone. This is going to help me in my upcoming lab. Thank you
By far the best Access video I've seen. Great work! Showed me exactly what I wanted to learn.
Absolutely the best video tutorial that I have ever seen.....Many Thanks
Thank you for a very clear and thorough explanation and practical examples of how to apply. I learnt some very useful things.
best video and a lot of practical information . Best of luck Amir
Mr. Amir, I learned a lot from your video. It is very clear learned a lot. THANKS A LOT!
Your video's are an excellent point of reference for Access. I've found them very helpful, thank you!
Excellent knowledge ..... amazed very good learning channel
Very nice simplistic and easy to follow tutorial. I was able to follow as instructed and everything worked as illustrated. Thanks for your help.
Thank you so much Amir Sir
This is one of the best video for access .
my subject is all about database (DATAMAN database management) this semester. all of these tutorial you were teaching was everything that we discussed throughout the semester from making tables down to reports..and i honestly didnt get and understand my instructor becausw he talks very fast and most of the time i am absent. 😂 I viewed this video but its already our final examination and were done with this subject. haha too late i only got low low grade. 😭😭 if only i have watched this video early 😭😭😭😭
the tutorials best for beginners
The best I must say this, thanks Amir I now know what I did not know
Nice video I liked it
this is very good and nice for me thank you so much sir
Hi Amir Sir
this is Greate work sir i am very happy with you thank you very much sir
Another informative well done video! Thank you!
Really very helpful.... Thank you so much
Thank you ,,your video is very helpful .
this is a good lesson really !!!thank you !!!
i am glad that i found this! i don't have to go at some Access courses lol,this is way better :)
B Rabbit Get the basics here and go on to Intermediary/Advanced level courses. All the best.
Amir Parmar
Thanks :) your videos are helping me a lot.
Thanks sir for your tutorial! It really helped me a lot with my work!
thank so much. i have chance to learn English because i'm a foreigner
It is the best of all. Thanks!!
Useful video. Thanks.
Thank you very much. ☺
Thank you for the beautiful instruction.
Thanks this will help with my test
excellent work
Problem resolved. Thank you.
Thank you so much!
thank u for this lesson
That is great training video.Well done and thank you!
Thank you so much, you're instruction are very easy to follow. How do you make report that combine information in 2 tables?
+Evan de Guzman When creating your report pick your fields from one table, now change the table (you will see a drop down above next to the table name) and pick the fields of the 2nd table. And finish the wizard. You can also create a query with fields from 2 tables and make a Report based on this query.
It is the best of the best
Thank you, well done!
Thanks man perfect explain.
thank you so much! This video is a useful to me =))))
Thanks for the video do you video for relationship of the table
well done!
Thank you so much the videos are every helpful and are really easy to follow. Can you also explain how to link the forms to sub-forms?
+Priyanka Sharma I do show how to make a form that has a subform using the wizard, maybe in the next video. Also when you are in the Design view of the form, look for Subform button in the tools, click it and drag it below the form and follow the prompts. all the best.
great man you are
Hi, I performed the same steps and was able to use the command button wizard, but it has become non-functional now. I am not able to use it, I click on the button option and the command button appears but the wizard is not functional anymore. What I can I do in that case?
Thanks a lot for the videos, really helpful.
+Priyanka Sharma It might be due to the way the Mouse is used after clicking on the command button. Once you click on the Button, you drag the mouse on the form, make sure you are using the Left click and that you are not letting go of the mouse click.
Close the file and open again and try.
+Priyanka Sharma I hope I made sense about dragging the mouse. You click on the wizard button, let go of the mouse, now bring the mouse where you want to place the button, Now drag the mouse with the Left click and leave once you have the desired shape. And you can always change the shape.
Thank you so much
Hi Mr Amir Thanks for your helpfull clips these were really useful for me.
I had a question regarding the part where you insert the option button for genders.
there is only a value of 1 and 2 showed up.
is there any why that we can change it into male or femal as text?
if you dont mind shooting a video on that part I will be thankful please.
You can always use the Lookup wizard and choose "I will type the values" and type Male and female and create a list. This way it will say Male or Female when chosen.
Thanks for the video do you have video for relationship of table (That is to link the tables created)
+Mudy Ayela Hope you found the next video (4th) which talks about Relationship, here is the link to the playlist ua-cam.com/play/PLcmYWY91gQNcB-9D2him9oNl86FpCxCHc.html
Hey you !
You save my life ^_^
Thank you so much muuuaaahhhhh :*
Hi, Amir,
Your videos are great but for kids !!! All this and beyond this I did as a kid, I am looking for complex DB where I need assistance with VBA. You have any idea or if you can upload a video for the same. Thanks Bro.
Ya these are pretty much elementary videos. I don't now much about Access; my intention was to help people pass employment tests for basic Access. People asked question, so ended with more videos. Check out some online websites, there might be some paid tutorials.
awesome
quite helpful =)
Get your education on, son!
Mr. Parmar,
Thank you once again for your wonderful instructions and replies to my questions and comments. I have a new situation: I created a query from one of my tables and successfully selected certain information everything works beautifully until I ask it to COUNT records. In your example, you use Access 2013 and I have Access 2016 so I do not have the same layout of the Ribbon and when I click on the Sigma it does not allow me to select "Count Records" - it does not exist in my version of Access. Could you p[lease help me once again? I'd appreciate it very much. Thank you in advance once again. Chuck Sotis
Try to change the View and see if the button gets activated.
YEA THE VIDEO IS EXCELLENT
But i failed my computer literacy access exam
LMAO
LOLLLL
LOOL
LOLL
did you watch the exam prep? ua-cam.com/video/AlElY32jj2I/v-deo.html
Thanks!!!
Hi Amir, I am new to microsoft access and your videos are big help to me. I have question regarding to "not like statement in queries" I have three tables from external data source and I created a query with some columns from all three data sets. In particular one column name with Job title there are multiple categories and I dont want data with three categories for example A, B and C so I wrote not like "A" or not like "B" or not like "C" but its not working then I wrote not like statement in three different line but its still not working so to get desired data I had to creat three different queries but I believe there must be some efficient way to do it. I will really appreciate if you can help with this.
Does all the 3 tables have that Category? will need to look at it.
+Amir Parmar no only table one has that category
how about just adding A or b, you can put A on Row one and B on Row 2
Amir, please post SQL training if you have any.
Hi Jenna, I have not been exposed to SQL. You will find some really good info on SQL on these links
www.sololearn.com/Course/SQL/
www.khanacademy.org/computing/computer-programming/sql
More advance video if possible,
Thanks
Hey buddy, how do I save the previous report ?? the way u do it on the video, if u do a new search u will lose the first report. First u selected Canada and the reports shows Canada, the next u type USA, but where is the Canada u did first ? All the videos looks like the same and doesnt show the main propose of the report that is save all searches u do.
you save the report if you like, you can export it to Excel or PDf.
Even If I save it, If I do a new search I lose the first search. I would like to have in one single document different searches that I do.
to save the Search criteria, create a simple query and in the Criteria type the Canada or the search criteria of your choice. And save this query, whenever you run this query it will only give you that Results. Create separate one's for other such query. The idea of query is not to save the Results, but just to save the Criteria. To save the Results, you have to save the file separately to Excel or word or pdf. Or you could create a query that will create a separate table, but then you will end up with many tables with data.
how to create a queries which is based on table to create a new table with same lables?is it possible.....
Karan Maharjan Create a query based on a table, once created, go to the Design view of query, in there you will see an option "Make table" there is also option for "Append" or "Update" table.
I am trying to make a form that uses a combo box to present a list of contact names and IDs. then when the user chooses one, I woudl like it to populate the rest of the text boxes with the fields for that contact's information. So I'm trying to use it as a look up form. But I cant seem to figure out how to make it work- Help?
+Joe Auvil I have a tutorial for that see the Auto Fill tutorial or the Cascading Combo Box. ua-cam.com/play/PLcmYWY91gQNcB-9D2him9oNl86FpCxCHc.html
Can anyone tell me pastpapers which have form design questions??
how would i make calculations in report design
BigTimeCrafting you can add a text box add a calculation like =field1*field2
field1 and 2 will be then name of the boxes that have the amount that need to be calculated. I believe in the later videos I talk about it. It is the same like creating calculation in Forms.
i got it already thx though
please start from the begginning from where you recorded your table
Hi, I hope you found the part 1 of this video series, this is the 3rd part.
100th like!
***** :)
check the expression, you must have made some minor error in typing.
sir i nend your help.. I'm create a different database.. sir ap mari es database k lia help kar sakty ho....
ILU
how can Query by DATE LIKE Query by COUNTRY THANKS
Hi Amir How to make proper case text in data validation rule ?
See if Input mask helps.
>L
add more ? symbols, there might be another way, will need to look into it.
Thanks Bro :)
I am trying to write code in Data Validation Rule for proper case.
syntax- StrConv([Field Name], Number)
but i am not geting output , but when i write this code in query form to field option ,then i i get output in particular table's field name.
I'm waiting your answers..
can u plz tell us how to record a video like this plzzzzz
get any screen capture software to record your screen, voice and mouse strokes. I am using this company, their express version is free www.flashbackrecorder.com/compare-features/
How I create look like formats
what do u mean by 'look like formats?'