Can't believe that you guys are offering this free of cost. Thank you!
@LearnitTraining3 жыл бұрын
Our pleasure! We believe everyone deserves to gain the office application skills expected in today's office place.
@dariuskasen92293 жыл бұрын
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.
@shockhopful3 жыл бұрын
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
@origbeecee Жыл бұрын
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!
@LearnitTraining Жыл бұрын
Wow, thanks!
@cairovian2 жыл бұрын
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!
@westcoast71853 жыл бұрын
Dan is the best teacher I ever encountered.
@LearnitTraining3 жыл бұрын
Thank you for the kind words westcoast!
@saqibiqbal8661 Жыл бұрын
Today I have finished tutorial 3 of 4. "Learnt a lot" from "Learnit".
@LearnitTraining Жыл бұрын
We are glad you learned so much!
@iAuslaender3 жыл бұрын
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
@LearnitTraining3 жыл бұрын
Thank you! 😃
@surangavithanage68202 жыл бұрын
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.
@LearnitTraining2 жыл бұрын
Glad to hear that!
@shashisinha58442 жыл бұрын
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.
@LearnitTraining2 жыл бұрын
You're very welcome!
@peepoo2322 жыл бұрын
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
@LearnitTraining2 жыл бұрын
Hi Potato Man! Dan was one of our best instructors and is sorely missed.
@jloo19004 жыл бұрын
Best Access Class Ever Thank you . I watch your channel every day.
@AndrewSmith-vv7vh3 жыл бұрын
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. . . . . .
@LearnitTraining3 жыл бұрын
Great to hear!
@trentcvendiola76622 жыл бұрын
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.
@LearnitTraining2 жыл бұрын
You're very welcome!
@vramanap82904 жыл бұрын
Very well explained with detailed instructions and made things easy as we are skilled enough to be competent. Thanks for your time and patience!!
@ChristopherBannister-i5j Жыл бұрын
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
@LearnitTraining Жыл бұрын
Glad you enjoyed it! Thank you for sharing!
@marceljunioregondi55942 жыл бұрын
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.
@LearnitTraining2 жыл бұрын
Thank you for the kind words Marcel!
@sonnykhak18332 жыл бұрын
Really enjoyed this video.
@LearnitTraining2 жыл бұрын
Awesome, thank you!
@VincentAranda-z1h5 ай бұрын
Just brilliant !!! Second to none
@LearnitTraining5 ай бұрын
We are glad you are enjoying Dan's videos so much! Hope you are learning everything you needed!
@tmellberg8133 жыл бұрын
I'm a big fan of your teaching style. Very considerate. Thank you.
@LearnitTraining3 жыл бұрын
You are most welcome!
@thespiritualcentre91972 жыл бұрын
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
@LearnitTraining2 жыл бұрын
You're very welcome!
@umbertofreitas59183 жыл бұрын
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!
@turnswood3 жыл бұрын
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
@yadali48332 жыл бұрын
This was amazing, thanks Dan!
@LearnitTraining2 жыл бұрын
Glad you enjoyed it! A big thank you for subscribing! It helps us tremendously!
@cindydiemert4852 жыл бұрын
Great Training. What is the software you mentioned to zoom in on a part of the screen?
@LearnitTraining2 жыл бұрын
That would be Zoomit!
@kurtturner51204 жыл бұрын
Awesome video! I'm new to access, so this was excellent. I'll continue to follow your work. Thanks greatly!
@basilal-elaiw86967 ай бұрын
This course is one of the best courses I have attended on KZbin. Thanks for the great work, Dan. When shall we have new totuerials for latest acces versions by Dan?
@LearnitTraining7 ай бұрын
Unfortunately Dan passed away a few years ago but his teaching lives on in his videos!
@glenndoringuez9560 Жыл бұрын
Thanks for the videos you shared it helps a lot
@LearnitTraining Жыл бұрын
You are very welcome!
@velbalakrishnan9563 жыл бұрын
Great Tutprial. Thumbs Up For U...
@LearnitTraining3 жыл бұрын
Thank you! Cheers!
@muhamadaji87462 жыл бұрын
Hi Learnit. Please include English subtitles in this video, so I can understand more. Thank you very much.
@LearnitTraining2 жыл бұрын
Added
@rpprevost3 жыл бұрын
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
@LearnitTraining3 жыл бұрын
Great suggestion!
@Esclarecidos4 жыл бұрын
No need to fill the caption field on 01:18:50. Just delete the text and the form name will show on tab.
@natasagrozdanov52144 жыл бұрын
Thanks for your time. This were excellent lessons
@ruatkevin21423 жыл бұрын
That awesome, thx for your work ! Love from France ! :D
@LearnitTraining3 жыл бұрын
Our pleasure!
@chintu3211 Жыл бұрын
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..
@LearnitTraining Жыл бұрын
Hello Preethish! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/
@jacobbiton39283 жыл бұрын
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?
@fredkelly69532 жыл бұрын
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 :)
@LearnitTraining2 жыл бұрын
Hi Fred! Yes, this was a video produced by our previous team, so it is a bit clunky.
@pedro_em_bra41993 жыл бұрын
super great Access class!! and X1.75works well for me!
@LearnitTraining3 жыл бұрын
Great to hear!
@Sakhilemtimande4 жыл бұрын
Great training keep up the good work. I learnt a lot.
@jungleadventure57082 жыл бұрын
Sir I really love tutorials Are you going to upload the sql in access as well.
@kirangurjar9559 Жыл бұрын
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.
@LearnitTraining Жыл бұрын
Hello Kiran Gurjar! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/
@darrenwalker20073 жыл бұрын
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?
@ramidleikan55412 жыл бұрын
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
@ramidleikan55412 жыл бұрын
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?
@LearnitTraining2 жыл бұрын
Hi Rami! You can get your question answered at Offsite, our online community - www.offsitebylearnit.com
@allivecars4 жыл бұрын
Learned a lot, that was great, thankyou
@muditrustagi57753 жыл бұрын
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
@zainababubakar90844 жыл бұрын
How do I handle double drop down option in access, that is dependent drop down pls
@marykubach11884 жыл бұрын
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!
@marceljunioregondi55942 жыл бұрын
How can I get the links for your tutorials from lesson 1?
@marceljunioregondi55942 жыл бұрын
I got the links.
@Jani-muhabbat2 жыл бұрын
sir i wanna learn Access for very beginning so kindly tell me from which video i start this Access course
@LearnitTraining2 жыл бұрын
Hi Coding Learner - Access Beginner is the best starting spot - kzbin.info/www/bejne/Z4m3ialni5hgl8k
@tammytappan4183 жыл бұрын
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!
@LearnitTraining3 жыл бұрын
Hi Tammy! You can ask your questions directly to one of our instructors at Offsite our online community: bit.ly/3aYniSR
@tammytappan4183 жыл бұрын
@@LearnitTraining Excellent - thanks, I will
@kanwalfatima61142 жыл бұрын
Sir i couldnot find remove layout it isnast available here🙄
@LearnitTraining2 жыл бұрын
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
@kuamiyankson27514 жыл бұрын
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
@MoodyAndrewski3 жыл бұрын
Does anyone know which video covers the Access Mods 3-4 from the Access2016Samples folder?
@LearnitTraining3 жыл бұрын
Hi Andrew that would be our Access Advanced course - kzbin.info/www/bejne/haKZp4B7r7mtjpY
@buffaloofm71192 жыл бұрын
nice
@LearnitTraining2 жыл бұрын
Thank you!
@findthetruth30214 жыл бұрын
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.
@BusinessCoachp4 жыл бұрын
Great Content
@LearnitTraining4 жыл бұрын
Thank you!
@malchicken4 жыл бұрын
Very helpful, thank you :)
@wroomauto76154 жыл бұрын
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
@muychamnan99934 жыл бұрын
Wow! It is amazing.
@javierdimix3 ай бұрын
4:48:35 i really didn't know that
@LearnitTraining3 ай бұрын
Glad you learned something new!
@hiteshjoshi31483 жыл бұрын
sir please make videos on jet sql language
@LearnitTraining3 жыл бұрын
Hi Hitesh - noted!
@寶寶好累3 жыл бұрын
很棒的影片,可惜沒有字幕
@LearnitTraining3 жыл бұрын
不幸的是, KZbin 不再支援長形式視頻的字幕
@kunalaggarwal60074 жыл бұрын
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.
@mouraddz49914 жыл бұрын
I am from Algeria, I am waiting for you.
@Mmaheeshttoorggal4 жыл бұрын
Hello Sir, How to autoinsert new field in access table based on criteria?
@umbertofreitas59183 жыл бұрын
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.
@lahatleye63134 жыл бұрын
Frome Sénégal
@Esclarecidos4 жыл бұрын
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.
@petermackinnon65464 жыл бұрын
Expert tutorial, but a Master Cheech & Chong reference
@lahatleye63134 жыл бұрын
J'habite au Sénégal j t attends
@Mesjach3 жыл бұрын
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.
@Lettuce1003 жыл бұрын
You can just skip past that part
@notthehelper62893 жыл бұрын
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.
@LearnitTraining3 жыл бұрын
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!
@adelabdelhamid82724 жыл бұрын
It's NOT Expert Level at all, this course is for beginners
@paramjeet975singh34 жыл бұрын
is it complete access ?? i don't thing !!! where is access vba ??
@redsanders87544 жыл бұрын
Well then, go find that!!!
@SoundsofSomewhere4 жыл бұрын
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.
@amakyusa3 жыл бұрын
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.
@LearnitTraining3 жыл бұрын
Noted!
@t-love83512 жыл бұрын
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.
@amakyusa2 жыл бұрын
@@t-love8351 that I cannot agree, since it is an ideological stance, not a natural language development.
@t-love83512 жыл бұрын
@@amakyusa claiming that it’s not a natural language development is an opinion/ideological statement, not a natural process.
@amakyusa2 жыл бұрын
@@t-love8351 No. I'm stating facts. Historical and well documented. Look the meaning of ideology.
@masoodmd67274 жыл бұрын
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
@kensimba78684 жыл бұрын
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
@redsanders87544 жыл бұрын
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!