Dear Sir I would just like to say that whilst browsing the internet looking for information on how to create a personal database using Access 2019, I stumbled onto your video “Access Beginner Tutorial”. I learnt more in half an hour of watching the video that I had in days. Dan McAllister is such a good teacher. Takes you through each section and gives you time to try every little thing. He has such a wonderful calming voice, unlike presenters of other video’s. He does you credit. I’ll be sticking with your video and hoping that the information sinks into this 68 year old brain sufficiently for me to produce the database I need. Thank you
Hands down, this is the best Microsoft Access 2016 Turorial course i have ever come across. Talk about an expert/professional!!! Amazed! It makes so much sense to start with exploring a database rather than starting to create a database without knowing exactly how cool a database is. This first part is making me so excited and looking forward for the upcoming in lesson i see in this playlist.
@@LearnitTraining Between the chapter to "Creating Relationships with Lookup Lists 2:29:41", and "The Relationships Window 2:33:33" it seems there is a part of a video missing. Because i did not see how exactly to use lookup lits to create the relationships. The table also change between these two chapters, from the one with clients and custodians to clients and technicians.
This is the best course for MS Access that I found on UA-cam. I appreciate you for creating that much valuable content freely available to all. Thank you very much!
Dear Dan, I learned Access many years ago ,1995, but have not used it since. Now I wanted to design a database for my work and came to look for a refreshment and what a surprise!. You are a great teacher know exactly how to present a subject and how to lead your student especially on such a remote learning. I enjoyed every moment. Thank you so much. So many thinks we can learn from the way you teach. Well done.
Thank you so much. I have now watched this 3 times. Made a complex database (at least by my standard). Made tons of mistakes. Came back here to get the basics right. You covered it all. But for a newbie making mistakes was important learning. What an amazing course. Onwards and upwards.
I have taken a dozen or so courses in database management, Filemaker Pro and Access. This instructor is really, really good, I love how he gets right into hands on stuff and keeps your interest. Other courses start with very mundane technocrap. I am definitely going to look into paying for additional courses. Well played Mr. McAllister, well played.
DEAR SIR I THINK THIS ONE IS THE BEST TUTORIALS FOR ACCESS I HAD SEARCHED IN INTERNET.YOU ARE MIND BLOWINGLY GOOD.YOUR CONTENT IS SO EASY TO LEARN FROM BEGINING TO ADVANCE.I LOVE UR TEACHING .I HAVE GONE THROUGH MANY VEDIO ON INTERNET FOR MONTHS.YOU ARE THE BEST.THIS IS NOT GOLD,DIAMOND OR PLATIUM.THI IS LIKE DEVINE I CANT EXPLAIN. THANK U VERY MUCH SIR.
This tutorial is extremely professional and should be the go-to guide for anyone looking to learn. It's fantastic and truly top-notch. I was very impressed and it left me wanting to learn even more. Keep up the great work!
Thank you very much for these perfect lessons! My knowledge of Access is of absolute perfection-it is impeccably flawless and immaculate to the highest degree! I am surprised even how I am perfect that I am! Thank you for being perfect!
EXCELLENT teaching techniques! My job for many years was to observe and evaluate the instructional skills and techniques of middle and high school science and math teachers. Later I served as an Instructional Technology Director, during which some of my duties were to design and conduct classes for K-12 teachers on MS Windows, Word, Excel and PowerPoint. I designed a database that tracked the classes and performances of all teachers that attended our classes. I toyed with the idea of teaching MS Access, but never felt that my knowledge was as complete as it should have been to do as good a job as I would have wanted to do. Watching your "Beginner Tutorial" confirms that I have gaps in my knowledge! :-) I guess I never really took the time to fully explore all of the nooks and crannies of MS Access. Aside from having a firm understanding the content for which you are teaching (which sadly was not always the case for some teachers with whom I worked), you employ essential techniques, such as making few assumptions of the viewers' knowledge. For example, you include expected behaviors of Windows, and not just Access. Other extremely important techniques that you employ are: You FREQUENTLY loop back to review and hopefully reinforce what has been taught; You provide "wait time" so that viewers to follow the pace of your instruction; You raise the possibility of problems occurring, and patiently illustrate how to either avoid or address them; You check for understanding by giving viewers chances to implement procedures that you taught by letting them try out their understanding before you proceed. You use appropriate and reasonable amounts of humor at appropriate times to relieve mental tension. Consequently, your pace is not hurried, which is essential when teaching somewhat difficult content such as this. Ok, I can "see" and "hear" some techies moaning and rolling their eyes at my comments, and at your instructional methods. I strongly suspect that they have never tried to EFFECTIVELY teach folks for whom technology is not as easy to learn as it is for them. I've attended MANY classes conducted by techies whose apparent goal was to impress their students of how much they knew, rather than effectively teach. And BOY does that turn off many learners!!! And WOW...the time you and your organization take to make videos with this much detail and length at no cost to viewers. Very rare, and very much appreciated! Dan, based on your instructional performance in this video, I would have given you my highest marks in my evaluation. I wish I could see you teach in person, it would be a pleasure!
BTY James Grant, I'm working with a 78 year old brain, and have the same hopes as you. My son-in-law has come to me with the need to create a database for his small business. After having not used Access for more than 10 years, I'm really dusting off the mental cobwebs and making my brain ache again. Feels good! :-)
Great tutorial, loving this - but there is a jump at 2:33:33 that skips over where you were to another point in the presentation and different access about relationships
My congratulations on this wonderful course!!! I admire your simplicity in explaining things and getting into details step-by-step. This is a wonderful course!
⭐⭐⭐⭐⭐ 5 STARS is what I give you for the incredibly didactic trainning !!!! I'M FROM BRASIL , RIO DE JANEIRO and I prefer study by American Professors and teachers... Your training is good because of the 3 points I consider crucial: 1)Your language is clear and to the point 2)Your exemples are exactly what we find in the files (no unpleasant surprises as some other not so didactic teachers from Learnit made me go through while following their classes, rendering me a lot of headaches!!!) 3)You are a very detail-oriented person, which made me like you even more!!!! .... I wish all the success, health and joy to you!!! You are one in a million... !!!! 🙏🙏🙏
This is brilliant. I have done a lot off access but not for ages and had forgotten some of the steps. Of course as soon as I see you do the step I am thinking how did I forget that. What I really like is how you don't miss out any detail especially the simple details that some trainers skip right over forgetting that not everybody already knows the actions to take. Doe example the different ways to open, close and not change a record.
I like that the humor, anecdotes, and personality come forward slowly throughout the video. Like, I've lured you in with my professional acumen but keeping you here for Steven Wright and Billy Crystal references.
This is very good if you know absolutely nothing about databases or access. I never used Access but worked heavily with SQL, so I tried to skip a lot of the info about database design.
Terrific. I'm a former database programmer and it's been years. Going to design a dbase for my work in Access and needed to run through how things work here. Did some fast forwarding but you are a great teacher... You know the material but you know how to teach as well! : )
I have gone through whole Beginner Access video. I really appreciate and happy for the video and Learnit team for doing this great job. It was long pending dream of learning Microsoft Access. Atlast, i found the perfect video to learn. Thanks a lot.
This tutorial is amazing for beginners. The flow of session is maintained brilliently till end. You get hands on experience while watching this tutorial. One of the best course.
Thank you sir for your great service. Please upload more courses ASAP. We want to learn more about IT. We need like java, c++, UI/UX design, AutoCAD, android studio, website design and trending courses. Thank you
Good tutorial, thank you for sharing it. I'd like to draw your attention that the section about how to create a lookup list is missing. It should be around 2:33:00.
Best teacher, this is not a lesson, this is an adventure, a roller Coaster of Access. the course is very well structured and presented with amazing flow. thank you DAN.
Wow! That you SO much for your generosity, time, skill, warm demeanor and humour. The only other similar comprehensive course I could find had some free videos but for a thorough continuous course I would have had to pay far more than I could afford. I have tried several times to learn Access - using books, videos and other means, and I have become frustrated and defeated every time - until now thanks to you. I am half way through the first series and look forward to working through the other 3. The idea of sample files and pausing for us to repeat actions is brilliant. Again, thanks so much Dan! PS. I have also made available hours of free UA-cam content (on Inkscape), and am grateful to others like you who generously assist others to learn via UA-cam.
Hey Dan, or should I say Fernando :D Thanks for making this video, it's helping me understand the program properly and will help me add tremendous value to my job position. The amount of times I've said "Oh, wow." while following this tutorial is insane. You're really good at putting the info down and I look forward to finishing the entire course using your videos. Thanks again!
Thanks , very detailed this is one of my least favorite apps. I always ask for someone to show me and no one I know uses Access. Everybody is scared of Access. I will refer to this Video
Excellent ACCESS Tutorial!! The structure of the course is well organized and the contents are well selected! I love your sense of humor, it makes me laugh where learning :). Enjoy so much this tutorial and reviewed the ACCESS fairly through in less than 4 hours. Thank you!! Find a little typo though, for Weight, you typed 6.3, but somehow 6 is showing at the end (without decimal point), not sure why that happened since you used Decimal as data type.
Good afternoon. For example, I have 100 entries in the "table". A question: 1) How to create an automatic numbering in the table, starting from number 001 (this field with the number will be a key) 2) If, for example, I delete line 63, then the numbering should be updated (auto -missing).
It also helps if you are watching on your pc that you have it hooked up your tv and have it set to the 2 screens and have the video on one and access on the other
Thank you so much for this, sir! This channel has a lot of material to learn and master so many topics. I guess I won't be leaving the computer for a while :)
@@LearnitTraining Indeed..a colleague showed me years ago how to use Access and my eyes almost bled. This is SOOOO helpful and _interesting_ . I never thought I would think this way about MS Access.
Greetings from New Zealand. You're an awwwesome tutor, Excellent content too. I'd say personally this is the BEST tutorial in regards to Microsoft Access for beginners. Your other " Microsoft tutorials " are top notch too. Thanks, cheers
I'd bet that between the words 'put your video on pause' and 'welcome back,' a lecturer sneaks in a couple of sips of good whisky) Very good sense of humor.
At about 2:33:30 the video seems to skip ahead, missing part of how to use Lookup Lists to create relationships, I would assume explaining exactly how to do that. Is that correct or am I missing something. Excellent instruction by the way.
Best method of teaching by providing the Exercise file. This is how it should be. Thanks Dan, keep the good work. I never tried Access. This is my first time.
The learning has been great, I am just a little curious, I am on part 2 and at 2hours 33 mins. It suddenly seem to jump a step where you learn about forming the relationships and also goes to a different file (Compugeeks whereas was on Beyond Clean). Have i missed someting. Many thanks
Getting relationships to work where it concerns MULTIPLE tables always presented challenges for me. The more tables used, the harder it is for me to follow along. Parenthetically, I suspect my slow learning in such matters is largely due to my limited IQ. Nevertheless, big applause goes out to you for taking the precious time needed to achieve your teaching outcomes. With respect to the relational database section of this video (toward the end), I would rate me at least a 9 in terms of comprehension with 10 being perfect understanding. I take a bow, yes, but you first, because you made it happen with your clear delivery and perfect pacing throughout the tutorial. Bravo, good sir! You crossed the Rubicon and achieved your victory and in doing so I learned how to swim.
The tutorials good although I couldn't imagine shuffling between the you tube/access windows. Dual screens or in my case a screen big enough to accommodate both windows.
Thank you very much for this. Thorough and comprehensive! Not to mention that you often sound like Lewis Black in voice, accent and inflection. I anticipated expletives and tantrums, and got none.
Thank you so much for the very useful tutorial. I have never really understood Access and this tutorial was very well put together and you explained everything very well
There is an issue when you get to 2:23:29 forward. It jumps over Creating Relationships with Lookup Lists and go straight to The Relationship Window. Very very confusing. The Custodian Table is not there anymore and a new table called Technician is there instead. How did that happen?
Me too from Kenya and I've watched all this series. Iam actually venturing into database business courtesy to u learnit and a few others. @ jargon master, any community of database programmers here?
2:40:00 2:48:17 / two things needed to create a relationship 2:49:50 /shared field don't req to have same name only same data type 2:51:40 /parent table 2:57:58 /one to one relationship 3:12:28/ dealing with orphan records 3:27:00/ Cascade updated related fields 3:38:06/ Default Value 3:38:18/Data validation
basically if one's planning to updates table it not convenient at all to create relationships from the relationship tab, but from the lookup wizard. infact i don't see the point in creating those from the rela..tab then if it doesnt suggest you when it comes to enter new records in the child table..
Huhuu!!! You are such a great tutor. Your teachings voice kept sounding in my ear, how do I get link up for the rest of the tutorial services, I cannot wait, Thanks.
Dear Sir
I would just like to say that whilst browsing the internet looking for information on how to create a personal database using Access 2019, I stumbled onto your video “Access Beginner Tutorial”.
I learnt more in half an hour of watching the video that I had in days.
Dan McAllister is such a good teacher. Takes you through each section and gives you time to try every little thing. He has such a wonderful calming voice, unlike presenters of other video’s. He does you credit.
I’ll be sticking with your video and hoping that the information sinks into this 68 year old brain sufficiently for me to produce the database I need.
Thank you
Glad you got more out of it
Sir I m 50 year old and I inspired to you 🎉.
Very generous man, indeed.
Hands down, this is the best Microsoft Access 2016 Turorial course i have ever come across. Talk about an expert/professional!!! Amazed! It makes so much sense to start with exploring a database rather than starting to create a database without knowing exactly how cool a database is. This first part is making me so excited and looking forward for the upcoming in lesson i see in this playlist.
We are glad you are so excited to be learning!
@@LearnitTraining Between the chapter to "Creating Relationships with Lookup Lists 2:29:41", and "The Relationships Window 2:33:33" it seems there is a part of a video missing. Because i did not see how exactly to use lookup lits to create the relationships. The table also change between these two chapters, from the one with clients and custodians to clients and technicians.
This is the best course for MS Access that I found on UA-cam. I appreciate you for creating that much valuable content freely available to all. Thank you very much!
You're very welcome!
Dear Dan, I learned Access many years ago ,1995, but have not used it since. Now I wanted to design a database for my work and came to look for a refreshment and what a surprise!. You are a great teacher know exactly how to present a subject and how to lead your student especially on such a remote learning. I enjoyed every moment. Thank you so much. So many thinks we can learn from the way you teach. Well done.
Thank you for the kind words Moshe! Dan was one of our best instructors and is deeply missed here at Learnit!
Thank you so much.
I have now watched this 3 times. Made a complex database (at least by my standard). Made tons of mistakes. Came back here to get the basics right. You covered it all. But for a newbie making mistakes was important learning.
What an amazing course.
Onwards and upwards.
Hi Shahinul! That is great to hear! We are glad you learned so much!
I don't know how to thank to you for your great free service. Thank you so much. I am waiting for your more courses.
From my heart 💓💓💓💓💓💓💓💓💓💓💓💓💓💓💓💓💓💓
You're very welcome!
I have taken a dozen or so courses in database management, Filemaker Pro and Access. This instructor is really, really good, I love how he gets right into hands on stuff and keeps your interest. Other courses start with very mundane technocrap. I am definitely going to look into paying for additional courses. Well played Mr. McAllister, well played.
Thank you for the kind words!
:)
I am an an experienced access user, but I found many small things I did not know. Thank you for the tutorial.
You're welcome!
DEAR SIR
I THINK THIS ONE IS THE BEST TUTORIALS FOR ACCESS I HAD SEARCHED IN INTERNET.YOU ARE MIND BLOWINGLY GOOD.YOUR CONTENT IS SO EASY TO LEARN FROM BEGINING TO ADVANCE.I LOVE UR TEACHING .I HAVE GONE THROUGH MANY VEDIO ON INTERNET FOR MONTHS.YOU ARE THE BEST.THIS IS NOT GOLD,DIAMOND OR PLATIUM.THI IS LIKE DEVINE I CANT EXPLAIN.
THANK U VERY MUCH SIR.
A silky voice, excellent sense of humour and superb quality course. Dan McAllistar, thank you! I really enjoyed following along.
Awesome, thank you!
Success in life comes from great teachers
We think so too!
You're the best instructor ever, and explain everything in detail, thank you very much
You are very welcome!
This is the most effective strategy I've ever come across. It's like magic!
Thanks!
HANDS DOWN THIS IS THE BEST VIDEO EVER
Thank you for the kind words Mudit!
Just ended This Video and I Am !00% Statisfied It Was Worth It. Best Teacher On UA-cam For Computer Programs Learnings
Thank you Najeeb!
This tutorial is extremely professional and should be the go-to guide for anyone looking to learn. It's fantastic and truly top-notch. I was very impressed and it left me wanting to learn even more. Keep up the great work!
Glad you enjoyed it!
Enjoyed the course. Only recommendation would be to correct whatever happened at 2:33:33.
I was so scared when I first got to do with access but with your video I started to understand better the things in it. Thank you
You're welcome!
Thank you very much for these perfect lessons! My knowledge of Access is of absolute perfection-it is impeccably flawless and immaculate to the highest degree! I am surprised even how I am perfect that I am! Thank you for being perfect!
You're very welcome!
EXCELLENT teaching techniques! My job for many years was to observe and evaluate the instructional skills and techniques of middle and high school science and math teachers. Later I served as an Instructional Technology Director, during which some of my duties were to design and conduct classes for K-12 teachers on MS Windows, Word, Excel and PowerPoint. I designed a database that tracked the classes and performances of all teachers that attended our classes. I toyed with the idea of teaching MS Access, but never felt that my knowledge was as complete as it should have been to do as good a job as I would have wanted to do. Watching your "Beginner Tutorial" confirms that I have gaps in my knowledge! :-) I guess I never really took the time to fully explore all of the nooks and crannies of MS Access.
Aside from having a firm understanding the content for which you are teaching (which sadly was not always the case for some teachers with whom I worked), you employ essential techniques, such as making few assumptions of the viewers' knowledge. For example, you include expected behaviors of Windows, and not just Access. Other extremely important techniques that you employ are: You FREQUENTLY loop back to review and hopefully reinforce what has been taught; You provide "wait time" so that viewers to follow the pace of your instruction; You raise the possibility of problems occurring, and patiently illustrate how to either avoid or address them; You check for understanding by giving viewers chances to implement procedures that you taught by letting them try out their understanding before you proceed. You use appropriate and reasonable amounts of humor at appropriate times to relieve mental tension. Consequently, your pace is not hurried, which is essential when teaching somewhat difficult content such as this.
Ok, I can "see" and "hear" some techies moaning and rolling their eyes at my comments, and at your instructional methods. I strongly suspect that they have never tried to EFFECTIVELY teach folks for whom technology is not as easy to learn as it is for them. I've attended MANY classes conducted by techies whose apparent goal was to impress their students of how much they knew, rather than effectively teach. And BOY does that turn off many learners!!!
And WOW...the time you and your organization take to make videos with this much detail and length at no cost to viewers. Very rare, and very much appreciated!
Dan, based on your instructional performance in this video, I would have given you my highest marks in my evaluation. I wish I could see you teach in person, it would be a pleasure!
BTY James Grant, I'm working with a 78 year old brain, and have the same hopes as you. My son-in-law has come to me with the need to create a database for his small business. After having not used Access for more than 10 years, I'm really dusting off the mental cobwebs and making my brain ache again. Feels good! :-)
Great tutorial, loving this - but there is a jump at 2:33:33 that skips over where you were to another point in the presentation and different access about relationships
Took one look at the display pic for this guy and I knew this was the guy I needed to teach me this stuff
Dan was the definitely the guy to teach anything really!
Best style of teaching I’ve come across. By far the best, love it.
Wow, thank you!
My congratulations on this wonderful course!!! I admire your simplicity in explaining things and getting into details step-by-step. This is a wonderful course!
Thank you!
⭐⭐⭐⭐⭐ 5 STARS is what I give you for the incredibly didactic trainning !!!! I'M FROM BRASIL , RIO DE JANEIRO and I prefer study by American Professors and teachers... Your training is good because of the 3 points I consider crucial: 1)Your language is clear and to the point 2)Your exemples are exactly what we find in the files (no unpleasant surprises as some other not so didactic teachers from Learnit made me go through while following their classes, rendering me a lot of headaches!!!) 3)You are a very detail-oriented person, which made me like you even more!!!!
....
I wish all the success, health and joy to you!!! You are one in a million... !!!! 🙏🙏🙏
Thank you so much for the kind words Cris! We are glad you learned so much!
I’m really enjoining this tutorial so far and the the instructor is a gem thanks
You are welcome!
The best and clear ACCESS tutorial 👍
We appreciate that!
This is brilliant. I have done a lot off access but not for ages and had forgotten some of the steps. Of course as soon as I see you do the step I am thinking how did I forget that. What I really like is how you don't miss out any detail especially the simple details that some trainers skip right over forgetting that not everybody already knows the actions to take. Doe example the different ways to open, close and not change a record.
You're very welcome!
I like that the humor, anecdotes, and personality come forward slowly throughout the video. Like, I've lured you in with my professional acumen but keeping you here for Steven Wright and Billy Crystal references.
Thank you Brad!
This is very good if you know absolutely nothing about databases or access. I never used Access but worked heavily with SQL, so I tried to skip a lot of the info about database design.
Glad it was helpful!
So far so good this is the best Access course I’ve come across. Thank you so much for this quality but free video.
You're very welcome!
Nice Lecture. Excellent sound and video quality. I will recommend to the peoples who are interested to learn in detail about MS Access.
Thank you so much!
Terrific. I'm a former database programmer and it's been years. Going to design a dbase for my work in Access and needed to run through how things work here. Did some fast forwarding but you are a great teacher... You know the material but you know how to teach as well! : )
Thank you for watching and an extra big thank you for subscribing!
I have gone through whole Beginner Access video. I really appreciate and happy for the video and Learnit team for doing this great job. It was long pending dream of learning Microsoft Access. Atlast, i found the perfect video to learn. Thanks a lot.
You are most welcome!
This tutorial is amazing for beginners. The flow of session is maintained brilliently till end. You get hands on experience while watching this tutorial. One of the best course.
Thank you Arun! We hope you learned alot!
Thank you sir for your great service. Please upload more courses ASAP. We want to learn more about IT. We need like java, c++, UI/UX design, AutoCAD, android studio, website design and trending courses.
Thank you
We are currently looking at building some new coding videos. Stay tuned!
Good tutorial, thank you for sharing it. I'd like to draw your attention that the section about how to create a lookup list is missing. It should be around 2:33:00.
Noted
Thank you for bringing so great value to us for free. God bless you real good
You are so welcome!
thank you very much for uploading this. I need to learn access for a job abd this is a really comprehensive tutorial
You are weclome J.Azz Woods! Good luck on your job!
The diagram was an excellent choice. Thank you
You are very welcome!
This is very helpful to my Access learning, thanks 🎉🎉🎉🎉
You're very welcome!
Best teacher, this is not a lesson, this is an adventure, a roller Coaster of Access. the course is very well structured and presented with amazing flow.
thank you DAN.
Wow, thanks!
Wow! That you SO much for your generosity, time, skill, warm demeanor and humour.
The only other similar comprehensive course I could find had some free videos but for a thorough continuous course I would have had to pay far more than I could afford. I have tried several times to learn Access - using books, videos and other means, and I have become frustrated and defeated every time - until now thanks to you. I am half way through the first series and look forward to working through the other 3. The idea of sample files and pausing for us to repeat actions is brilliant. Again, thanks so much Dan!
PS. I have also made available hours of free UA-cam content (on Inkscape), and am grateful to others like you who generously assist others to learn via UA-cam.
You are very welcome! We hoped you learned alot!
you are such an amazing teacher.i love to have private classes whenever possible,,,100 percent undertood.
Any time!
Oh man, it has been at least 15 years since I've done the Northwind thing. Amazing how much you can forget!
this is the best access tutorial on youtube. thank you so much. helped me a lot
You're welcome!
This teacher is the best!
Thank you for the kinds words Coach!
Your good work is visible, even to the one who doesn’t want to see. Job well done and May you be rewarded handsomely!
Hey Dan, or should I say Fernando :D Thanks for making this video, it's helping me understand the program properly and will help me add tremendous value to my job position. The amount of times I've said "Oh, wow." while following this tutorial is insane. You're really good at putting the info down and I look forward to finishing the entire course using your videos. Thanks again!
You're very welcome!
Thanks , very detailed this is one of my least favorite apps. I always ask for someone to show me and no one I know uses Access. Everybody is scared of Access. I will refer to this Video
Glad you liked it!
Excellent ACCESS Tutorial!! The structure of the course is well organized and the contents are well selected! I love your sense of humor, it makes me laugh where learning :). Enjoy so much this tutorial and reviewed the ACCESS fairly through in less than 4 hours. Thank you!! Find a little typo though, for Weight, you typed 6.3, but somehow 6 is showing at the end (without decimal point), not sure why that happened since you used Decimal as data type.
Thank you for watching!
The best explanation! It’s very easy to understand with this wonderful sense of humor! Great 👍 job! Thanks 🙏!
Thank you! 😃
Excellent video for beginners and pro's looking for a refresher.
Glad it was helpful!
Good afternoon. For example, I have 100 entries in the "table". A question:
1) How to create an automatic numbering in the table, starting from number 001 (this field with the number will be a key)
2) If, for example, I delete line 63, then the numbering should be updated (auto -missing).
Hello Yevgeniy! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
It also helps if you are watching on your pc that you have it hooked up your tv and have it set to the 2 screens and have the video on one and access on the other
Great course and huge efforts
Glad you think so!
Very informative video. I learned Ms Access step by step with you sir. Thanks 👍
Great 👍
this is great tutorial! need help, why is copy so problematic ? Most the time it fail to copy field value. any help is greatly appreciated
Thank you so much for this, sir! This channel has a lot of material to learn and master so many topics. I guess I won't be leaving the computer for a while :)
You're very welcome!
You're seriously a top trainer. Many thanks for this great session.
Glad you enjoyed it!
@@LearnitTraining Indeed..a colleague showed me years ago how to use Access and my eyes almost bled. This is SOOOO helpful and _interesting_ . I never thought I would think this way about MS Access.
Greetings from New Zealand. You're an awwwesome tutor, Excellent content too. I'd say personally this is the BEST tutorial in regards to Microsoft Access for beginners. Your other " Microsoft tutorials " are top notch too. Thanks, cheers
Awesome, thank you!
I'd bet that between the words 'put your video on pause' and 'welcome back,' a lecturer sneaks in a couple of sips of good whisky) Very good sense of humor.
Thanks!
At about 2:33:30 the video seems to skip ahead, missing part of how to use Lookup Lists to create relationships, I would assume explaining exactly how to do that. Is that correct or am I missing something. Excellent instruction by the way.
Thank for the kind words! We will definitely look into adding another Photoshop module!
That was a masterpiece for real!!! Thanks a lot Teachers
Glad you enjoyed it!
Learning Access has never been so funny! Thank you Sir! :)
Glad you enjoyed it!
Great Job. Thanks.
Thanks for watching!
Absolutely mind blowing method of sharing knowledge ! Thanks a ton for putting in this awesome effort
Thank you for watching Varun!
YOU ARE A GREAT TEACHER FERNANDO!
Thanks!
Best method of teaching by providing the Exercise file. This is how it should be. Thanks Dan, keep the good work. I never tried Access. This is my first time.
Thank for watching MJB! We hoped you learned alot!
The learning has been great, I am just a little curious, I am on part 2 and at 2hours 33 mins. It suddenly seem to jump a step where you learn about forming the relationships and also goes to a different file (Compugeeks whereas was on Beyond Clean). Have i missed someting. Many thanks
Hi Steve! This is an older video series that we stitched together for our channel, hence the jumps in the videos.
Hey great tutorial, learned a lot. I am having trouble finding part 2, 3 and 4 though??
Hello Daniel! Here is a playlist with all our Access videos - ua-cam.com/play/PLoyECfvEFOjYqifYG9xBEcJkdh395-bjx.html
Getting relationships to work where it concerns MULTIPLE tables always presented challenges for me. The more tables used, the harder it is for me to follow along. Parenthetically, I suspect my slow learning in such matters is largely due to my limited IQ. Nevertheless, big applause goes out to you for taking the precious time needed to achieve your teaching outcomes. With respect to the relational database section of this video (toward the end), I would rate me at least a 9 in terms of comprehension with 10 being perfect understanding. I take a bow, yes, but you first, because you made it happen with your clear delivery and perfect pacing throughout the tutorial. Bravo, good sir! You crossed the Rubicon and achieved your victory and in doing so I learned how to swim.
Hi Tony! We are glad you learned so much!
The tutorials good although I couldn't imagine shuffling between the you tube/access windows. Dual screens or in my case a screen big enough to accommodate both windows.
Hi Fred! We agree on the dual screens!
Thank you so much, you're seriously an amazing trainer.
You're so welcome!
Amazing tutorial. How do you join unrelated tables without any Primary and foreign keys?
Hi Tyrone! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
that is the knowledge I yearn for. Just thank you for the videos.
You are very welcome~!
Gr8 teaching! thank you for sharing the valuable videos...
Welcome!
Greetings from Kenya, this was amazing presentation
Thanks!
Thank you very much for this. Thorough and comprehensive!
Not to mention that you often sound like Lewis Black in voice, accent and inflection. I anticipated expletives and tantrums, and got none.
Hi Kris - well it is a family channel, haha
Really amazing for your explanation. Thanks a lot.
Glad it was helpful!
Primary key for owner may change if owner moves auto number is better
Thank you so much for the very useful tutorial.
I have never really understood Access and this tutorial was very well put together and you explained everything very well
You're very welcome!
Keep up the good work, it really helped me and many others!
Thanks, will do!
your videos are so helpful, thanks
Happy to hear that!
There is an issue when you get to 2:23:29 forward. It jumps over Creating Relationships with Lookup Lists and go straight to The Relationship Window. Very very confusing. The Custodian Table is not there anymore and a new table called Technician is there instead. How did that happen?
i guess some problem while editing the video
So impressive. Wish I could like a video twice.
This was extremely helpful and well-paced. Thank you so much!
You're very welcome!
simply the best. Much love from Kenya
Thank you for watching from California!
Me too from Kenya and I've watched all this series. Iam actually venturing into database business courtesy to u learnit and a few others. @ jargon master, any community of database programmers here?
Thank you so much Remain Blessed special people
You are very welcome!
Dear Dan, there is a gap in module 2 in time 2:33:35. it seems that there is a missing part here.
Yes there is a gap, but it's okay, it's not like a big skip
@@nassimjanah5035 I disagree, you start talking a lookup something? How did you connect the two Tables?
Thank you teacher, please will you mind if you send to us the link for practice files
Amazing instructor / teacher, outstanding tutorial!!! Thank you
You're very welcome!
very very useful tips................................never seen before this video..........Thanks sir............wow.......
You are very welcome AMA!
2:40:00
2:48:17 / two things needed to create a relationship
2:49:50 /shared field don't req to have same name only same data type
2:51:40 /parent table
2:57:58 /one to one relationship
3:12:28/ dealing with orphan records
3:27:00/ Cascade updated related fields
3:38:06/ Default Value
3:38:18/Data validation
basically if one's planning to updates table it not convenient at all to create relationships from the relationship tab, but from the lookup wizard. infact i don't see the point in creating those from the rela..tab then if it doesnt suggest you when it comes to enter new records in the child table..
Huhuu!!! You are such a great tutor. Your teachings voice kept sounding in my ear, how do I get link up for the rest of the tutorial services, I cannot wait, Thanks.
Thank you so much for watching etornam!
Excellent information, Lewis Black. Very easy to follow with easy explanations!
Glad you enjoyed it, Aaron!
Thanks, Nice lesson. Please where and how do I get the practice files to this video?
Hi Goodnews Digifa! The link to the exercise files is in the description!
Amazing stuff love all the videos! one question tho, what happened at 2:33:33 did it get cut off or skipped?
yes looks like there is an editing video error there
Manu thanks! GREAT VIDEO and I can tell you it has helped me a lot to start undesrtanding Access!
Great to hear!