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 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
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
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 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.
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 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
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.
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!
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.
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 RUclips. 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.
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.
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 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?
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!!!!
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
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 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.
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 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.
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!!!
Sir, I have made a Access database. and i am using it from last one year, some days ago I save the same database for new year entry and make a small changes in my regular Entry Form. I changed a field. but from that time i getting a Error as " Enter Parameter Value" at the time of opening the form. I corrected it in all my table and Queries but the Error is still getting. so please give me some solution.
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.
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 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💕
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.
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.
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
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.
I checked the site to get ACCESS EXPERT COURSE and by what I saw, enrolling as a member would not give me access to the full course... I would still have to acquire one by one and the price is quite high... Wouldn't be better to have a package for each level we could acquire at all... such as US XXXX for the whole EXPERT PACKAGE and so on... Wouldn't it be a lot easier?
Membership does give you one free lesson per month. If you want them faster for that, you can purchase them. I used to have packages like that available, but everyone would always ask "can I get the bundle without Level 2 that I already bought?" So I'd have to un-package them. So now, my shopping cart just gives you a discount for buying multiple lessons... up to 50% off. THAT'S a lot easier. The more you buy, the bigger the discount. 599cd.com/order
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 RUclips 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.
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.
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 RUclips. I am from Afghanistan and we have internet problems here.
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. :-)
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.
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.. 😅
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.
Hi , could you please explain the maximum ms access db size in GB , users , Performance? Is it supposed in big applications? What are rules here? Thanks in advance for professional contents
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. :)😃
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.
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.
Our employee's have their own ID numbers, can I use those instead of your customer (or employee) ID? Our ID's are how we identify employee's in our other systems, which is what I would want to use for relationship purposes. Or do I need to use that particular field for tracking? Could I use their employee ID as the Primary Key?
You could add it as a secondary key, but I strongly recommend using Autonumbers for relationships inside your database. Hang on to those existing employee IDs if you want. 599cd.com/Autonumbers
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. :)
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.
Well... that's how I like it so... Meh! :) LOL It actually goes back to my days as a D&D player... wayyyyyy back to the 80s.... Beginner, Expert, Companion, Master, Immortal. So my idea was to go Beginner, Expert, Developer, Master... where Expert was non-programming stuff and Developer got into VBA. But then I decided to stick some macro stuff in the middle (because at the time MS had Web Apps in Access that used Macros, which are now gone)... so I needed a name. Advanced just fit. So... there ya go. It's all subjective anyways. And I've never liked the term "intermediate."
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.
It is broken down into smaller parts. I've got both available. Some people like a single 4-hour video. Others like the individual lessons. Search my channel or go to 599cd.com/ACB1
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.
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 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!
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.
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.
Anytime I try to run one of the Wizard features, I get the error message "The wizard is unable to create your report". I am on the computer assigned to me at work. Is it possible this feature is disabled?
@@599CD No, you don't need to do anything. I found out that I had to have my file listed with \ACCESS\DATABASE in it in order for it to work. I'm using company software, which we don't have control over (generally). My IT guys helped me with it. Easy-peasy!! Thanks
![NOSFERATU - Official Trailer [HD] - Only In Theaters December 25](http://i.ytimg.com/vi/nulvWqYUM8k/mqdefault.jpg)
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 like this guy, i have been searching for a teacher for Access for a long time.
The best course i have ever attended in my lifetime. Thank you
You're very welcome. Thank YOU for the kind words.
You are the best MS Access Expert and Guide in the World.
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 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.
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.
Very helpful! I enjoyed your 4-hour course and still continuing to the next course
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.
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
BEST TEACHER, IT'S AMAZING LEARNING AND HAVING FUN
Thanks
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.
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 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!
THANK YOU THANK YOU THANK YOU So helpful!
Any time!
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
thanks a lot :) , it is a useful course
Glad to hear that!
So I created a 5x3 sized form in design then when viewed it fills the window. Why is it not showing it as 5x3?
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.
Very useful
Glad you think so!
Thanks for such great video sir
Most welcome
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!
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
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 RUclips. 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.
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
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.
We only have Access 2000. What's the best place to get a really cheap version of Access 2019?
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?
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
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
Thank you. It helps me a lot
welcome
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. :)
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
Awesome content. Everything well explained exhaustively. I'd like the next Level 2 series. Looking forward to continue with the learning
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!
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. :)
2024 just started learning access. This is a gem!!!
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 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.
How to I get your Access 2003 training?
This video was sooo good. I went from knowing nothing to feeling like I can actually use access well.
Sweet
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!!!
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. :)
Where do i find the links that u have mentioned in the video sir
Sir, I have made a Access database. and i am using it from last one year, some days ago I save the same database for new year entry and make a small changes in my regular Entry Form. I changed a field. but from that time i getting a Error as " Enter Parameter Value" at the time of opening the form. I corrected it in all my table and Queries but the Error is still getting. so please give me some solution.
599cd.com/EPV - something's missing or spelled wrong
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.
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
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 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
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
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.
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
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
I checked the site to get ACCESS EXPERT COURSE and by what I saw, enrolling as a member would not give me access to the full course... I would still have to acquire one by one and the price is quite high... Wouldn't be better to have a package for each level we could acquire at all... such as US XXXX for the whole EXPERT PACKAGE and so on... Wouldn't it be a lot easier?
Membership does give you one free lesson per month. If you want them faster for that, you can purchase them. I used to have packages like that available, but everyone would always ask "can I get the bundle without Level 2 that I already bought?" So I'd have to un-package them. So now, my shopping cart just gives you a discount for buying multiple lessons... up to 50% off. THAT'S a lot easier. The more you buy, the bigger the discount. 599cd.com/order
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 RUclips 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
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
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 RUclips.
I am from Afghanistan and we have internet problems here.
Please allow me to download your videos to storage, 😢
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
amazing teacher, thanks a lot for such a beautiful video
Good day Sir. Please can I get the TUTORIAL LESSON ON HOW TO USE MICROSOFT ACCESS . How much does it cost or what package can I join to enjoy this.
You're in the right place. Finish Beginner 1, then when you're ready for Beginner 2, it's just $1 here: 599cd.com/ACB2
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
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!!!!!
he makes it fun and easy to lean
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.
Hi , could you please explain the maximum ms access db size in GB , users , Performance? Is it supposed in big applications? What are rules here? Thanks in advance for professional contents
Benefits of Access: 599cd.com/Benefits
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? :)
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.
Can u upload vba access beginner couching vedio
599cd.com/VBA
Thanks. Good stuff but too slow with lots of unnecessary talking and fun. Best teaching is 30 minutes video with direct demonstration on how to it
Plenty of other tutorials on RUclips for you to watch if you don't like mine.
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. :)
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. :)
Would you please make a video of student database just like Microsoft student database template.Its a humble request to you from INDIA.
I've got something like this on my "to do" list. Hang in there.
Our employee's have their own ID numbers, can I use those instead of your customer (or employee) ID? Our ID's are how we identify employee's in our other systems, which is what I would want to use for relationship purposes. Or do I need to use that particular field for tracking? Could I use their employee ID as the Primary Key?
You could add it as a secondary key, but I strongly recommend using Autonumbers for relationships inside your database. Hang on to those existing employee IDs if you want. 599cd.com/Autonumbers
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. :)
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!
It is weird positioning expert a lower level then advanced.
More appropriate would be beginner, intermediate, advanced, expert
Well... that's how I like it so... Meh! :) LOL
It actually goes back to my days as a D&D player... wayyyyyy back to the 80s.... Beginner, Expert, Companion, Master, Immortal. So my idea was to go Beginner, Expert, Developer, Master... where Expert was non-programming stuff and Developer got into VBA. But then I decided to stick some macro stuff in the middle (because at the time MS had Web Apps in Access that used Macros, which are now gone)... so I needed a name. Advanced just fit. So... there ya go.
It's all subjective anyways. And I've never liked the term "intermediate."
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
Why didn't you break this forever video broken down into smaller parts?
It is broken down into smaller parts. I've got both available. Some people like a single 4-hour video. Others like the individual lessons. Search my channel or go to 599cd.com/ACB1
Can I just say that I love the shoutout to the Star Trek Next Generation characters! Awesome.
Sweeeeeet
Excellent Teacher, You won a new subscription. ❤️ From Pakistan
Sweet
i cant find the combo box video link 🙁
599cd.com/Relational
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
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 need 2010 copy
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
Take a shot every time he mentions he’s been teaching Access 30 years😂
You'd get pretty drunk by the end of the class. :)
I would like level 2, please
Level 2 is online. 599cd.com/ACB2
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 RUclips. Go to 599cd.com/ACB2
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. :)
Can you give me the link please
Link for what?
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 clear voice!! Very good teaching method. Thank you so much!!!
welcome
Ass ending 😂
your customer names are THE BEST
Good teaching, very interesting and comprehensive. Thanks alot!
Thanks
Thank you for this video series. Can you send me the link to the next video? 👍
599cd.com/ACB2
FANTASTIC!!!! Please make the next video available. TY😊
Thank you! Will do!
Anytime I try to run one of the Wizard features, I get the error message "The wizard is unable to create your report". I am on the computer assigned to me at work. Is it possible this feature is disabled?
It's possible. The wizards could be corrupted. I'd reinstall Office. See 599cd.com/Trouble
@@599CD No, you don't need to do anything. I found out that I had to have my file listed with \ACCESS\DATABASE in it in order for it to work. I'm using company software, which we don't have control over (generally). My IT guys helped me with it. Easy-peasy!! Thanks
Can an access database be used to automate tasks, like send confirmation and reminder emails, and notify staff of updates to appointments?
Yes, absolutely. 599cd.com/Timer