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.
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 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
My first MS Access Lesson, I have used other databases but never bothered to learn Access. Hope to make the most out of this one. Thanks for making it free
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 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!!!!
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!!!
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 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 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)
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.
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.
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!
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.
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. :-)
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!
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!
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.
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.
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. :)
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.
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.
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
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.
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.
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💕
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. :)😃
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..
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.
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.
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.
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.
I have that problem when I resize a text field for the whole text to be visible and my YES/NO field next to it becomes gigantic and pixalated. I cant fix it. When you resize the row your IsActive field becomes larger but the checkbox in it stays the same. Im with the latest windows
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'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.
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.. 😅
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.
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
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.
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 saved the query as CustomerNYQ and it didn't show up in the query list. Instead, the CustomerQ query is now the NY query. What happened? I got it to work, but now both queries are showing the same thing. This doesn't make sense to me.
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?
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.
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?
Yeah, basically. In the old days, it was forms on the screen and reports on paper, and that's the analogy I still like to use, although you can still preview a report on the screen or send it as a PDF file. Basically, anything you would print would go into a report.
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.
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
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 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!
My first MS Access Lesson, I have used other databases but never bothered to learn Access. Hope to make the most out of this one.
Thanks for making it free
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 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. :)
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!!!
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 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
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
2024 just started learning access. This is a gem!!!
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
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
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
The best course i have ever attended in my lifetime. Thank you
You're very welcome. Thank YOU for the kind words.
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
I like this guy, i have been searching for a teacher for Access for a long time.
This video was sooo good. I went from knowing nothing to feeling like I can actually use access well.
Sweet
You are the best MS Access Expert and Guide in the World.
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
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!
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.
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
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. :)
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. :)
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, 😢
Very clear voice!! Very good teaching method. Thank you so much!!!
welcome
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.
good morning sir your video is very interesting I learnt a lot from this video
FANTASTIC!!!! Please make the next video available. TY😊
Thank you! Will do!
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.
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
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.
Very helpful! I enjoyed your 4-hour course and still continuing to the next course
The best four hour of instruction I’ve experienced. I’m on to lesson 2
Thanks
Can I just say that I love the shoutout to the Star Trek Next Generation characters! Awesome.
Sweeeeeet
Awesome content. Everything well explained exhaustively. I'd like the next Level 2 series. Looking forward to continue with the learning
Thanks
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.
What an amazing resource! Thank you so much!
Glad it was helpful!
amazing teacher, thanks a lot for such a beautiful video
Good teaching, very interesting and comprehensive. Thanks alot!
Thanks
Thank you for the helpful start!
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
your customer names are THE BEST
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? :)
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..
So I created a 5x3 sized form in design then when viewed it fills the window. Why is it not showing it as 5x3?
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
Soooo good! Great instructor! Thanks Richard!
My pleasure!
Excellent Teacher, You won a new subscription. ❤️ From Pakistan
Sweet
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
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. :)
This is a great tutorial.👍👍👍👍👍
Glad you liked it
BEST TEACHER, IT'S AMAZING LEARNING AND HAVING FUN
Thanks
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. :)
This is great. Thanks a lot Mr. Rost.
Welcome
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.
I have that problem when I resize a text field for the whole text to be visible and my YES/NO field next to it becomes gigantic and pixalated. I cant fix it. When you resize the row your IsActive field becomes larger but the checkbox in it stays the same. Im with the latest windows
I don't understand. 599cd.com/ask
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.
Your way of teaching is very very good. You are my hero
Sweet. Thanks. :)
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!
Man, you are fantastic; God Bless you!
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!!!!!
I love the way you teach sir.....
thanks
he makes it fun and easy to lean
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?
Thanks for this lesson.
My pleasure!
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
Thank you so Richards, much appreciated
Welcome
Thanks for your efforts
It's my pleasure
Thanks so much ...
very helpful thank you
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 only have Access 2000. What's the best place to get a really cheap version of Access 2019?
Welldone. Thanks for sharing the wonderful tutorial.
You're welcome.
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.
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
I saved the query as CustomerNYQ and it didn't show up in the query list. Instead, the CustomerQ query is now the NY query. What happened? I got it to work, but now both queries are showing the same thing. This doesn't make sense to me.
No clue. Hard to tell what you did from here. :)
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. :)
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
What about case sensitive? If I have a vendor USAirConditioning... If I search without caps, will it find my search?
Check that Match Case box.
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 THANK YOU THANK YOU So helpful!
Any time!
Thank you for this video series. Can you send me the link to the next video? 👍
599cd.com/ACB2
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?
I really enjoying this great lesson
Awesome! I appreciate that.
thanks a lot :) , it is a useful course
Glad to hear that!
Good best teaching way
Thanks
You are awesome.
Thanks
At 47 minutes, is forms = screens, also = input? and reports = Print, also = output?
Yeah, basically. In the old days, it was forms on the screen and reports on paper, and that's the analogy I still like to use, although you can still preview a report on the screen or send it as a PDF file. Basically, anything you would print would go into a report.
Gosh thanks so much I've definitely learnt a lot
Glad to hear it!
How to I get your Access 2003 training?
Where do i find the links that u have mentioned in the video sir
Richard Rost you're great.....
Awww... gee.... thanks. :)
Very useful
Glad you think so!
THANK YOU SIR
Most welcome
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.
this is great material
Thanks