Microsoft Access Beginner Level 1 - Complete 4-Hour Course

[@r.senthilramalingam4861]

I finished the 4 hour beginner training phase. It was a fantastic experience, and only now, after several training films, have I fully grasped MS Access. Thank you for your time and consideration, and please continue to educate us on this subject.

[@599CD]

You're very welcome

[@patricklimacher8065]

You have a very clear voice and accent, which makes it easy for a foreigner to follow your course. Furthermore, you structured the course didactically very well. I would like to thank you for this nota bene free service. I do not take it for granted. This is very good content.

[@599CD]

Thanks, Patrick. I don't have an accent (which is what everyone says) LOL. My fiance tells me I have an accent, but I don't hear it. :)

[@Galstaf]

This is invaluable, an engaging and very thorough foundation. I am taking your advice and not building my company's transition from Excel->Access just yet, but I have already tables, fields and formats well tweaked thanks to this. In the spirit of sharing, around 2:08:00 you are discussing date format and how dd/mm/yyyy is more logical than mm/dd/yyyy - the reason why the US still uses mm/dd is the postal service - vast continent and so people until relatively late were still writing just the month/year on correspondance because the precise day wasn't really relevent when it was going to take a month or two to reach the intended recipient, whereas in Europe even in the 1840s mail would get there in a day or two so people started introducing the day/month to their correspondance much sooner and so when standardisation came along we were in different places. Why the metric system hasn't been adopted yet - there's a several pint discussion.

[@599CD]

I personally prefer the ISO date standard which is yyyy-mm-dd. See 599cd.com/ISO. I have since switched all of my databases to that.

[@DilipTiwariVlogs]

I bought MS Access Course on Udemy and later on returned as this is far better than those paid courses. You are the best teacher . I would love to learn the Power App from you. Thanks!

[@Pwecko]

I'm half way through this video and I have to say it is excellent. I paid for a course but found it really difficult. The tutor went straight into building a database in the datasheet view and without preparing any tables beforehand. Even as a beginner, I realised that that wasn't a good way of doing it. Mr Rost, you are a superb teacher. I wish I'd found you first. Thank you for your efforts in making this video and presenting it to the world. You deserve a medal.

[@599CD]

Thank you very much. You're too kind.

[@enchantinglysimple]

I love how clear you are about the learning process and not rushing it! I have adhd, and so this type of instruction works really well for me. Thank you for making these videos for those who want to learn, but have never done it before. - Joseph

[@599CD]

Thanks. You're very welcome.

[@josephsy]

Funnilly enough I was going to mention the same thing, maybe it's a Joseph thing!

[@marcarmando713]

Hi, I just run into your Access 1 tutorial and I can't regret it. I thank God for making our paths met. I wasn't aware what Access has as efficiency tools for effective management. I have a lot to learn and I am engaged to it. THANK YOU A Bunch!!!

[@alphaxg1]

This is the absolute best Microsoft Office-based training anywhere! Mr. Rost is a master teacher. I've learned so much in such a short period of time. His teaching style enables fast learning and very strong retention. This is like taking an expensive university course. OUTSTANDING!!!!

[@599CD]

Thank you VERY much for your kind words. :)

[@religood]

2024 just started learning access. This is a gem!!!

[@bradburkham7817]

This is my second time through and am still learning stuff I missed last year. MY RECCOMENDATION to students is have 2 screens, one to run the video and second to build the database. Work your way through the database start, stop and rewind as needed following along, I don't type as fast as your instructions.

[@599CD]

599cd.com/QQ

[@mikesamyn7054]

I am very impressed with the work you've have done to teach Access. Back in 2001-2008 I developed an Access DB for our engineering group to house combustion engine design and test data. Learned it through books and hard knocks, but boy I could have used this set of KZbin classes! Hats off to you. I am again strating back into Access to magange a much simpler set of data for my HOA. With your help it will make my job much easier! Thanks you for the refresher.

[@599CD]

Yeah I wish I had my tutorials back when I started learning Access in 1994 LOL. If you're making an HOA database check this out 599cd.com/Assoc

[@carlosalfredo4226]

The best course i have ever attended in my lifetime. Thank you

[@599CD]

You're very welcome. Thank YOU for the kind words.

[@kenlynch8414]

This is a great vid, Access is finally getting into my head after many previous attempts elsewhere. I like this guy, everything is explained perfectly and with a bit of personality and humour....and any fan of Rush, gets my vote every time.....thank you :o)

[@599CD]

Glad you enjoyed it! Rock on.

[@taslimjimah1978]

@@599CD Please sir share the link to Part 2

[@dmp7252]

Astoundingly good! Thanks to you, I was finally able to create a powerful multilingual glossary. Managing the terms in several languages was becoming unwieldy. Some glossaries were in Word, others in Google Sheets, etc. But thanks to you, I can use MS Access to create one centralized glossary and from there filter / query as needed. You're amazing!

[@blackbird7n90]

This is probably the first time i finally get to understand how to use Access. i understand its use and benefits, but never have i used it first hand properly. I am eager to get to your advanced classes that talk about VBA, but i need to have patience to learn the basics first haha Thanks Mr. Richard for your time and effort, hope you are doing well.

[@599CD]

You are very welcome thank you for the kind words

[@benjaminstewart3694]

Been watching different videos of yours for a few weeks or so now. Love your knowledge, thorougness and teaching style! Keep up the great work!!

[@599CD]

Thanks

[@aniwenetv]

I like this guy, i have been searching for a teacher for Access for a long time.

[@luminancetech]

Very clear voice!! Very good teaching method. Thank you so much!!!

[@599CD]

welcome

[@TikkuDiaries]

You are the best MS Access Expert and Guide in the World.

[@blacksham24]

i was interested in Access long before when I was younger. Now I have a small business that needs a better application than Excel, here I am studying back at your lessons. thanks much!

[@599CD]

Welcome

[@davidbates8455]

FANTASTIC!!!! Please make the next video available. TY😊

[@599CD]

Thank you! Will do!

[@tassawarhussainnoor8199]

amazing teacher, thanks a lot for such a beautiful video

[@mohamedkanu66]

As a Network Administrator, I was looking for a place to get some database grasp b4 proceeding to learning SQL. In all sincerity, I thank the day my mouse said click here as I am fascinated about dbs having gone through the 4 hours tuts. Thanks for the great mentorship boss. Heading to your site to purchase Beginner Level 2. Just looking to climb the ladder from here!

[@599CD]

Awesome. Thanks for sharing! Glad you like it.

[@patrickwinham]

This video was sooo good. I went from knowing nothing to feeling like I can actually use access well.

[@599CD]

Sweet

[@ShelleyWillock]

What an amazing resource! Thank you so much!

[@599CD]

Glad it was helpful!

[@desrazor5635]

Dear Mr Rost. I've been doing a Souters course to learn Access, and I've found it a slow and boring process. Thank goodness I found your excellent course. You explain things in an easy, straightforward, manner. By watching your vids, I now understand WHY I am doing things, and that really helps me to learn. If I don't get my brain around WHY I am doing something, then nothing sinks in, I get bored, and my mind wanders. Your teaching method is superb, and I congratulate you. Thank you so much for sharing all this valuable knowledge. I can't wait to put into practice everything that you are teaching me.

[@599CD]

Thank you very much for your kind words

[@029fridazerlina2]

Very helpful! I enjoyed your 4-hour course and still continuing to the next course

[@asarand]

I have some experience with Access, but it was (I think) the original version from back in 1999-2002. It was included in Office Pro, which I purchased for my Windows 2000 computer. I was learning Office as part of my curriculum at DeVry, though they didn't cover Access, so I was teaching myself. After that Access was removed from Office at some point, so when I came back to it with Office 2016 I was unable to continue with it. When I purchased Office 2021 I had to purchase Access separately. I have forgotten most of what I knew before, but watching your 37 minute video helped me remember the basics. Now I'm trying to remember relationships, but I am watching this entire video (and will be building the sample database you walk us through) so I can make sure I glean everything I never knew. I just went to your site. Things have changed since you made this video and the page the link goes too isn't the same. I had to hunt to find the database file.

[@599CD]

Database file should be here: 599cd.com/ACB1L

[@michaelsvenson2456]

I started like you in the mid 90´s. Northwind Database, but I was so lost when i tryed to understand it so I thought it was to hard for me. Most of my learning was by trial and error, and it worked then, everything, forms, tabels, reports, pictures and buttons, but was not so professionally done as your databases. Your videos is great, easy to follow and with a little humor in it. Nice work. :-)

[@599CD]

Thanks

[@moizrashid6373]

Brilliant training Richard. You made the the concepts so easy to grasp. I am slowly moving away from Excel to Access for those of my projects having lots of data and not necessarily having to do any data analysis on them. Thanks a lot

[@599CD]

Thanks. You're very welcome.

[@MagicBanana11]

Thank you for the helpful start!

[@nwachiikechukwu257]

Good teaching, very interesting and comprehensive. Thanks alot!

[@599CD]

Thanks

[@tahjscott429]

These tutorials are so good, easy to follow and I'm definitely learning. I'm aiming to become certified in MS Access, and will be using your course to do the MS Access Expert Exam. Wish me luck.

[@abdulahadkhamsoh3229]

Hi sir You are a good teacher ever, I will download your videos. Thanks a lot for everything. And sorry for downloading your videos from KZbin. I am from Afghanistan and we have internet problems here.

[@abdulahadkhamsoh3229]

Please allow me to download your videos to storage, 😢

[@MatthewThomas-d1x]

This course was perfect for my needs. The pace was perfect, it is easily searchable for reviewing a topic and I greatly look forward to viewing the other videos.

[@599CD]

Awesome. Thanks.

[@augustusmakori5984]

Awesome content. Everything well explained exhaustively. I'd like the next Level 2 series. Looking forward to continue with the learning

[@599CD]

Thanks

[@drywaller12345]

Fab. I have Richard's earlier CD's and, as usual, great clarity. Must update my laptop & Office. Thank you. Bill

[@599CD]

You're very welcome, Bill.

[@amanda-sophiap6877]

Soooo good! Great instructor! Thanks Richard!

[@599CD]

My pleasure!

[@markkinkle7038]

You are amazing. This content is going to help me optimize business processes for a large government organization. The work you are doing is so important. You will be blessed.

[@599CD]

Thanks

[@missread7781]

Thank you so much for this course. I just wanted to let you know that I personally found it easier to design a form using US measurements in Design View. (I changed it from metric in windows settings as I live in UK.) Also you are never too old. I am 71 and a membership secretary for a local lace making group. Previous secretary used a spreadsheet. Ok stop screaming yes it was a nighmare. This is so easy to follow. You can teach an old dog..... Thank you again.

[@599CD]

Thank you. And yes, inches are easier in Access. :)

[@MoodyAlshehaby]

Thank you, first time for me to open access, and it's going well so far, thanks to you. I admit I was kind of furstrated the first 40 minutes, but after starting getting into access I started to feel good. Will go through next levels and up to the advanced level, I am excited. Thank you.

[@599CD]

Welcome

[@quasideus1157]

Thank you for this vid of yours i really need refresher like this, gosh all I've learn in my college just flush out of my mind. Thank you, thank you, thank you so much💕

[@599CD]

You're welcome

[@Vic-wb7gs]

The best four hour of instruction I’ve experienced. I’m on to lesson 2

[@599CD]

Thanks

[@activedogservices]

OK, got hooked knowing Captain Picard is a customer from the late 24th century, I guess he is on Access 2350. Unsure if the Ferengi want this close a scrutiny over there afairs with so much organisation. This is truly brillaint and yes will go onto the next lesson and beyond. I was scared stiff of using access however this has made it so simple to use. Yes keep going over and repeating it really has helped, this is the first data base in access I have built and so far its been a doddle. Thank you.

[@599CD]

Ha ha. The Federation found an old copy of QuickBooks and sent it to the Ferengi Alliance. They're still trying to figure out what to do with it. I'd say QuickBooks is a virus... but a virus actually DOES something. :)

[@musisir1927]

This is great. Thanks a lot Mr. Rost.

[@599CD]

Welcome

[@nour-eddineoumakhlouf5296]

Thanks for your efforts

[@599CD]

It's my pleasure

[@shafiqueahmad9024]

Your way of teaching is very very good. You are my hero

[@599CD]

Sweet. Thanks. :)

[@leonmihaescu5651]

Man, you are fantastic; God Bless you!

[@599CD]

Thanks

[@karmelafilonowich]

very helpful thank you

[@gjonmarku6719]

This is a great tutorial.👍👍👍👍👍

[@599CD]

Glad you liked it

[@friendfortheartists]

Your presentation is excellent. This stuff can lean to boring, but you kept it thorough yet interesting. In fact, your video is the best presentation on KZbin. Looking for a place to send subscribers for a complete Access Training Course. I used to program with Clarion as well. Learned a couple new tricks watching this video. Going to be building a little Access database for camera and art materials. I did not want to start from the beginning in database training. Hope you do not mind the referral. It does not make sense to reproduce a video when there is already one done very well. The video will cover and act as documentation of the Art Materials database. Intend to make the database available to subscribers of my Channel.

[@599CD]

Why would I mind referrals? LOL. You are of course more than welcome to point people to my videos if they need to learn Access. Thank you, and thanks also for the compliments.

[@michaelmutombo453]

Thank you so Richards, much appreciated

[@599CD]

Welcome

[@alializadeh8195]

Thanks so much ...

[@dream2508ful]

BEST TEACHER, IT'S AMAZING LEARNING AND HAVING FUN

[@599CD]

Thanks

[@silverharmony8675]

your customer names are THE BEST

[@dilrai9551]

Thanks for this lesson.

[@599CD]

My pleasure!

[@Khuram_Shahzad]

Excellent Teacher, You won a new subscription. ❤️ From Pakistan

[@599CD]

Sweet

[@partner779]

thank you Mr Richard for your perfect videos... my database project is almost done, and it has been useing since Jan 23 and works will. but the problem is, it removes all objects such as forms, quires, modules and reports after some days or months! just all the tables remains with all records inside ! I don't know why it happens ?? the only way for me is to import all it's tables to another database to restore it like previeus, even if I want to import object form other database to the main database, it doesn't show them!! thanks for your greate idea..

[@sonamdorji7176]

I love the way you teach sir.....

[@599CD]

thanks

[@MrAimalsultani]

Welldone. Thanks for sharing the wonderful tutorial.

[@599CD]

You're welcome.

[@SvenJanssens]

My goodness , so great to have found this. Even considering joining the channel. I have been looking for someone to build a good database for our foodbank, that should hold a lot of information and date calculations, etc ... Since I can't find anyone ... LOL ... (figures) I have been looking to use MS Access as a platform to build the database on. Looking around the net ... I found your channel and seem to like it. :-) Thanks for all of this. It helps. I have high expectations and I think they will be fulfilled.

[@599CD]

Sounds good. :)

[@mrglass311]

Good information taught. Personally, I thought there is a lot of over-explaining. Could probably be cut down to 2 hours, but I understand it is for beginners and not all people grasp information the same. Thanks for the course.

[@599CD]

You are correct. It's for beginners, hence the title "Beginner" Level 1. :)

[@tinalouiseginger9711]

After having years of experience with Excel (transitioning to Access for efficiency) - I found this four-hour class a tiny bit excruciating (just because of the pace - can't go THAT fast - so understandable) BUT! Tips and tricks aren't quite "Easter Eggs" - but if you didn't know to look for it, it almost rises to that level of awesomeness. :)😃

[@599CD]

Thanks... I think? :)

[@atmoms2]

THANK YOU THANK YOU THANK YOU So helpful!

[@599CD]

Any time!

[@saleem2148]

Good best teaching way

[@599CD]

Thanks

[@edwardsapu2032]

I really enjoying this great lesson

[@599CD]

Awesome! I appreciate that.

[@romaniangal1]

he makes it fun and easy to lean

[@ErinBaker-o1d]

Can I just say that I love the shoutout to the Star Trek Next Generation characters! Awesome.

[@599CD]

Sweeeeeet

[@mdnureazam2858]

I finished Total course it's Ammezing, Great Jod Sir. Sir I from India, so it's so difficult to catch your language plz Say slowly then we can understand easily. God bless you Sir

[@599CD]

I speak how I speak.

[@sniper59kta]

thanks , nice Tutorial

[@599CD]

Welcome

[@biro313]

thanks a lot :) , it is a useful course

[@599CD]

Glad to hear that!

[@Scientificandresearch]

Very useful

[@599CD]

Glad you think so!

[@christy967]

Gosh thanks so much I've definitely learnt a lot

[@599CD]

Glad to hear it!

[@edwardsapu2032]

Richard Rost you're great.....

[@599CD]

Awww... gee.... thanks. :)

[@golfrep2584]

Thank you for this video series. Can you send me the link to the next video? 👍

[@599CD]

599cd.com/ACB2

[@capitalinstitute9183]

Ultimately i watched this video, it was really interesting and best for me because i am access beginner waiting restlessly for level 2,3 and so on. Please upload them soon bundle of love from Pakistan.

[@599CD]

Glad you enjoyed it. Levels 2 and up are ONLY available on my web site. They will not be uploaded to KZbin. Go to 599cd.com/ACB2

[@umairpioneer]

I've completed your 4 hours+ beginner course yesterday. It was incredible. I kept patience as you'd repeatedly said, don't jump! Lol. Nevertheless, I enjoyed your class it was a really good start.

[@599CD]

Glad you enjoy it!

[@DerekFreeman-g2l]

Like your training style very much. Quick Question, Is Access a suitable Application for Notification Tracking where, 1) one wishes to Reduce Data Entry workload by having only to enter relevant Data in one Table and allowing identical fields in other related Tables of the Database be automatically populated /updated without the necessity for duplicting / repeating data entry into those different but related tables, and 2) where it is envisaged to include a field with a short abstract / notification txt summary up to 1000 words / 10,000 characters). Thanks

[@599CD]

Absolutely

[@jeetendrasinghbhadauriya3395]

THANK YOU SIR

[@599CD]

Most welcome

[@kerrbearofaustin]

You are awesome.

[@599CD]

Thanks

[@rwj3004]

like the guy and the videos. shame i can't afford to continue. the prices get ridiculous

[@599CD]

I wouldn't say "ridiculous." The courses go up a couple bucks every level or two. I gotta feed my puppies, ya know. :)

[@reachin4thetop709]

this is great material

[@599CD]

Thanks

[@louismancuso6263]

I would like level 2, please

[@599CD]

Level 2 is online. 599cd.com/ACB2

[@finleydavis118]

I’ve scanned through the comments and I can’t find the answer...where exactly are the links listed below? I’m not finding any and every one of these FANTASTIC lessons describes links below to find bits of information that I would like to learn! This has to be one of the best Access classes I have ever played.

[@599CD]

Easier to find them on my web site: 599cd.com/ACB1L

[@suzierj2002]

Your training is wonderful! Do you have a suggestion or a video on a membership data base that we have a spouse and children associated with the account but would need to pull up the spouse at any given time. So like we have John Doe but spouse name is Jane Smith . . . would you include her with John Doe or create a separate membership?

[@capitalinstitute9183]

Thanks for such great video sir

[@599CD]

Most welcome

[@MarTin-dn9oe]

Richard, I love your lessons you’re doing a great job. I have a fund that holds money for several clients. They send me their bills and I pay them for the client. Is there anyway I can scan their bills into access for future reference.

[@599CD]

Sure. Scan them as images and then use this technique to track them: 599cd.com/Images

[@MarTin-dn9oe]

@@599CD thank you somuch

[@MarySanfilippo-q2n]

This course is fantastic, but I could use your script for each slide. Or, do you have a hard copy I can get of this course?

[@elreenmatawaran3057]

It's so coincidental that I am going through this tutorial same month and day the video was filmed but in different year... I was stunned when you clicked the calendar icon in CustomerSince field and it showed Feb 24.. 😅

[@599CD]

Freaky!!!!!

[@georgerlopez]

I agree with all here. Your method and the speed is dead on. I have a program that is no longer being made and updated. They recommended that I go to another provider, but its based on Access and I have the tables. I will be looking to impport and to create my own interphase. Can you provide a link to an import class?

[@599CD]

599cd.com/import

[@AngkelJojo]

i used access 2007 is this fine? I like the way you teach us

[@599CD]

Yeah there's not a lot of difference between 2007 and today that was the last major overhaul

[@Polymathicus]

What's the best practice for a "clients" table creation when my clients aren't necessarily a specific person or company. In other words, I might have a client that doesn't have a company, or they are employed at company, but might go to another company, and I may be still working for their replacement at that original company now, and also them at the new company. And now I need to somehow keep track of completed and future jobs and tie them to the above mess. How should I build my "clients" table to prepare for the above scenario? Thanks!

[@599CD]

The BEST practice is to have a separate CompanyT table and a PersonT table. Use a many-to-many relationship to join them. However, this is a lot more difficult to explain to a beginner than just putting a CompanyName field in a customer record. See 599cd.com/ManyToMany

[@Lacronh]

We only have Access 2000. What's the best place to get a really cheap version of Access 2019?

[@wattjock2405]

Thank you for this course! I am having an issue with the date/time cell... I type in 55 and it tells me that "the value entered does not match the date/time..." The field is set as date/time... any recommendations for this issue?

[@599CD]

Well if this is a date time field then 55 is not a valid date time so you'll have to enter something in that's either a date like 1/1/24, or a time like 5:50, or both.

[@LHPottery]

A friend of mine once told me that planning should take 75% of the time it takes to build a database. She was right.

[@599CD]

Not sure if it's that high... but damn close. The more time you spend up front planning, the lesson "oh shit!" moments you'll have later. :)

[@LHPottery]

@@599CD Then again, she worked with mainframe computers, not Access...

[@dlojan5786]

How can i add new record but not in the end of records i want to add new record in between two existing records ????? please advise if you can

[@totoghertpaclibar8176]

Thank you. It helps me a lot

[@599CD]

welcome

[@ThreeGsHomeschool]

We homeschool our 2 children. I am wanting a digital program to keep of with their classes, grades, and attendance. I would like to be able to run custom reports (report cards, attendance reports, or transcripts). Would you suggest access or Excel? Also, would you be interested in creating this program? Thank you for all your videos, I purchased a bunch of the Excel ones a few years ago.

[@599CD]

599cd.com/qq

[@nunopereira4374]

Hi, excellent course. You keep telling that there are links below for some "side stuff" like backup. Where is that ? Below I only see comments.

[@599CD]

Look down between the video and the comment section. We'll find a description there and it will usually say show more at the end. Click on the show more.

[@kazzdevlin5339]

So I created a 5x3 sized form in design then when viewed it fills the window. Why is it not showing it as 5x3?