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.
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.
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.
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.
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!
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
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!!!
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!!!!
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)
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 TH-cam 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.
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.
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.
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!
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!
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. :-)
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.
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!
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.
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 TH-cam. I am from Afghanistan and we have internet problems here.
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.
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. :)
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.
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.
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.
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 TH-cam. 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.
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.
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.
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
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..
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.
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.
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.. 😅
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.
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. :)😃
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
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💕
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.
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.
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.
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?
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
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?
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.
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!
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
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.
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.
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?
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.
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.
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. :)
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.
You're very welcome
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.
Thank you very much. You're too kind.
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.
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.
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!
2024 just started learning access. This is a gem!!!
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
Thanks. You're very welcome.
Funnilly enough I was going to mention the same thing, maybe it's a Joseph thing!
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!!!
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!!!!
Thank you VERY much for your kind words. :)
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)
Glad you enjoyed it! Rock on.
@@599CD Please sir share the link to Part 2
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 TH-cam 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.
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
You are the best MS Access Expert and Guide in the World.
I like this guy, i have been searching for a teacher for Access for a long time.
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.com/QQ
The best course i have ever attended in my lifetime. Thank you
You're very welcome. Thank YOU for the kind words.
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.
You are very welcome thank you for the kind words
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!
Welcome
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!
This video was sooo good. I went from knowing nothing to feeling like I can actually use access well.
Sweet
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. :-)
Thanks
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.
Database file should be here: 599cd.com/ACB1L
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!
Awesome. Thanks for sharing! Glad you like it.
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!!
Thanks
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.
Thank you very much for your kind words
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 TH-cam.
I am from Afghanistan and we have internet problems here.
Please allow me to download your videos to storage, 😢
your customer names are THE BEST
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.
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. :)
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.
Awesome. Thanks.
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.
Thanks
Very clear voice!! Very good teaching method. Thank you so much!!!
welcome
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.
Thank you. And yes, inches are easier in Access. :)
FANTASTIC!!!! Please make the next video available. TY😊
Thank you! Will do!
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 TH-cam. 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.
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.
Very helpful! I enjoyed your 4-hour course and still continuing to the next course
Can I just say that I love the shoutout to the Star Trek Next Generation characters! Awesome.
Sweeeeeet
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.
amazing teacher, thanks a lot for such a beautiful video
What an amazing resource! Thank you so much!
Glad it was helpful!
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
Thanks. You're very welcome.
Fab. I have Richard's earlier CD's and, as usual, great clarity. Must update my laptop & Office. Thank you. Bill
You're very welcome, Bill.
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..
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.
Glad you enjoy it!
The best four hour of instruction I’ve experienced. I’m on to lesson 2
Thanks
Awesome content. Everything well explained exhaustively. I'd like the next Level 2 series. Looking forward to continue with the learning
Thanks
Thank you for the helpful start!
he makes it fun and easy to lean
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.
You are correct. It's for beginners, hence the title "Beginner" Level 1. :)
Good teaching, very interesting and comprehensive. Thanks alot!
Thanks
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.. 😅
Freaky!!!!!
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.
Welcome
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. :)😃
Thanks... I think? :)
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
I speak how I speak.
Excellent Teacher, You won a new subscription. ❤️ From Pakistan
Sweet
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💕
You're welcome
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?
This is great. Thanks a lot Mr. Rost.
Welcome
Soooo good! Great instructor! Thanks Richard!
My pleasure!
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.
Sounds good. :)
like the guy and the videos. shame i can't afford to continue. the prices get ridiculous
I wouldn't say "ridiculous." The courses go up a couple bucks every level or two. I gotta feed my puppies, ya know. :)
Man, you are fantastic; God Bless you!
Thanks
BEST TEACHER, IT'S AMAZING LEARNING AND HAVING FUN
Thanks
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.
Easier to find them on my web site: 599cd.com/ACB1L
Thank you so Richards, much appreciated
Welcome
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.
Glad you enjoyed it. Levels 2 and up are ONLY available on my web site. They will not be uploaded to TH-cam. Go to 599cd.com/ACB2
Thanks so much ...
Your way of teaching is very very good. You are my hero
Sweet. Thanks. :)
You are awesome.
Thanks
I love the way you teach sir.....
thanks
This is a great tutorial.👍👍👍👍👍
Glad you liked it
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?
Thanks for your efforts
It's my pleasure
Thank u sir this is Incredible
But u said that u hate using da phone that means that u don't have Instagram right ?
very helpful thank you
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
Absolutely
Thanks for this lesson.
My pleasure!
Thank you for this video series. Can you send me the link to the next video? 👍
599cd.com/ACB2
Welldone. Thanks for sharing the wonderful tutorial.
You're welcome.
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.com/import
Richard Rost you're great.....
Awww... gee.... thanks. :)
I would like level 2, please
Level 2 is online. 599cd.com/ACB2
A friend of mine once told me that planning should take 75% of the time it takes to build a database. She was right.
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. :)
@@599CD Then again, she worked with mainframe computers, not Access...
Gosh thanks so much I've definitely learnt a lot
Glad to hear it!
thanks a lot :) , it is a useful course
Glad to hear that!
THANK YOU THANK YOU THANK YOU So helpful!
Any time!
Very useful
Glad you think so!
this is great material
Thanks
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.
Sure. Scan them as images and then use this technique to track them: 599cd.com/Images
@@599CD thank you somuch
i used access 2007 is this fine? I like the way you teach us
Yeah there's not a lot of difference between 2007 and today that was the last major overhaul
Good best teaching way
Thanks
THANK YOU SIR
Most welcome
I really enjoying this great lesson
Awesome! I appreciate that.
thanks , nice Tutorial
Welcome
Thanks for such great video sir
Most welcome
We only have Access 2000. What's the best place to get a really cheap version of Access 2019?
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!
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
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.com/qq
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.
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.
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?
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.
Thank you. It helps me a lot
welcome
So I created a 5x3 sized form in design then when viewed it fills the window. Why is it not showing it as 5x3?