Access Expert Tutorial

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

Thanks for the videos you shared it helps a lot

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!

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.

Today I have finished tutorial 3 of 4. "Learnt a lot" from "Learnit".

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.

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

Sir I really love tutorials
Are you going to upload the sql in access as well.

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.

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.

Great Training. What is the software you mentioned to zoom in on a part of the screen?

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

How can I get the links for your tutorials from lesson 1?

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!

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 :)

Sir i couldnot find remove layout it isnast available here🙄

This was amazing, thanks Dan!

Really enjoyed this video.

nice

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

Hi Learnit. Please include English subtitles in this video, so I can understand more. Thank you very much.

sir i wanna learn Access for very beginning so kindly tell me from which video i start this Access course

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.

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.

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

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

Great Tutprial. Thumbs Up For U...

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?

you can zoom in without any third-party app on windows by pressing the Windows logo key + Plus sign (+)

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.

Dan is the best teacher I ever encountered.

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?

That awesome, thx for your work !
Love from France ! :D

很棒的影片，可惜沒有字幕

Can't believe that you guys are offering this free of cost. Thank you!

Does anyone know which video covers the Access Mods 3-4 from the Access2016Samples folder?

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.

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. . . . . .

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!

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

sir please make videos on jet sql language

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!

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

super great Access class!! and X1.75works well for me!

I'm a big fan of your teaching style. Very considerate. Thank you.

The picayune jeans apparently spot because alloy startlingly fix next a rampant semicircle. false familiar famous, frightened frightening full fumbling functional catsup

This is a perfect tutorial to learn - creating reports in Access database. While going through tutorials Dan ensures you follow him and generate exactly the same reports yourself  with him. At the end it gives satisfaction and confidence that you can create all sorts of reports. One of the best tutorials on creating reports in Access.

Learned a lot, that was great, thankyou

How do I handle double drop down option in access, that is dependent drop down pls