Thank you for all the time you spent to prepare and give a clear 3 hours Access tutorial that covers exactly the need to start work with Access. Wonderful work and very helpful 😊👍
A very comprehensive tutorial and it's giving me a firm understanding of how things work. It's one thing to know how to set up a database but to understand what's going on is far more important. Thank you.
A TREMENDOUS base to learn how to use this program! I see when you get to larger databases how Access is SO much better to use than Excel! THANK YOU for starting this off! Working on the skills I learned here before I jump in to the next lesson!
Excellent training. Step by step. It has been many years since I programmed in Access, and things have changed tons in the software. So this was extremely helpful to refresh me. Thank you
Thanks so much for this lesson. Took up Access lesson some years back and couldn't get a thing even with an instructor handling me 1-on-1. This video has really been immensely helpful, now that I need to incorporate Access into my personal work.
Hello Sir, Thanks for the way you have increased my knowledge of Ms. Excel and Access; God bless you. I am Cephus Johann Krangar, and I write from Monrovia, Liberia, West Africa. I strongly believe that your teachings (tone, pace, accent and superiority over the lessons) are all I need to become a computer genius. Please, could you as well provide lessons on Quickbooks? I look forward to hearing from you soon. Best Regards, Cephus
@@599CD Thank you for your response.... I would like to bring to your kind attention a problem l faced...I today watched at a stretch your 3+ hour vedio of Access for beginners. It solved my years long desire of learning Access. But U were telling that, after the biginners level, there would be an Expert level vedio which l unfortunately could not find even after searching several times amongst the vedios u have uploaded.... Could you pls send the quick link for those... Expert level Advance level... Developer level.... Thank you... With a lot of love from India.... Thank you....
Very clear explanation. I didn't have a clue of MS Access, but your lessons made it so interesting to me, that I take it so seriously and follow your classes
@@599CD I have asked my American friend if she can pay the 1 dollar for the level 2 on behalf of me as I am in India. She doesn't know how she can do it. Can you please tell me where she can pay it
Excellent tutorials I notice in one of your tutorials. Foreign Key automatically appears on new record even before you enter data. Which video to you cover that?
Very helpful! I already started watching (and will continue soon this coming vacation) the chunked vids. This makes the lesson easier to search on. Thanks a bunch! Bless you, Sir! More power andots of love, from here in the Philippines!
Great Class, Thank you. I want to create a CRM (Contact Relationship Management) Database and then add on campaigns for my Business. I am a Realtor, Can you help me learn that too? Look forward to hearing from you,Gail
Richard, I love your work and dedication. Thank you, Sir. Please keep up the excellent work. One thing...the resolution too poor here. Literally gives me a headache when I blow up it to watch on my big screen. Can you please reupload at a minimum of 720p? Preferable up to 4K? Thank you.
Thank you for creating this video sir ^_^ the explanations are very clear (easy to understand). I'm thinking of joining your class soon ^_^ Thank you so much.
Good evening Sir. Great video instruction. I'm looking to build a Access database that can keep track of our projects at work and be able to log the time spent on each project by techs using the clock in and out. Could you suggest any of your videos that may help me build that? I have built the timeclock but just cant figure out how to integrate it. Thanks
Brilliant video and teaching!! This has probably been asked.. Have you ever built a form with queries? Is it better to write forms directly from tables..or.. First build queries and then build your forms. Why im asking is because ..in your other videos you say "you don't want anyone to touch your tables" so is it safe to create your forms with tables directly..or do i first create queries..and the create forms qith the queries? Much appreciated!!
You can build a form off of a query if you want, but your forms should always be based off one a SINGLE TABLE. If you need to bring in other information for display purposes, that's fine. But don't try to join two tables together and then be able to EDIT records from both of those tables in the same form. Use a form with a subform. One of my members recently asked a similar question. I've got a video coming up on this soon.
Speaking of database I am nor day nor beast, I am nor good nor evil, I am Earth and I am nature, I am me. It took me years and years of experience and self realization until I have found out who I am or partly of things that I am. You can encode that to your database.
I love this tutorial, but he funniest thing is that I've been living in CO since '95, but grew up in WNY, and I know all those addresses you use quite well! LOL
Nope. Sorry. I never really got into all that database theory stuff. My knowledge of Access is all practical - from building real-world databases for companies over the past 30 years. Not much need for ER diagrams there. Maybe one of these days I'll read a "real" book on database theory. :)
Very informative and well presented. I am also equally impressed that one of your customers - like me - is a Big Rush Fan😁. Carry on with these superb tutorials please, they are great.
Hi, when in 'table' layout, creating record rows/data input, is it possible for Access 10 to detect and auto type matching record data that has been previously inputted? Example, previously inputted 'United States' would auto type (into row cell) from the first typed letter 'U' (and additional letters [ni..] if needed for detection against similar words) for convenience and speed of data input? If this can be done, how is it possible please??
Not easily, no. You could use a combo box, but then you have to pre-populate the values. You could use an AfterUpdate event to add new items to that combo box table, but then we're back to what I originally said: not easily. LOL
Hi Richard! Is this tutorial applicable for the windows 10 access 2020 version ? You explain really well, I’m a complete beginner... I enjoyed watching the tutorial and learnt a lot already! Thank you so much 😊
Most of my newer lessons are valid from Access 2007 until 2019 (there is no 2020 version). There have been some changes, but most of them aren't geared towards beginners, so you'll be just fine.
Hi. Can you help me please. I need to create a Course name and its Primary key in a row but I also need to insert MULTIPLE Subjects into this row. How to do that????
Hi i want to make a database in the information of students and when i print a report it will automatically print whatever form i print with a different name please help me .
Dear Mr Richard, I have an access data base split in two parts back end and front end, i want to run my front end file from any computer or mobile via internet browser, I have study some ideas on net, for example share point or publish a data base but can not achieve success, can you help me by create a video about this. Regards, Muhammad Sarfraz from Pakistan.
i am no good for now in access, but i am learning , can anyone help me how to show my members info with their types of loan and loan amount. thank you.
Hope that, after you go to heaven, all your premium videos will be available in youtube (free); wishing your journey to heaven early. Ms access is wonderful for single-user-personal-use; no language needs to be learnt, for tiny projects.
To be honest. The way you explain is good but after every sentence you say I will cover or I will explain this in the future 🙄🙄🙄🙄 . People are telling that do not put today's task or work to tomorrow.!!!!! Really not good !!!!
I'm letting people know that something they might be wondering about WILL be covered in a future lesson. I can't cover everything at once. Space and time do not work that way. You can't cover ALL of Calculus in one hour-long session, right? This is a BEGINNER tutorial. See this: 599cd.com/FutureLesson
I really like this tutorial. No advance stuff, no talking too much, right amount of humor and very detailed teaching. Thank you!
Welcome
The clearest access tutorial for me. Though it takes 3 hours, I was able to absorb most of it in one sitting/setting. Thank you
Glad it helped! I do have a shorter version that doesn't go into as much detail, but the 3-hour one is my favorite.
@@599CD Sir its really a classic access vedio......With a lot of love from India...
@@599CD I ok lng it to the bank 🏧🏧🏧😅🏧🏧🏧😅
Thank you for all the time you spent to prepare and give a clear 3 hours Access tutorial that covers exactly the need to start work with Access. Wonderful work and very helpful 😊👍
You're very welcome!
A very comprehensive tutorial and it's giving me a firm understanding of how things work. It's one thing to know how to set up a database but to understand what's going on is far more important. Thank you.
You're very welcome!
A TREMENDOUS base to learn how to use this program! I see when you get to larger databases how Access is SO much better to use than Excel!
THANK YOU for starting this off! Working on the skills I learned here before I jump in to the next lesson!
Glad it was helpful!
Excellent training. Step by step. It has been many years since I programmed in Access, and things have changed tons in the software. So this was extremely helpful to refresh me. Thank you
welcome
Thanks so much for this lesson. Took up Access lesson some years back and couldn't get a thing even with an instructor handling me 1-on-1.
This video has really been immensely helpful, now that I need to incorporate Access into my personal work.
You're very welcome!
Very clear instruction Allows for those who have not used the program in a while relearn the Barny basics.
Glad you like.
Hello Sir,
Thanks for the way you have increased my knowledge of Ms. Excel and Access; God bless you. I am Cephus Johann Krangar, and I write from Monrovia, Liberia, West Africa. I strongly believe that your teachings (tone, pace, accent and superiority over the lessons) are all I need to become a computer genius. Please, could you as well provide lessons on Quickbooks?
I look forward to hearing from you soon.
Best Regards,
Cephus
Thanks for the compliments. I taught a QuickBooks class way back in 2002. Can't say that I have plans to do another one. 599cd.com/QB101
The best Access tutorial I have ever had.....I reserve my gratitude to you Sir.....With a lot of love from Kerala, India.....
You are most welcome
@@599CD Thank you for your response.... I would like to bring to your kind attention a problem l faced...I today watched at a stretch your 3+ hour vedio of Access for beginners. It solved my years long desire of learning Access. But U were telling that, after the biginners level, there would be an Expert level vedio which l unfortunately could not find even after searching several times amongst the vedios u have uploaded....
Could you pls send the quick link for those...
Expert level
Advance level...
Developer level....
Thank you...
With a lot of love from India....
Thank you....
El mejor Turorial de Access que he visto. Gracias. Bien planeado, directo, facil de digerir
Muchas gracias. Agradezco las amables palabras.
Very clear explanation. I didn't have a clue of MS Access, but your lessons made it so interesting to me, that I take it so seriously and follow your classes
Awesome.
@@599CD I have asked my American friend if she can pay the 1 dollar for the level 2 on behalf of me as I am in India. She doesn't know how she can do it. Can you please tell me where she can pay it
This has been the best Access Tutorial ever and I'm planning to take all of your remaining courses. Thanks and can them coming
Glad you like them!
Rick is a very good tutor 😀 Honestly I would say you are brilliant in explaining a beginner.I am very happy.Thank you Rick 😀
You are very welcome
This is the most helpful and clear tutorial for access I have ever encountered. Thank you so much.
You're very welcome!
Very helpful, thank you. I have a problem with one of the reports, how do i add the file name on the printed report?
The file name of what? The Access ACCDB file?
Thank you for all that you do, sir. You are very articulate and explain everything with great details. Your work is greatly appreciated!
I appreciate that!
Excellent tutorials
I notice in one of your tutorials. Foreign Key automatically appears on new record even before you enter data.
Which video to you cover that?
599cd.com/Relationships
Very helpful! I already started watching (and will continue soon this coming vacation) the chunked vids.
This makes the lesson easier to search on. Thanks a bunch! Bless you, Sir! More power andots of love, from here in the Philippines!
Glad it was helpful!
This is awesome. Thank you for putting this together.
My pleasure!
Great Class, Thank you. I want to create a CRM (Contact Relationship Management) Database and then add on campaigns for my Business. I am a Realtor, Can you help me learn that too? Look forward to hearing from you,Gail
Sure... I'd recommend continuing on with Level 2... 599cd.com/ACB2
Richard, I love your work and dedication. Thank you, Sir. Please keep up the excellent work. One thing...the resolution too poor here. Literally gives me a headache when I blow up it to watch on my big screen. Can you please reupload at a minimum of 720p? Preferable up to 4K? Thank you.
Yeah, I feel ya. This video is about 10 years old. All of my new stuff is in 720p. You can find the updated version of this here: 599cd.com/ACB1
Thank you for creating this video sir ^_^ the explanations are very clear (easy to understand). I'm thinking of joining your class soon ^_^ Thank you so much.
Sweet. You're very welcome.
Good evening Sir. Great video instruction. I'm looking to build a Access database that can keep track of our projects at work and be able to log the time spent on each project by techs using the clock in and out. Could you suggest any of your videos that may help me build that? I have built the timeclock but just cant figure out how to integrate it. Thanks
599cd.com/Timesheet
599cd.com/TimeClock
Brilliant video and teaching!! This has probably been asked..
Have you ever built a form with queries?
Is it better to write forms directly from tables..or.. First build queries and then build your forms.
Why im asking is because ..in your other videos you say "you don't want anyone to touch your tables" so is it safe to create your forms with tables directly..or do i first create queries..and the create forms qith the queries?
Much appreciated!!
You can build a form off of a query if you want, but your forms should always be based off one a SINGLE TABLE. If you need to bring in other information for display purposes, that's fine. But don't try to join two tables together and then be able to EDIT records from both of those tables in the same form. Use a form with a subform. One of my members recently asked a similar question. I've got a video coming up on this soon.
Wow that was REALLY Really really GOOD
Glad you enjoyed! :)
Thanks for this tutorial,i love it.
You're welcome 😊
Speaking of database I am nor day nor beast, I am nor good nor evil, I am Earth and I am nature, I am me. It took me years and years of experience and self realization until I have found out who I am or partly of things that I am. You can encode that to your database.
Uhm... OK... ???
Hey Rich ! Is it possible to create a hash from an input string and store it in a table. Thanks
Sure, I suppose. :)
I love this tutorial, but he funniest thing is that I've been living in CO since '95, but grew up in WNY, and I know all those addresses you use quite well! LOL
Haha. Yep. I've been living in South Florida since 2013, so I can definitely tell all the tutorials I recorded BEFORE and AFTER that point. :)
Really appreciate your effort
Thanks a lot
Hi, do you have a tutorial for making an ER diagram of a database made in MS access?
Nope. Sorry. I never really got into all that database theory stuff. My knowledge of Access is all practical - from building real-world databases for companies over the past 30 years. Not much need for ER diagrams there. Maybe one of these days I'll read a "real" book on database theory. :)
Very informative and well presented. I am also equally impressed that one of your customers - like me - is a Big Rush Fan😁. Carry on with these superb tutorials please, they are great.
I've been to every Rush concert since Roll The Bones. Love them!
The best...... may GOD bless u
Thanks
Excellent tutorial.
Many thanks!
Thank you.
You're welcome!
Great training video
Thank you!
Thank you so much
Welcome
You are the G.O.A.T
Thanks. :)
Thank You very much, it is real useful and easy to follow
You are welcome!
Hi, when in 'table' layout, creating record rows/data input, is it possible for Access 10 to detect and auto type matching record data that has been previously inputted? Example, previously inputted 'United States' would auto type (into row cell) from the first typed letter 'U' (and additional letters [ni..] if needed for detection against similar words) for convenience and speed of data input?
If this can be done, how is it possible please??
Not easily, no. You could use a combo box, but then you have to pre-populate the values. You could use an AfterUpdate event to add new items to that combo box table, but then we're back to what I originally said: not easily. LOL
Tq, its helpful.
Next, would you make some tutorial of connecting access database with barcode scanner, many thanks
Way ahead of you: 599cd.com/Barcode
Dear Sir, it helps me a lots thank you and please show me purchase sales plus and minus store management.
No idea what you mean.
Dear Sir, I want to know how to make sum for receiving, issuing and the net balance in stock. please send me the link kindly
599cd.com/Inventory
@@599CD Thank you sir May God bless you.
Hi Richard! Is this tutorial applicable for the windows 10 access 2020 version ? You explain really well, I’m a complete beginner... I enjoyed watching the tutorial and learnt a lot already! Thank you so much 😊
Most of my newer lessons are valid from Access 2007 until 2019 (there is no 2020 version). There have been some changes, but most of them aren't geared towards beginners, so you'll be just fine.
Thank you Richard 👍😊
Hi. Can you help me please. I need to create a Course name and its Primary key in a row but I also need to insert MULTIPLE Subjects into this row. How to do that????
You'll need a separate related table. 599cd.com/Relationships
Thank you very much Sir ,learned alot from this video really appreciate.😊
You are most welcome
Very helpful. Thankyou.
You're welcome!
Hi i want to make a database in the information of students and when i print a report it will automatically print whatever form i print with a different name please help me .
What do you mean by "print whatever form I print?" I need more specifics. Post them here: 599cd.com/AF
Good job
Thanks
Where can i find the bigginer level 3 because I completely watched this video
599cd.com/ACB3
@@599CD Thank you sir
Very helpful
Glad you think so!
very clear and helpful for me as a beginner. hi sir may i ask a free copy of microsoft access 2010. thankyou & God bless
You mean the software itself? I don't provide that. Go to microsoft.com
If you're looking for my older tutorial that covers 2007, 2010, and 2013, go here: 599cd.com/AC2013B1
Dear Mr Richard, I have an access data base split in two parts back end and front end, i want to run my front end file from any computer or mobile via internet browser, I have study some ideas on net, for example share point or publish a data base but can not achieve success, can you help me by create a video about this. Regards, Muhammad Sarfraz from Pakistan.
See 599cd.com/AccessOnline
Good day, could I have questions that I must face when I write exams: for Access
I'm sure you could.
Can I change the font size to 11 in the zoom box permanently?
When you change the font settings in the Zoom box they should remain permanent.
How can we get DISTINCT COUNT in MS Access thru query? Can you help me?
599cd.com/Aggregate
table .. same in excel n access
pivot/query ... same in excel n access👍
A CROSSTAB query is like a Pivot in Excel. 599cd.com/Crosstab
thnx
crosstab query 👍
i am no good for now in access, but i am learning , can anyone help me how to show my members info with their types of loan and loan amount. thank you.
599cd.com/Amort
2021 sept from Uganda but I can't manage to sit 3 hrs so am learning in phases ,but thanx alot
That's the beauty of video... watch as much as you can... pause... get dinner... come back later. :)
Thank you, please help How to autoinsert new field in access table based on criteria?
Append Query? I don't know what you mean. 599cd.com/Append
HOW to bring ICON onthe Status Bar?
You can change the application icon in the database settings.
how do i download the video please?
599cd.com/ACB1L - you'll find a download link
Dear sir, I would like to learn by you and I’m a beginner how can I join?
Click the JOIN button or go to 599cd.com/TH
I have messed something up in our database - can anyone help?
I don't provide consulting, but you can try: 599cd.com/AccessDev
I whant to see this video in hindi language. So what should I do. Can you help me sir.
Please 🙏
Well, I have no time nor desire to learn Hindi, so you'll have to find someone to interpret it for you. Good luck. :)
u should have used forms to fill data in tables ... lesson 6 .
i guess ..
I'm the developer. It's OK if I work with the tables. Your END USERS should stick to forms.
@@599CD ... realised that , a few seconds later in d vid 😅
Hope that, after you go to heaven, all your premium videos will be available in youtube (free); wishing your journey to heaven early. Ms access is wonderful for single-user-personal-use; no language needs to be learnt, for tiny projects.
Did you just hope that I die soon? Man, that's harsh.
kristans weekly yearly bday 10th bashhh
LOL
Access DB Beginner
Welcome
To be honest. The way you explain is good but after every sentence you say I will cover or I will explain this in the future 🙄🙄🙄🙄 . People are telling that do not put today's task or work to tomorrow.!!!!! Really not good !!!!
I'm letting people know that something they might be wondering about WILL be covered in a future lesson. I can't cover everything at once. Space and time do not work that way. You can't cover ALL of Calculus in one hour-long session, right? This is a BEGINNER tutorial. See this: 599cd.com/FutureLesson