Just Finished the Beginner, Advanced and Expert models and I can definitely say this is the best Access training I have seen anywhere. Thank you and well done!
you probably dont give a damn but does someone know a method to get back into an instagram account..? I somehow forgot my password. I would appreciate any assistance you can offer me.
Really awesome training!! Quick note for other viewers. The trainings are a bit out of order. What's written: Parent and Child Forms - Method 1 3:08:47 Parent and Child Forms - Method 2 3:28:53 Parent and Child Forms - Method 3 3:33:07 Form Wizard's Datasheet Layout 3:38:44 Actual: Parent and Child Forms - Method 1 3:08:47 Parent and Child Forms - Method 3 3:28:53 Form Wizard's Datasheet Layout 3:33:07
I've used several learning channels and will say without hesitation that because this channel has some editing snafus and aren't honed to perfection it is one of my absolute favorites because it's obvious knowledgeable and caring people made the effort to make these videos relatable to us human users. Thank you!
As a non native-english speaking person I am able to understand you even with 1.5x speed. And I like your humor 😂. Thanks for uploading the Access-Videos 💪🏽👍🏽 Greetings from Germany
Thanks Dan for this wonderful tutorial. I had learnt Access 20 years ago but after that never used it. After 20 years I just followed your tutorial and it is so exiting to know that I am now confident of putting this into real projects. Thanks for all your efforts in putting this into such a simple manner.
Damn dan (Fernando) you did not have to remind me of alan rickman's death, i was learning access now i am crying. Incredible job, incredible tutorials by an incredible guy
Absolutely the best Access instructions I've listened to and I've listened to a LOT! Clear, concise and really helps reinforce the info and make it usable! I've been struggling with Access for months and I finally am seeing the light at the end of the tunnel. I'm still in the tunnel but Dan is guiding me out to the light! I'm mostly having trouble getting the data populated into a plant database and having it link into all the tables with the Binomial Name and Common Names.
Then the other to know what view you are on is from the status bar at the bottom. Either on the left side or right. Right gives the icon and left actually spells it out. Captain McAllister thank you for the lessons, started as a novice but after the first to tutorial collections beginner and advanced am sure I can do my own database. Going through expert collection. Hope it has aspects of form design to allow for end-user data entry without having to get into the design room.
As a fellow baby boomer, your sense of humour was not lost on myself - especially the Cheech and Chong bit - also I live in London ON just a bit farther than Windsor - thanks for your wonderful teaching voice and sense of timing! Tutorials were easy to follow! cb
Thank you once again Dan. I thoroughly enjoyed working through this tutorial with you. Even though the 6hrs 33mins took me two weeks to work through! For me, I've learnt so much and would like to congratulate and thank you for your time, your knowledge and your patience in putting together these tutorials for us mere mortals. Now on to the next. . . . . .
how to add a child form further down to the existing child form. customers -> books -> tags(something) which is going to be child of customers form or books form
There seems to be a mix up at 3.28 where we go from Method 1 for the parent/child forms to Method 3 and datasheets (where the hell did frmCustomerParent2, frmBookSalesChild2 come from). It picks up Method 2 again at 3.38 but confusing none the less. Skillshare how to edit videos perhaps :)
Excellent explanation by Dan ! I have attempted to learn access by myself on several occasions. Finally I can say i know something because of this tutorial. Is there a way, i can contact Dan for clarifying some points regarding Microsoft Access? Thanks in advance.
Excellent quality tutorials, informative and structured so that learning is progressive. Thank You Dan, I have enjoyed the course to date and am looking forward to completing the course once I have gained some experience. Practice, Practice, Practice. Bless You
Lessons are wonderful. In the past I have had trouble summing the top 4 values when the fifth value is the same as the fourth. Can you help? Thank you!
This course is one of the best courses I have attended on TH-cam. Thanks for the great work, Dan. When shall we have new totuerials for latest acces versions by Dan?
Great Mod, have one question when working on the forms and reports i have noticed in the ribbon what looks like a check box and also a radio button. if they are, can they be inserted on to a form?
Hello, i have a question. 1. I want to make data file which is having unique name or company names etc etc.. into multiple rows or columns. Can u please help me out in this..
Great training! My only wish/suggestion is that the videos titles included some label to indicate the viewing order and/or which modules are contained in each. Perhaps including it in the description. For example: Access Beginner - Part 1 = Modules ? to ?, Part 2 = Modules ? to ? Access Advanced - Part 1 . . . etc. Access Expert Access Master
These have been great tutorials and even being a database person my whole life and knowing some about Access, I have still learned a lot. The one comment I have is not about the teaching, but the Access product itself. We got all the way to reports before we saw built-in zooming in an Access window and it was the reports. I tried the Zoomit you were using and it's OK, but I sure wish the product had a zoom feature in the Access workspace. Word and Excel have it. Looking forward to the rest of the tutorials. Irv in Florida. Thanks, Dan
Teaching style is great - loving the info - has helped me a lot! I have a question that no matter how I try to Google it, I can't get the right answer. I have a Db for staff trainings. On one form there will be the training, with an option to select which staff attended. I can get the list box with check boxes for multi-select. But it's soooo long! Is there a way to have it do several columns just for that one bound 'field'? So while I'm only showing one column of data (names), they are displayed in several columns on the form, minimizing the need to scroll as much to get to all of the names. I hope that is clear!
I really your videos and they are amazing, but I didn't see one thing in your videos which is cascade drop down or chain drop down in the forms or data entry forms. For example, I choose UK, then only UK's cities will appear in the next blank, not USA's cities. The same for USA. And, how to add all of these cities in a quick way in the access so that I can take them easily to the chain drop down. Thanks a lot. An other question, how to share this form data entry online for many data entry users to enter data online and having the raw data in my computer or PC. Thanks.
I did the steps to import the States DB to the current Database, but after doing all the steps I didn't get the save import steps window and the Table didn't show in my initial database, so I couldn't do the lookup list as done by the instructor
I just figured out that I needed to select the States table in the box before the import takes effect, but what if I had a DB that has Tables, Queries, Forms,... and I want them all?
As far as I know, there's no way to create fields using Access' user friendly interface. You should use SQL instead, either from SQL view of a query or via VBA.
i don't know if i am the only one facing such troubles, the manual link provided is only up to 3 with various access versions there is no manual 5 and 6 let alone 4 so i am hardly playing along and benefiting..can i get a help on that
Hi Kanwal! Here is some documentation from Microsoft on where to find it on all versions of Access - support.microsoft.com/en-us/office/move-and-resize-controls-independently-3d0bebde-592d-4191-adc8-f8db0650a761#:~:text=1%20Right-click%20the%20form%20in%20the%20Navigation%20Pane%2C,the%20selected%20controls%2C%20point%20to%20...%20See%20More
I am not able to export databases containing jpg photos in to excel When exported it only shows file name but it does not show actual photo So how to export photos uploaded in ms access in to ms excel file using export to excel command
A lot is missing in all videos of the course! The creation of the parent and child forms are examples of that. Ops, it's there, but method 2 is after method 3! They're out of order.
Where is the Access Super Expert Tutorial? I have been working with Access since 2.0 and maintain a few Access Enterprise systems mainly in Inventory and Quotes in the Steel and Healthcare industries and integrate with various different programs like ACT and Quickbooks. Heavy Visual Basic coder. Especially using Excel objects for reporting and exports. Not enough people are taking Access to the next level I never see any videos about Advanced Access stuff. Would love to see an Advanced thing that would get people excited about Access. Not enough people are excited about it it seems like they just feel it is necessary.
Hi Not TheHelper! Glad to see you are excited about Access! We just released our updated Access videos these past few weeks, they may have what you are looking for!
Does the instructor really need to explain how to open a file on "EXPERT" tutorial? I love that you guys offer this for free, but it really gets frustrating, especially when you've seen the previous videos. All access materials could be cut it half without any information lost.
You are very knowledgeable but I just can’t take these lessons anymore with you saying “put the video on pause” every 5 seconds. No wonder it is 6.5 hours long.
Awesome tutorial. One thing I disagree is, when he is talking about 'the boss' he uses the pronoum 'she'. When, in reality, this is excludent. In english, and other languages, when you use the pronoum 'He', you can be reffering to men and women, but the contrary is not true.
the opposite is true: nowadays, the pronoun »she« covers both men and women, whereas »he« only refers to men. comment from a cis man, just for clarification.
Oh my God ! this is not an expert tutorial, this a basic tutorial where you are explaining and repeating every single steps again and again, good job but lot of time wasted in silly things like aligning controls designing etc, really you should have told this tutorial not expert but and basic expert
I do like the repeat too to make me completely familiar with all these processes. I want to know the whole of access after this video only and the eloquence and expertise of Dan is on another level. Great instructor Dan and we do appreciate your work
He is simply employing strong teaching techniques which, in my experiences, were frequently absent in many tech training classes that were taught by "experts". The most common complaint I heard from such sessions were - she/he went too fast! So, when I designed such classes for beginners, these techniques were always employed. The brain has to process things and link to what is already there. If you already know how to use Access at an expert level, you shouldn't be here!
Just Finished the Beginner, Advanced and Expert models and I can definitely say this is the best Access training I have seen anywhere. Thank you and well done!
Can't believe that you guys are offering this free of cost. Thank you!
Our pleasure! We believe everyone deserves to gain the office application skills expected in today's office place.
you probably dont give a damn but does someone know a method to get back into an instagram account..?
I somehow forgot my password. I would appreciate any assistance you can offer me.
Dan is the best teacher I ever encountered.
Thank you for the kind words westcoast!
Really awesome training!! Quick note for other viewers. The trainings are a bit out of order. What's written:
Parent and Child Forms - Method 1 3:08:47
Parent and Child Forms - Method 2 3:28:53
Parent and Child Forms - Method 3 3:33:07
Form Wizard's Datasheet Layout 3:38:44
Actual:
Parent and Child Forms - Method 1 3:08:47
Parent and Child Forms - Method 3 3:28:53
Form Wizard's Datasheet Layout 3:33:07
Parent and Child Forms - Method 2 3:38:44
I've used several learning channels and will say without hesitation that because this channel has some editing snafus and aren't honed to perfection it is one of my absolute favorites because it's obvious knowledgeable and caring people made the effort to make these videos relatable to us human users. Thank you!
Wow, thanks!
Yes it is very much of helpful to me. You are a real instructor who wants to give your knowledge with out hiding any. I really respect you.
Glad to hear that!
Today I have finished tutorial 3 of 4. "Learnt a lot" from "Learnit".
We are glad you learned so much!
As a non native-english speaking person I am able to understand you even with 1.5x speed. And I like your humor 😂. Thanks for uploading the Access-Videos 💪🏽👍🏽
Greetings from Germany
Thank you! 😃
Thanks Dan for this wonderful tutorial. I had learnt Access 20 years ago but after that never used it. After 20 years I just followed your tutorial and it is so exiting to know that I am now confident of putting this into real projects. Thanks for all your efforts in putting this into such a simple manner.
You're very welcome!
Damn dan (Fernando) you did not have to remind me of alan rickman's death, i was learning access now i am crying.
Incredible job, incredible tutorials by an incredible guy
Hi Potato Man! Dan was one of our best instructors and is sorely missed.
Absolutely the best Access instructions I've listened to and I've listened to a LOT! Clear, concise and really helps reinforce the info and make it usable! I've been struggling with Access for months and I finally am seeing the light at the end of the tunnel. I'm still in the tunnel but Dan is guiding me out to the light! I'm mostly having trouble getting the data populated into a plant database and having it link into all the tables with the Binomial Name and Common Names.
You're very welcome!
Then the other to know what view you are on is from the status bar at the bottom. Either on the left side or right. Right gives the icon and left actually spells it out.
Captain McAllister thank you for the lessons, started as a novice but after the first to tutorial collections beginner and advanced am sure I can do my own database. Going through expert collection. Hope it has aspects of form design to allow for end-user data entry without having to get into the design room.
Thank you for the kind words Marcel!
Best Access Class Ever
Thank you . I watch your channel every day.
As a fellow baby boomer, your sense of humour was not lost on myself - especially the Cheech and Chong bit - also I live in London ON just a bit farther than Windsor - thanks for your wonderful teaching voice and sense of timing! Tutorials were easy to follow! cb
Glad you enjoyed it! Thank you for sharing!
Thank you once again Dan. I thoroughly enjoyed working through this tutorial with you. Even though the 6hrs 33mins took me two weeks to work through! For me, I've learnt so much and would like to congratulate and thank you for your time, your knowledge and your patience in putting together these tutorials for us mere mortals. Now on to the next. . . . . .
Great to hear!
I'm a big fan of your teaching style. Very considerate. Thank you.
You are most welcome!
Very well explained with detailed instructions and made things easy as we are skilled enough to be competent. Thanks for your time and patience!!
Really enjoyed this video.
Awesome, thank you!
Hi Learnit. Please include English subtitles in this video, so I can understand more. Thank you very much.
Added
Great Training. What is the software you mentioned to zoom in on a part of the screen?
That would be Zoomit!
Thank you for detailed and great tutorial. Can you help me with this? How do i add the file name on the report I am printing?
Just brilliant !!! Second to none
We are glad you are enjoying Dan's videos so much! Hope you are learning everything you needed!
Sir I really love tutorials
Are you going to upload the sql in access as well.
how to add a child form further down to the existing child form. customers -> books -> tags(something) which is going to be child of customers form or books form
No need to fill the caption field on 01:18:50. Just delete the text and the form name will show on tab.
This was amazing, thanks Dan!
Glad you enjoyed it! A big thank you for subscribing! It helps us tremendously!
Great tutorial, thanks a lot! Wondering here if there's gonna be an Access VBA tutorial as extensive and precise like this one here. Count me in!
Thanks for the videos you shared it helps a lot
You are very welcome!
There seems to be a mix up at 3.28 where we go from Method 1 for the parent/child forms to Method 3 and datasheets (where the hell did frmCustomerParent2, frmBookSalesChild2 come from). It picks up Method 2 again at 3.38 but confusing none the less. Skillshare how to edit videos perhaps :)
Hi Fred! Yes, this was a video produced by our previous team, so it is a bit clunky.
Excellent explanation by Dan ! I have attempted to learn access by myself on several occasions. Finally I can say i know something because of this tutorial. Is there a way, i can contact Dan for clarifying some points regarding Microsoft Access? Thanks in advance.
Hello Kiran Gurjar! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/
Excellent quality tutorials, informative and structured so that learning is progressive. Thank You Dan, I have enjoyed the course to date and am looking forward to completing the course once I have gained some experience. Practice, Practice, Practice. Bless You
You're very welcome!
Great Tutprial. Thumbs Up For U...
Thank you! Cheers!
Lessons are wonderful. In the past I have had trouble summing the top 4 values when the fifth value is the same as the fourth. Can you help? Thank you!
This course is one of the best courses I have attended on TH-cam. Thanks for the great work, Dan.
When shall we have new totuerials for latest acces versions by Dan?
Unfortunately Dan passed away a few years ago but his teaching lives on in his videos!
Great Mod, have one question when working on the forms and reports i have noticed in the ribbon what looks like a check box and also a radio button. if they are, can they be inserted on to a form?
Hello, i have a question.
1. I want to make data file which is having unique name or company names etc etc.. into multiple rows or columns. Can u please help me out in this..
Hello Preethish! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/
super great Access class!! and X1.75works well for me!
Great to hear!
Great training! My only wish/suggestion is that the videos titles included some label to indicate the viewing order and/or which modules are contained in each. Perhaps including it in the description. For example:
Access Beginner - Part 1 = Modules ? to ?, Part 2 = Modules ? to ?
Access Advanced - Part 1 . . . etc.
Access Expert
Access Master
Great suggestion!
These have been great tutorials and even being a database person my whole life and knowing some about Access, I have still learned a lot. The one comment I have is not about the teaching, but the Access product itself. We got all the way to reports before we saw built-in zooming in an Access window and it was the reports. I tried the Zoomit you were using and it's OK, but I sure wish the product had a zoom feature in the Access workspace. Word and Excel have it. Looking forward to the rest of the tutorials.
Irv in Florida. Thanks, Dan
sir i wanna learn Access for very beginning so kindly tell me from which video i start this Access course
Hi Coding Learner - Access Beginner is the best starting spot - th-cam.com/video/1XTXv1V3-ag/w-d-xo.html
Thanks for your time. This were excellent lessons
How do I handle double drop down option in access, that is dependent drop down pls
Teaching style is great - loving the info - has helped me a lot! I have a question that no matter how I try to Google it, I can't get the right answer. I have a Db for staff trainings. On one form there will be the training, with an option to select which staff attended. I can get the list box with check boxes for multi-select. But it's soooo long! Is there a way to have it do several columns just for that one bound 'field'? So while I'm only showing one column of data (names), they are displayed in several columns on the form, minimizing the need to scroll as much to get to all of the names. I hope that is clear!
Hi Tammy! You can ask your questions directly to one of our instructors at Offsite our online community: bit.ly/3aYniSR
@@LearnitTraining Excellent - thanks, I will
Awesome video! I'm new to access, so this was excellent. I'll continue to follow your work. Thanks greatly!
I really your videos and they are amazing, but I didn't see one thing in your videos which is cascade drop down or chain drop down in the forms or data entry forms. For example, I choose UK, then only UK's cities will appear in the next blank, not USA's cities. The same for USA. And, how to add all of these cities in a quick way in the access so that I can take them easily to the chain drop down. Thanks a lot.
An other question, how to share this form data entry online for many data entry users to enter data online and having the raw data in my computer or PC. Thanks.
That awesome, thx for your work !
Love from France ! :D
Our pleasure!
Learned a lot, that was great, thankyou
How can I get the links for your tutorials from lesson 1?
I got the links.
Great training keep up the good work. I learnt a lot.
I did the steps to import the States DB to the current Database, but after doing all the steps I didn't get the save import steps window and the Table didn't show in my initial database, so I couldn't do the lookup list as done by the instructor
I just figured out that I needed to select the States table in the box before the import takes effect, but what if I had a DB that has Tables, Queries, Forms,... and I want them all?
Hi Rami! You can get your question answered at Offsite, our online community - www.offsitebylearnit.com
nice
Thank you!
Hello Sir, How to autoinsert new field in access table based on criteria?
As far as I know, there's no way to create fields using Access' user friendly interface. You should use SQL instead, either from SQL view of a query or via VBA.
i don't know if i am the only one facing such troubles, the manual link provided is only up to 3 with various access versions there is no manual 5 and 6 let alone 4 so i am hardly playing along and benefiting..can i get a help on that
Great Content
Thank you!
Sir i couldnot find remove layout it isnast available here🙄
Hi Kanwal! Here is some documentation from Microsoft on where to find it on all versions of Access - support.microsoft.com/en-us/office/move-and-resize-controls-independently-3d0bebde-592d-4191-adc8-f8db0650a761#:~:text=1%20Right-click%20the%20form%20in%20the%20Navigation%20Pane%2C,the%20selected%20controls%2C%20point%20to%20...%20See%20More
sir please make videos on jet sql language
Hi Hitesh - noted!
I am not able to export databases containing jpg photos in to excel
When exported it only shows file name but it does not show actual photo
So how to export photos uploaded in ms access in to ms excel file using export to excel command
Very helpful, thank you :)
Does anyone know which video covers the Access Mods 3-4 from the Access2016Samples folder?
Hi Andrew that would be our Access Advanced course - th-cam.com/video/Oq6vMEzTzX4/w-d-xo.html
很棒的影片，可惜沒有字幕
不幸的是， TH-cam 不再支援長形式視頻的字幕
Sir, there is no option of Subtitles in this video, please turn on the option of Subtitles, then we will be able to understand the video even better.
4:48:35 i really didn't know that
Glad you learned something new!
A lot is missing in all videos of the course! The creation of the parent and child forms are examples of that. Ops, it's there, but method 2 is after method 3! They're out of order.
Wow! It is amazing.
I am from Algeria, I am waiting for you.
Frome Sénégal
J'habite au Sénégal j t attends
Where is the Access Super Expert Tutorial? I have been working with Access since 2.0 and maintain a few Access Enterprise systems mainly in Inventory and Quotes in the Steel and Healthcare industries and integrate with various different programs like ACT and Quickbooks. Heavy Visual Basic coder. Especially using Excel objects for reporting and exports. Not enough people are taking Access to the next level I never see any videos about Advanced Access stuff. Would love to see an Advanced thing that would get people excited about Access. Not enough people are excited about it it seems like they just feel it is necessary.
Hi Not TheHelper! Glad to see you are excited about Access! We just released our updated Access videos these past few weeks, they may have what you are looking for!
Expert tutorial, but a Master Cheech & Chong reference
It's NOT Expert Level at all, this course is for beginners
is it complete access ?? i don't thing !!! where is access vba ??
Well then, go find that!!!
Does the instructor really need to explain how to open a file on "EXPERT" tutorial?
I love that you guys offer this for free, but it really gets frustrating, especially when you've seen the previous videos. All access materials could be cut it half without any information lost.
You can just skip past that part
You are very knowledgeable but I just can’t take these lessons anymore with you saying “put the video on pause” every 5 seconds. No wonder it is 6.5 hours long.
Awesome tutorial. One thing I disagree is, when he is talking about 'the boss' he uses the pronoum 'she'. When, in reality, this is excludent. In english, and other languages, when you use the pronoum 'He', you can be reffering to men and women, but the contrary is not true.
Noted!
the opposite is true: nowadays, the pronoun »she« covers both men and women, whereas »he« only refers to men. comment from a cis man, just for clarification.
@@t-love8351 that I cannot agree, since it is an ideological stance, not a natural language development.
@@amakyusa claiming that it’s not a natural language development is an opinion/ideological statement, not a natural process.
@@t-love8351 No. I'm stating facts. Historical and well documented. Look the meaning of ideology.
Oh my God ! this is not an expert tutorial, this a basic tutorial where you are explaining and repeating every single steps again and again, good job but lot of time wasted in silly things like aligning controls designing etc, really you should have told this tutorial not expert but and basic expert
I do like the repeat too to make me completely familiar with all these processes. I want to know the whole of access after this video only and the eloquence and expertise of Dan is on another level. Great instructor Dan and we do appreciate your work
He is simply employing strong teaching techniques which, in my experiences, were frequently absent in many tech training classes that were taught by "experts". The most common complaint I heard from such sessions were - she/he went too fast! So, when I designed such classes for beginners, these techniques were always employed. The brain has to process things and link to what is already there. If you already know how to use Access at an expert level, you shouldn't be here!
Learned a lot, that was great, thankyou
Glad it was helpful!