It's been great to relearn Microsoft Access 2010 with you ! In my ICT days, I designed a database for consumables, as I was responsible for ordering, maintain correct stock level, not under or over, "sales" as in providing the the users with consumables.It was easy to queries and reports, say monthly cost per department. Database was far from perfect, but I had fun creating it, made my day easier. The "sales price" I never worked out, unfortunately. I used paper and pen, when handing out consumables, I used "the oldest price" from my list, and ticked one less :)
For the record, I love this class. The flow is easy; the lessons are designed for anyone to follow. I have used Access before, but I have never designed one. So, I am enjoying learning to design a database. Thank you.
i was watching one other course about Access on youtube , at first the course was going good and understood everything but at some moment the tutor went off on the relationships and IDs and two tables in the same time lol I was confused and still didnt understand why we even need more than one table, the explanation was more complcated than the subject itself, but man the moment I scrolled down I found your video , everything is well explained and I repeated some of the things I already learned but your teaching , experience and the real life examples you give made the past 8 hours fly . your biggest fan from Morocco much Much respect and I mean it .
After completed your beginner 1 class , I felt so blessed that now I really know much better now when creating database with Ms Access 2010..Thank you very,very much..May God dearly richly bless you for your tutorial class..
Excellent ! Brushing off my Access 2010 skills, it's been a long while. Super easy to follow along course, good pace. I'm aware 2010 version is old, but it's all I really need.
If you see something saying I hit the dislike button please ignore it (I caught it by accident) Your videos are brilliant! Very helpful and well delivered
Hello Richard, I've been watching tons of your videos and I appreciate the time and effort you put into teaching us Microsoft Access. Your video helped me so much that I am now one of your supporters. Now I builted my DataBase. Here's my problem, I have an order Table and Client Table, and a report. The report has an order number, the quantity from the order table, etc, and the client from the client Table. when I print the report it prints the Client number and not the name of the client. I would appreciate pointing me to the right video. Thanks, Stephan
I love your tutorials they are a brain opener. I have been looking for beginners lesson 3 full course but I have not been able to find it. Please help.
Hi Richard! I use Access from Microsoft 365, and I noticed that when I open up the forms in Form View, the boundary that you set is not there, so the whole page is light blue, unlike what you showed in the video that outside the form boundary is gray. Is there a setting I should change to achieve the look shown in the video, with form boundary showing in the Form View?
hello, my Access teacher, i have problem in the part of making the appointments button, i am using Access 2007, my problem in setting the wizard in the appointment button in matching the primary key of CustomerF to AppointmentF, in the column of CustomerF no items are shown, so my appointment button is just show the Appointment form what should I do?
I really can't picture what you're talking about without seeing it so why don't you post this on the forums on my website since you remember and include some screenshots so we can see what's going on there 599cd.com/AF
Yeah... I've been meaning to make a video about this. There are "no no bad" reserved words, and then there are "kinda meh" reserved words. Words like Date are "no no bad" words because Access will almost always think you mean the Date() function. Yes, Description is technically a reserved word, but it's a property, so you can get away with using it as a field name 99% of the time without issues.
Biggest fan from Sierra Leone-West Africa. You deserve reserved of our appreciation. Thumbs up
It's been great to relearn Microsoft Access 2010 with you ! In my ICT days, I designed a database for consumables, as I was responsible for ordering, maintain correct stock level, not under or over, "sales" as in providing the the users with consumables.It was easy to queries and reports, say monthly cost per department. Database was far from perfect, but I had fun creating it, made my day easier. The "sales price" I never worked out, unfortunately. I used paper and pen, when handing out consumables, I used "the oldest price" from my list, and ticked one less :)
Nice!
For the record, I love this class. The flow is easy; the lessons are designed for anyone to follow. I have used Access before, but I have never designed one. So, I am enjoying learning to design a database.
Thank you.
You're very welcome!
Thanks Mr. am grasping something really have passion in programing, hope will get there.
i was watching one other course about Access on youtube , at first the course was going good and understood everything
but at some moment the tutor went off on the relationships and IDs and two tables in the same time lol I was confused and still didnt understand why we even need more than one table, the explanation was more complcated than the subject itself, but man the moment I scrolled down I found your video , everything is well explained and I repeated some of the things I already learned but your teaching , experience and the real life examples you give made the past 8 hours fly .
your biggest fan from Morocco much Much respect and I mean it .
After completed your beginner 1 class , I felt so blessed that now I really know much better now when creating database with Ms Access 2010..Thank you very,very much..May God dearly richly bless you for your tutorial class..
You are most welcome
Excellent ! Brushing off my Access 2010 skills, it's been a long while. Super easy to follow along course, good pace. I'm aware 2010 version is old, but it's all I really need.
Glad it was helpful!
That's the version I've been using since it came out and it's bought and paid for many times over. No yearly fee
U made it simple man ur subscribers are well deserved
Thanks.
If you see something saying I hit the dislike button please ignore it (I caught it by accident)
Your videos are brilliant! Very helpful and well delivered
Glad you like them!
Thank you for your help. Your teaching is quite recommending. God bless.
Welcome
Now I can say "Hello World" using MS-Access. Thank you a lot, direct from Brasil.
You are a good teacher.
Thank you! 😃
Hello Richard, I've been watching tons of your videos and I appreciate the time and effort you put into teaching us Microsoft Access. Your video helped me so much that I am now one of your supporters. Now I builted my DataBase. Here's my problem, I have an order Table and Client Table, and a report. The report has an order number, the quantity from the order table, etc, and the client from the client Table. when I print the report it prints the Client number and not the name of the client. I would appreciate pointing me to the right video. Thanks, Stephan
Sounds like you just need to join them together in a query first. Have you watched my invoicing video? 599cd.com/Invoicing
Thank you. When you level 3 will be posted. I found it so helpful.
When Level 2 gets enough Likes
totally agree with u mate! im kind of a newbie to soft producing here, well tNice tutorials video helps a lot and gives mo motivation to create
Great to hear!
I love your tutorials they are a brain opener. I have been looking for beginners lesson 3 full course but I have not been able to find it. Please help.
599cd.com/ACB3
Hi Richard! I use Access from Microsoft 365, and I noticed that when I open up the forms in Form View, the boundary that you set is not there, so the whole page is light blue, unlike what you showed in the video that outside the form boundary is gray. Is there a setting I should change to achieve the look shown in the video, with form boundary showing in the Form View?
599cd.com/OverlappingWindows
hello, my Access teacher, i have problem in the part of making the appointments button, i am using Access 2007, my problem in setting the wizard in the appointment button in matching the primary key of CustomerF to AppointmentF, in the column of CustomerF no items are shown, so my appointment button is just show the Appointment form what should I do?
I really can't picture what you're talking about without seeing it so why don't you post this on the forums on my website since you remember and include some screenshots so we can see what's going on there 599cd.com/AF
@@599CD its now okay, i just done troubleshooting it, its on the version problem, now i am using office 365, thank you teacher
Thanks for tNice tutorials content. It was the first soft soft video I've seen that didn't assu I knew my way around all of the functions.
Welcome
Keep going you are amazing 😍 when will be the next video
Not sure yet
How do you add multiple customers ID on the second form without inputting each one multiple?
I don't understand what you mean
Great Stuff😊😊😊
Thank you
My new project is, a database for Microsoft Flightsimulator 2020, aircrafts, airports, sceneries, add-ons !
Sweet
Interesting although long video
It's the whole course in one video. People seem to prefer that over the individual lessons.
What's the best book for Access you can recommend ? I like Bibles, I'm just after something which covers everything, with screenshots and examples.
599cd.com/QQ
How do I create a Unique Identifier that is not an AutoNumber and make it my Primary Key?
599cd.com/QQ
How do you use 2 table interfaces at the same time? braking my brain !
Huh?
Using word description as a field name is not a good practice because Description is also Reserved Word....
Yeah... I've been meaning to make a video about this. There are "no no bad" reserved words, and then there are "kinda meh" reserved words. Words like Date are "no no bad" words because Access will almost always think you mean the Date() function. Yes, Description is technically a reserved word, but it's a property, so you can get away with using it as a field name 99% of the time without issues.
When u first used a phone in ur life it probably was complicated too.
No... pretty sure I got that right away. :)
too
Huh?