Access Beginner Tutorial

Access Beginner Tutorial
Get Ad-Free Training by becoming a member today!
/ @learnittraining
Exercise Files: www.learnitanytime.com/p/exer...
Who it's For: Access is designed for people who are comfortable with spreadsheet programs like Excel. These users need more power and analyzation, as well as a stronger forward-facing interface.
What it is: Access is a database creation and management program. It helps you design, build, and interface with a robust database to help your organization run smoothly. Many small to medium-sized businesses use Access for this exact purpose.
What You'll Learn: This course starts with database basics, terms, and information you’ll need to confidently build your database later on. Then, you’ll learn how to build tables, determine relationships, query data, and create simple-to-use interfaces that other people at your company can use to interact with your data.
For ad free training and certificates please join Learnit Anytime:
www.learnitanytime.com
For Private Group Trainings please visit:
www.learnit.com/private-group...
Manuals: bit.ly/30xZb59
Username: manuals
Password: password
Part 1
Start: 0:00
Opening a Sample Database 0:03
The Database Objects 8:57
The Interface 14:51
Introducing Tables 20:12
Simple Data Entry 27:48
Introducing Queries 31:01
Practicing Data Entry in Queries 40:01
Introducing Forms 41:06
Data Entry Into Forms 46:49
Introducing Reports 47:35
Sorting to Create Groups 53:33
Finding Data in Tables 1:04:28
Filtering 1:10:30
Adding Total Rows 1:20:15
Starting a New Database 1:24:14
Creating Tables in Design View 1:33:02
Entering Your First Record 1:47:22
Using Quick Starts to Create Tables 1:51:12
Entering Data Into Your Second Table 2:10:25
Summary 2:19:34
Part 2
Introduction 2:22:28
Looking at the First Draft of a Database 2:23:29
Creating Relationships with Lookup Lists 2:29:41
The Relationships Window 2:33:33
Relating by Dragging Field Names 2:36:52
Dragging to Create 1-to-1 Relationships 2:57:30
Changing Dragged Relationships to Lookup Relationships 3:00:30
Limit-To-List Properties 3:09:43
Enforced Referential Integrity 3:15:12
Seeing the Referential Integrity Being Enforced 3:22:41
Cascade Edits and Deletions 3:26:52
More Field Properties 3:33:55
#Access
(C) 2021 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.

[@LearnwithCSDTech]

This is the best course for MS Access that I found on KZbin. I appreciate you for creating that much valuable content freely available to all. Thank you very much!

[@LearnitTraining]

You're very welcome!

[@jamesgrant5945]

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

[@jesuslovesyou1]

Glad you got more out of it

[@zainshah8644]

Sir I m 50 year old and I inspired to you 🎉.

[@ethansodaro3945]

A silky voice, excellent sense of humour and superb quality course. Dan McAllistar, thank you! I really enjoyed following along.

[@LearnitTraining]

Awesome, thank you!

[@user-nf5ir9li4y]

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!

[@LearnitTraining]

Glad you enjoyed it!

[@damienhackney6499]

Excellent teacher. Thank you!

[@shopsurvival1652]

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.

[@LearnitTraining]

Thanks!

[@michellguzelgul4267]

So impressive. Wish I could like a video twice.

[@justdifficult]

Enjoyed the course. Only recommendation would be to correct whatever happened at 2:33:33.

[@shahinulkhan7879]

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.

[@LearnitTraining]

Hi Shahinul! That is great to hear! We are glad you learned so much!

[@oasispath]

Thank you very much , Good work - you are an excellent professional.

[@MaineBassGuy]

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.

[@LearnitTraining]

Thank you Brad!

[@lsansco3012]

Took one look at the display pic for this guy and I knew this was the guy I needed to teach me this stuff

[@LearnitTraining]

Dan was the definitely the guy to teach anything really!

[@richardgiannamore2562]

Great Job. Thanks.

[@LearnitTraining]

Thanks for watching!

[@kazerog2000]

I am an an experienced access user, but I found many small things I did not know. Thank you for the tutorial.

[@LearnitTraining]

You're welcome!

[@pwsoultrainn4090]

Success in life comes from great teachers

[@LearnitTraining]

We think so too!

[@RobertBrunnerBREG]

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.

[@LearnitTraining]

Thank you for the kind words!

[@MarcinScholke]

:)

[@b9watchkeeper903]

you are such an amazing teacher.i love to have private classes whenever possible,,,100 percent undertood.

[@LearnitTraining]

Any time!

[@grahamlamming1128]

Best style of teaching I’ve come across. By far the best, love it.

[@LearnitTraining]

Wow, thank you!

[@veronicacebanu7210]

The best explanation! It’s very easy to understand with this wonderful sense of humor! Great 👍 job! Thanks 🙏!

[@LearnitTraining]

Thank you! 😃

[@jmxxx7425]

Thanks for the video, really good and easy to follow.

[@koteshwarpanuganti3507]

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.

[@LearnitTraining]

You are most welcome!

[@theweeklychart]

Thank you so much for this great video. This is excellent content.

[@mjl1966y]

Oh man, it has been at least 15 years since I've done the Northwind thing. Amazing how much you can forget!

[@raizadavarun]

Absolutely mind blowing method of sharing knowledge ! Thanks a ton for putting in this awesome effort

[@LearnitTraining]

Thank you for watching Varun!

[@ErmaPeachey]

This is the most effective strategy I've ever come across. It's like magic!

[@LearnitTraining]

Thanks!

[@relupandra4157]

Keep up the good work, it really helped me and many others!

[@LearnitTraining]

Thanks, will do!

[@mehdi.sajadi]

You're the best instructor ever, and explain everything in detail, thank you very much

[@LearnitTraining]

You are very welcome!

[@nextstep2239]

Thank you so much, you're seriously an amazing trainer.

[@LearnitTraining]

You're so welcome!

[@gersiveshi]

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!

[@LearnitTraining]

Thank you!

[@andyrbush]

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.

[@LearnitTraining]

You're very welcome!

[@deeanngunnells6867]

This was extremely helpful and well-paced. Thank you so much!

[@LearnitTraining]

You're very welcome!

[@cool7500]

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

[@LearnitTraining]

You're very welcome!

[@arunshinde1507]

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.

[@LearnitTraining]

Thank you Arun! We hope you learned alot!

[@okenkei-solutions452]

So far so good this is the best Access course I’ve come across. Thank you so much for this quality but free video.

[@LearnitTraining]

You're very welcome!

[@taorostrickland6643]

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

[@LearnitTraining]

Awesome, thank you!

[@semagull6126]

Your good work is visible, even to the one who doesn’t want to see. Job well done and May you be rewarded handsomely!

[@andorelamarra]

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

[@LearnitTraining]

You're welcome!

[@jeffdeutsch]

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

[@LearnitTraining]

Thank you for watching and an extra big thank you for subscribing!

[@cparedes2302]

Manu thanks! GREAT VIDEO and I can tell you it has helped me a lot to start undesrtanding Access!

[@LearnitTraining]

Great to hear!

[@peshawarvines7822]

Just ended This Video and I Am !00% Statisfied It Was Worth It. Best Teacher On KZbin For Computer Programs Learnings

[@LearnitTraining]

Thank you Najeeb!

[@mepshtain]

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.

[@LearnitTraining]

Thank you for the kind words Moshe! Dan was one of our best instructors and is deeply missed here at Learnit!

[@aarondonley5057]

Excellent information, Lewis Black. Very easy to follow with easy explanations!

[@LearnitTraining]

Glad you enjoyed it, Aaron!

[@josiahzimmerman5724]

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

[@LearnitTraining]

You're very welcome!

[@Death10186]

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!

[@LearnitTraining]

You're very welcome!

[@victoralos6759]

Amazing instructor / teacher, outstanding tutorial!!! Thank you

[@LearnitTraining]

You're very welcome!

[@omlahoti1516]

Thank you for a great session , you are an excellent teacher,

[@LearnitTraining]

You are very welcome

[@vitaliiarkhypenko1970]

Great training. Thanks a lot.

[@emilycanada7903]

this is the best access tutorial on youtube. thank you so much. helped me a lot

[@LearnitTraining]

You're welcome!

[@victoriabillah6125]

I’m really enjoining this tutorial so far and the the instructor is a gem thanks

[@LearnitTraining]

You are welcome!

[@muditrustagi5775]

HANDS DOWN THIS IS THE BEST VIDEO EVER

[@LearnitTraining]

Thank you for the kind words Mudit!

[@kebincui]

The best and clear ACCESS tutorial 👍

[@LearnitTraining]

We appreciate that!

[@CrisStuart]

⭐⭐⭐⭐⭐ 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... !!!! 🙏🙏🙏

[@LearnitTraining]

Thank you so much for the kind words Cris! We are glad you learned so much!

[@JAzzWoods-ik4vv]

thank you very much for uploading this. I need to learn access for a job abd this is a really comprehensive tutorial

[@LearnitTraining]

You are weclome J.Azz Woods! Good luck on your job!

[@MegaPekota]

You're seriously a top trainer. Many thanks for this great session.

[@LearnitTraining]

Glad you enjoyed it!

[@melliem7481]

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

[@redsanders8754]

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!

[@redsanders8754]

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

[@jstan3076]

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

[@liouaflazi9537]

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.

[@LearnitTraining]

Wow, thanks!

[@filipepa106]

That was extremely helpful, thanks!

[@LearnitTraining]

Glad it helped!

[@proudlycanadian3023]

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!

[@LearnitTraining]

You're very welcome!

[@emmanuelboluade3326]

Thank you for bringing so great value to us for free. God bless you real good

[@LearnitTraining]

You are so welcome!

[@antoninostaiano389]

Learning Access has never been so funny! Thank you Sir! :)

[@LearnitTraining]

Glad you enjoyed it!

[@christophesafarilwiyando8502]

That was a masterpiece for real!!! Thanks a lot Teachers

[@LearnitTraining]

Glad you enjoyed it!

[@ahmadkadid1022]

​uhh i cant wait for the video i want it so bad i know for a fact that it is going to be so helpful

[@AndyMelton]

Thank you! This was fantastic!

[@LearnitTraining]

You're so welcome!

[@Qnbee007]

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

[@LearnitTraining]

Glad you liked it!

[@SujonAhmed26]

Thank you so much

[@faresalaa4562]

Thank you for sharing this with us, it was really helpful and amazing explanation.

[@LearnitTraining]

You are very welcome Fares! Thank you for watching!

[@naranlkhagba7235]

Thanks. Great tips, as always!

[@LearnitTraining]

Thank you for watching!

[@sebastianbenke8676]

Hahah, just did the course. I'am from germany - in 3:42:57 the word dumbkopf --- hilarious - did't know you are sometimes using that word too. Still, we say Dummkopf!😀😅🤣 Keep the good work! I'am in a new job now - this will get me further!

[@LearnitTraining]

We are so happy this has helped you at work!

[@shrikantoak6760]

Absolutely Amazing !!!!! Thank you very much

[@geoffphil]

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 KZbin content (on Inkscape), and am grateful to others like you who generously assist others to learn via KZbin.

[@LearnitTraining]

You are very welcome! We hoped you learned alot!

[@samirafateh2429]

Gr8 teaching! thank you for sharing the valuable videos...

[@LearnitTraining]

Welcome!

[@user-ey1xr9qo3v]

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.

[@LearnitTraining]

Thank you for watching!

[@InspirationJunction2]

VERY, VERY HELPFUL!!! THANK YOU!

[@LearnitTraining]

You are very welcome! Glad you are enjoying so many of our videos!

[@saqibiqbal8661]

Nice Lecture. Excellent sound and video quality. I will recommend to the peoples who are interested to learn in detail about MS Access.

[@LearnitTraining]

Thank you so much!

[@DjordjeGligorijevic-su1xw]

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]

You're very welcome!

[@user-xl6np6el1x]

YOU ARE A GREAT TEACHER FERNANDO!

[@LearnitTraining]

Thanks!

[@shikharlama]

Great learning

[@haroune711]

your videos are so helpful, thanks

[@LearnitTraining]

Happy to hear that!

[@jargonmaster2042]

simply the best. Much love from Kenya

[@LearnitTraining]

Thank you for watching from California!

[@kensimba7868]

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?

[@JayPatel-ds1xp]

Very well explained. Thank you.

[@LearnitTraining]

You are welcome!

[@yinyinmay871]

Really amazing for your explanation. Thanks a lot.

[@LearnitTraining]

Glad it was helpful!

[@tonylearner7636]

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.

[@LearnitTraining]

Hi Tony! We are glad you learned so much!

[@coachkyokushin5100]

This teacher is the best!

[@LearnitTraining]

Thank you for the kinds words Coach!

[@parthtiwari6802]

"if you have ever had double a wedgie you know how painful that can be" saw that coming, still laughed out loud. Thanks for keeping it interactive.

[@peytonsonny135]

sorry to be offtopic but does anybody know a trick to log back into an Instagram account..? I somehow forgot the account password. I would appreciate any help you can give me.

[@bentonmohamed1369]

@Peyton Sonny Instablaster ;)

[@peytonsonny135]

@Benton Mohamed Thanks for your reply. I got to the site thru google and Im waiting for the hacking stuff now. Looks like it's gonna take quite some time so I will reply here later with my results.

[@peytonsonny135]

@Benton Mohamed It worked and I finally got access to my account again. I'm so happy! Thanks so much, you saved my account!

[@bentonmohamed1369]

@Peyton Sonny Glad I could help :)

[@amazingkris]

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.

[@LearnitTraining]

Hi Kris - well it is a family channel, haha

[@doududuo6686]

Excellent tutorial.Thank you.

[@LearnitTraining]

You are welcome!

[@ajitdhas1097]

Thank you for such informative session.

[@LearnitTraining]

You are very welcome!

[@cool7500]

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

[@LearnitTraining]

We are currently looking at building some new coding videos. Stay tuned!

[@finlyfransismathew2057]

The diagram was an excellent choice. Thank you

[@LearnitTraining]

You are very welcome!

[@samschlenner6582]

THANK YOU for this.

[@LearnitTraining]

You are welcome!

[@user-ps2tm5xj1k]

Great course and huge efforts

[@LearnitTraining]

Glad you think so!

[@yuminxu4806]

too much helpful, great job!

[@LearnitTraining]

Glad it helped!

[@zainshah8644]

Very informative video. I learned Ms Access step by step with you sir. Thanks 👍

[@LearnitTraining]

Great 👍

[@tracykon8750]

Is there training for the rest of the Modules? Really enjoyed his teaching style.

[@malchicken]

There’s a playlist on the LearnIT channel collecting these modules.

[@YousefAlOmary]

Intermediate: kzbin.info/www/bejne/haKZp4B7r7mtjpY Advanced I: kzbin.info/www/bejne/Z2GtaqptiZeVhdk Advanced II: kzbin.info/www/bejne/h3KsYayBpaioqK8

[@horaciocastanedachavez5120]

I didn't know the God of Access existed, I'm so glad I found it.

[@LearnitTraining]

Thank you for the kind words Horacio!

[@guillaumem3810]

Excellent tutorial !

[@LearnitTraining]

Glad you liked it!

[@roy_biton]

Thank you very much

[@abdishukriadan9942]

Thank you teacher, please will you mind if you send to us the link for practice files

[@matthewwheeler9709]

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.

[@LearnitTraining]

Glad it was helpful!