Access Expert Tutorial

  Рет қаралды 225,937

Learnit Training

Learnit Training

Күн бұрын

Пікірлер: 139
@letmeexcel5943
@letmeexcel5943 3 жыл бұрын
Can't believe that you guys are offering this free of cost. Thank you!
@LearnitTraining
@LearnitTraining 3 жыл бұрын
Our pleasure! We believe everyone deserves to gain the office application skills expected in today's office place.
@dariuskasen9229
@dariuskasen9229 3 жыл бұрын
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.
@shockhopful
@shockhopful 3 жыл бұрын
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
@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
@LearnitTraining Жыл бұрын
Wow, thanks!
@cairovian
@cairovian 2 жыл бұрын
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!
@westcoast7185
@westcoast7185 3 жыл бұрын
Dan is the best teacher I ever encountered.
@LearnitTraining
@LearnitTraining 3 жыл бұрын
Thank you for the kind words westcoast!
@saqibiqbal8661
@saqibiqbal8661 Жыл бұрын
Today I have finished tutorial 3 of 4. "Learnt a lot" from "Learnit".
@LearnitTraining
@LearnitTraining Жыл бұрын
We are glad you learned so much!
@iAuslaender
@iAuslaender 3 жыл бұрын
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
@LearnitTraining
@LearnitTraining 3 жыл бұрын
Thank you! 😃
@surangavithanage6820
@surangavithanage6820 2 жыл бұрын
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.
@LearnitTraining
@LearnitTraining 2 жыл бұрын
Glad to hear that!
@shashisinha5844
@shashisinha5844 2 жыл бұрын
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.
@LearnitTraining
@LearnitTraining 2 жыл бұрын
You're very welcome!
@peepoo232
@peepoo232 2 жыл бұрын
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
@LearnitTraining
@LearnitTraining 2 жыл бұрын
Hi Potato Man! Dan was one of our best instructors and is sorely missed.
@jloo1900
@jloo1900 4 жыл бұрын
Best Access Class Ever Thank you . I watch your channel every day.
@AndrewSmith-vv7vh
@AndrewSmith-vv7vh 3 жыл бұрын
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. . . . . .
@LearnitTraining
@LearnitTraining 3 жыл бұрын
Great to hear!
@trentcvendiola7662
@trentcvendiola7662 2 жыл бұрын
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.
@LearnitTraining
@LearnitTraining 2 жыл бұрын
You're very welcome!
@vramanap8290
@vramanap8290 4 жыл бұрын
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
@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
@LearnitTraining Жыл бұрын
Glad you enjoyed it! Thank you for sharing!
@marceljunioregondi5594
@marceljunioregondi5594 2 жыл бұрын
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.
@LearnitTraining
@LearnitTraining 2 жыл бұрын
Thank you for the kind words Marcel!
@sonnykhak1833
@sonnykhak1833 2 жыл бұрын
Really enjoyed this video.
@LearnitTraining
@LearnitTraining 2 жыл бұрын
Awesome, thank you!
@VincentAranda-z1h
@VincentAranda-z1h 5 ай бұрын
Just brilliant !!! Second to none
@LearnitTraining
@LearnitTraining 5 ай бұрын
We are glad you are enjoying Dan's videos so much! Hope you are learning everything you needed!
@tmellberg813
@tmellberg813 3 жыл бұрын
I'm a big fan of your teaching style. Very considerate. Thank you.
@LearnitTraining
@LearnitTraining 3 жыл бұрын
You are most welcome!
@thespiritualcentre9197
@thespiritualcentre9197 2 жыл бұрын
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
@LearnitTraining
@LearnitTraining 2 жыл бұрын
You're very welcome!
@umbertofreitas5918
@umbertofreitas5918 3 жыл бұрын
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!
@turnswood
@turnswood 3 жыл бұрын
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
@yadali4833
@yadali4833 2 жыл бұрын
This was amazing, thanks Dan!
@LearnitTraining
@LearnitTraining 2 жыл бұрын
Glad you enjoyed it! A big thank you for subscribing! It helps us tremendously!
@cindydiemert485
@cindydiemert485 2 жыл бұрын
Great Training. What is the software you mentioned to zoom in on a part of the screen?
@LearnitTraining
@LearnitTraining 2 жыл бұрын
That would be Zoomit!
@kurtturner5120
@kurtturner5120 4 жыл бұрын
Awesome video! I'm new to access, so this was excellent. I'll continue to follow your work. Thanks greatly!
@basilal-elaiw8696
@basilal-elaiw8696 7 ай бұрын
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?
@LearnitTraining
@LearnitTraining 7 ай бұрын
Unfortunately Dan passed away a few years ago but his teaching lives on in his videos!
@glenndoringuez9560
@glenndoringuez9560 Жыл бұрын
Thanks for the videos you shared it helps a lot
@LearnitTraining
@LearnitTraining Жыл бұрын
You are very welcome!
@velbalakrishnan956
@velbalakrishnan956 3 жыл бұрын
Great Tutprial. Thumbs Up For U...
@LearnitTraining
@LearnitTraining 3 жыл бұрын
Thank you! Cheers!
@muhamadaji8746
@muhamadaji8746 2 жыл бұрын
Hi Learnit. Please include English subtitles in this video, so I can understand more. Thank you very much.
@LearnitTraining
@LearnitTraining 2 жыл бұрын
Added
@rpprevost
@rpprevost 3 жыл бұрын
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
@LearnitTraining
@LearnitTraining 3 жыл бұрын
Great suggestion!
@Esclarecidos
@Esclarecidos 4 жыл бұрын
No need to fill the caption field on 01:18:50. Just delete the text and the form name will show on tab.
@natasagrozdanov5214
@natasagrozdanov5214 4 жыл бұрын
Thanks for your time. This were excellent lessons
@ruatkevin2142
@ruatkevin2142 3 жыл бұрын
That awesome, thx for your work ! Love from France ! :D
@LearnitTraining
@LearnitTraining 3 жыл бұрын
Our pleasure!
@chintu3211
@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
@LearnitTraining Жыл бұрын
Hello Preethish! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/
@jacobbiton3928
@jacobbiton3928 3 жыл бұрын
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?
@fredkelly6953
@fredkelly6953 2 жыл бұрын
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 :)
@LearnitTraining
@LearnitTraining 2 жыл бұрын
Hi Fred! Yes, this was a video produced by our previous team, so it is a bit clunky.
@pedro_em_bra4199
@pedro_em_bra4199 3 жыл бұрын
super great Access class!! and X1.75works well for me!
@LearnitTraining
@LearnitTraining 3 жыл бұрын
Great to hear!
@Sakhilemtimande
@Sakhilemtimande 4 жыл бұрын
Great training keep up the good work. I learnt a lot.
@jungleadventure5708
@jungleadventure5708 2 жыл бұрын
Sir I really love tutorials Are you going to upload the sql in access as well.
@kirangurjar9559
@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
@LearnitTraining Жыл бұрын
Hello Kiran Gurjar! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/
@darrenwalker2007
@darrenwalker2007 3 жыл бұрын
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?
@ramidleikan5541
@ramidleikan5541 2 жыл бұрын
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
@ramidleikan5541
@ramidleikan5541 2 жыл бұрын
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?
@LearnitTraining
@LearnitTraining 2 жыл бұрын
Hi Rami! You can get your question answered at Offsite, our online community - www.offsitebylearnit.com
@allivecars
@allivecars 4 жыл бұрын
Learned a lot, that was great, thankyou
@muditrustagi5775
@muditrustagi5775 3 жыл бұрын
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
@zainababubakar9084
@zainababubakar9084 4 жыл бұрын
How do I handle double drop down option in access, that is dependent drop down pls
@marykubach1188
@marykubach1188 4 жыл бұрын
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!
@marceljunioregondi5594
@marceljunioregondi5594 2 жыл бұрын
How can I get the links for your tutorials from lesson 1?
@marceljunioregondi5594
@marceljunioregondi5594 2 жыл бұрын
I got the links.
@Jani-muhabbat
@Jani-muhabbat 2 жыл бұрын
sir i wanna learn Access for very beginning so kindly tell me from which video i start this Access course
@LearnitTraining
@LearnitTraining 2 жыл бұрын
Hi Coding Learner - Access Beginner is the best starting spot - kzbin.info/www/bejne/Z4m3ialni5hgl8k
@tammytappan418
@tammytappan418 3 жыл бұрын
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!
@LearnitTraining
@LearnitTraining 3 жыл бұрын
Hi Tammy! You can ask your questions directly to one of our instructors at Offsite our online community: bit.ly/3aYniSR
@tammytappan418
@tammytappan418 3 жыл бұрын
@@LearnitTraining Excellent - thanks, I will
@kanwalfatima6114
@kanwalfatima6114 2 жыл бұрын
Sir i couldnot find remove layout it isnast available here🙄
@LearnitTraining
@LearnitTraining 2 жыл бұрын
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
@kuamiyankson2751
@kuamiyankson2751 4 жыл бұрын
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
@MoodyAndrewski
@MoodyAndrewski 3 жыл бұрын
Does anyone know which video covers the Access Mods 3-4 from the Access2016Samples folder?
@LearnitTraining
@LearnitTraining 3 жыл бұрын
Hi Andrew that would be our Access Advanced course - kzbin.info/www/bejne/haKZp4B7r7mtjpY
@buffaloofm7119
@buffaloofm7119 2 жыл бұрын
nice
@LearnitTraining
@LearnitTraining 2 жыл бұрын
Thank you!
@findthetruth3021
@findthetruth3021 4 жыл бұрын
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.
@BusinessCoachp
@BusinessCoachp 4 жыл бұрын
Great Content
@LearnitTraining
@LearnitTraining 4 жыл бұрын
Thank you!
@malchicken
@malchicken 4 жыл бұрын
Very helpful, thank you :)
@wroomauto7615
@wroomauto7615 4 жыл бұрын
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
@muychamnan9993
@muychamnan9993 4 жыл бұрын
Wow! It is amazing.
@javierdimix
@javierdimix 3 ай бұрын
4:48:35 i really didn't know that
@LearnitTraining
@LearnitTraining 3 ай бұрын
Glad you learned something new!
@hiteshjoshi3148
@hiteshjoshi3148 3 жыл бұрын
sir please make videos on jet sql language
@LearnitTraining
@LearnitTraining 3 жыл бұрын
Hi Hitesh - noted!
@寶寶好累
@寶寶好累 3 жыл бұрын
很棒的影片,可惜沒有字幕
@LearnitTraining
@LearnitTraining 3 жыл бұрын
不幸的是, KZbin 不再支援長形式視頻的字幕
@kunalaggarwal6007
@kunalaggarwal6007 4 жыл бұрын
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.
@mouraddz4991
@mouraddz4991 4 жыл бұрын
I am from Algeria, I am waiting for you.
@Mmaheeshttoorggal
@Mmaheeshttoorggal 4 жыл бұрын
Hello Sir, How to autoinsert new field in access table based on criteria?
@umbertofreitas5918
@umbertofreitas5918 3 жыл бұрын
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.
@lahatleye6313
@lahatleye6313 4 жыл бұрын
Frome Sénégal
@Esclarecidos
@Esclarecidos 4 жыл бұрын
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.
@petermackinnon6546
@petermackinnon6546 4 жыл бұрын
Expert tutorial, but a Master Cheech & Chong reference
@lahatleye6313
@lahatleye6313 4 жыл бұрын
J'habite au Sénégal j t attends
@Mesjach
@Mesjach 3 жыл бұрын
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.
@Lettuce100
@Lettuce100 3 жыл бұрын
You can just skip past that part
@notthehelper6289
@notthehelper6289 3 жыл бұрын
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.
@LearnitTraining
@LearnitTraining 3 жыл бұрын
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!
@adelabdelhamid8272
@adelabdelhamid8272 4 жыл бұрын
It's NOT Expert Level at all, this course is for beginners
@paramjeet975singh3
@paramjeet975singh3 4 жыл бұрын
is it complete access ?? i don't thing !!! where is access vba ??
@redsanders8754
@redsanders8754 4 жыл бұрын
Well then, go find that!!!
@SoundsofSomewhere
@SoundsofSomewhere 4 жыл бұрын
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.
@amakyusa
@amakyusa 3 жыл бұрын
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.
@LearnitTraining
@LearnitTraining 3 жыл бұрын
Noted!
@t-love8351
@t-love8351 2 жыл бұрын
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.
@amakyusa
@amakyusa 2 жыл бұрын
@@t-love8351 that I cannot agree, since it is an ideological stance, not a natural language development.
@t-love8351
@t-love8351 2 жыл бұрын
@@amakyusa claiming that it’s not a natural language development is an opinion/ideological statement, not a natural process.
@amakyusa
@amakyusa 2 жыл бұрын
@@t-love8351 No. I'm stating facts. Historical and well documented. Look the meaning of ideology.
@masoodmd6727
@masoodmd6727 4 жыл бұрын
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
@kensimba7868
@kensimba7868 4 жыл бұрын
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
@redsanders8754
@redsanders8754 4 жыл бұрын
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!
@epiff7921
@epiff7921 4 жыл бұрын
Learned a lot, that was great, thankyou
@LearnitTraining
@LearnitTraining 4 жыл бұрын
Glad it was helpful!
Access Master Tutorial
5:30:18
Learnit Training
Рет қаралды 143 М.
Access Advanced Tutorial
4:59:53
Learnit Training
Рет қаралды 288 М.
Elza love to eat chiken🍗⚡ #dog #pets
00:17
ElzaDog
Рет қаралды 25 МЛН
ROSÉ & Bruno Mars - APT. (Official Music Video)
02:54
ROSÉ
Рет қаралды 321 МЛН
Mia Boyka х Карен Акопян | ЧТО БЫЛО ДАЛЬШЕ?
1:21:14
Что было дальше?
Рет қаралды 12 МЛН
How to use Microsoft Access - Beginner Tutorial
31:07
Kevin Stratvert
Рет қаралды 3,3 МЛН
Word Expert Tutorial
3:39:03
Learnit Training
Рет қаралды 876 М.
Automated Import of Data to Microsoft Access from Excel with Just One Click
20:32
Computer Learning Zone
Рет қаралды 19 М.
How to Create a Form with a Subform to Show Related Records in Microsoft Access
29:19
How to use Microsoft Access - Beginners Course (Deep Dive)
1:20:38
Teacher's Tech
Рет қаралды 169 М.
Getting Started with MS Access Visual Basic for Applications - VBA Code-Behind and Modules
32:06
Elza love to eat chiken🍗⚡ #dog #pets
00:17
ElzaDog
Рет қаралды 25 МЛН