This guy is a MASTER teacher. Very clear. No stumbling. No mumbling. Covers everything. Clearly. Guy knows his stuff inside out. Most enjoyable tutorial for computer anything on TH-cam.
I cannot tell you how thankful I am that you have these out here. I was struggling to the point of tears in my database management class. Once I got through these tutorials, I found Access so simple that I wondered why I had been so afraid of it. It takes a lot of data entry, but it really is simple to use.
Thank you. I have watch this series from beginning to end and started over for a second time. YOUR information above all others I have tried to watch is the absolute best because when you say for ABSOLUTE BEGINNERS -- you not only mean it but you are able to teach it as such and that makes your series, in my opinion, heads above all others. What I am trying to do is learn this . amongst a great many other things, so I can create a DATA BASED -APP. I didnt know how to code until a couple of months ago and started to put my wireframes into code and realized I needed to create a data base system first. I have a ways to go before I will be done with everything but I appreciate not having to waste my time with your series because your information is SPOT ON and -NOT- a waste of time like the PLETHORA of other videos I tried to endure and understand. I wish you had a APP development course you could create. ROCK ON. W. James Rapp THE LAZY R
Thanks. I appreciate the kind words. Make sure you watch the updated 2021 version of this course if you're using the latest version of Access: 599cd.com/ACB1. Yeah, I haven't done much as far as app development goes. Played a little bit with Android, but it's just not my jam. Maybe I'll pick it up as a hobby one day... :)
Salut you sir you are a true legand i seen 8 videos of other persons to learn access but not a single idea i did got you are the one that i got everything from your videos thanks for that
This is a good refresher, I have been using an older version and its like getting back to the gym. One thing with this lesson, when you deal with users who may think they know database you have to be careful whenever you use the word delete... in design view on a query, when you delete a column, make sure you emphasize the data is not deleted, you state later that query is not real data, you have to let "know it all type zealots" real time, deleting a column in design view does not delete the data. I have had several bad experiences with impatient users who want the power of Access to fast.
I'm currently taking Access in College and the book I had to buy for over $100 wasn't teaching the concepts you already have. Knowledge and tips from someone who has obviously used this program, on what works best and what doesn't is invaluable. This system should be used in schools instead of making students buy overpriced books that don't. I'm going to look into taking more classes from you.
absolutely agreed with you Shelbyie has happened to me too but my professor said to continue to understand used youtube they don't care how much you spend in the book I go through to buy the book in cheap price in Amazon
Thanks for the compliments. I actually had one student tell me that her college instructor told them NOT to go on TH-cam and watch videos from people who "didn't know what they're doing." LOL. Excuse me? I've got almost 30 years experience with Access. You've taught 2 semesters in community college. Right.....
I have just started learning Access. This is an excellent course. It explains everything so clearly. I will be going to your Expert series and looking forward to it. Thank you for such a well done course.
All your class has a simple languange and it very full of details and great information. I´m watching all of them to learn how to use access in my business. Thanks for sharing yout knowlodge with us and congratulations! I´ve never looked information about access in portuguese like your class. so Thanks!
@@599CD my knowledge base has seriously grown because of you over the course of the last 7 years. Today I can do some pretty cool things with MS access because of you. Currently I'm creating an Inventory database that goes out to the web (MS EDGE) and grabs product data using a Python script and inserts the collected data into an access database via an SQL Insert string/command. I've Been working hard on this project for last 6 months but am still far from complete. The trick to my python code was to make my code flexible enough to pull data from any website and then update the data in my database thru use of some global functions I created.
Amazing, just amazing, I was struggling with this stuff in my class(I had a horrible, careless teacher), but watching your tutorials it's just a walk in a park.Thanks again for your help sir!!!
Thank you soo much for your lessons. I have a job interview for a Data Analyst position and there will be a basic access test. This was a great refresher as I haven't used it in MANY years!
I picked up "Sams Teach Yourself SQL in 10 Minutes", but couldn't get past the first chapter, as I have never used any database program before, and their description of how to use MS Access didn't correspond to what I saw on my screen. So off to search Google--and everything the book assumed I already knew is spelled out right here! I will definitely be back! Thank you so much for developing thee tutorials!
Thank you - just learn more through the query. But I did at the beginning entered the HomeAdress differently then your table. I put all the homeaddress in the same field. I could have separate them but for me for this purpose of my database it work better if I have the address in one cell. I don't have to select the different state. However, I did include yes or no in one of the field and this is where the query help me to find out who I need to mail to.
It seems pretty crude that you have to move fields in the query so you can order the sorts. In excel you can designate first, second, third columns for sorting. Do you have to move the fields after you run the sort query to get them to display FirstName LastName if the boss wants it that way?
Hello Sir, In my university i have been taught to write all the first name with short text in note pad rather than in table design the one you have taught...is that also fine doing in table design.. Thanks
You mean like the link that's on the thumbnail picture for the video... or at the end of the video on the closing screens... or the clickable links in the description below the video? Those links?
there is a lesson where you explain how to use query or table data to automatic fill info into some other documents? for example: I have a privacy form that customer have to sign, can i use a query to generate them in ms word? ty
You want to automatically populate the customer's data in a report? Just create the report and based it on the customer table. Or make a privacy form table if you want to store that information as well (date signed, etc.) and then create a query based on both tables, and use that for the report.
Here is what I need to do, which part of the classs do I need to view to be able to do it. I am making a volunteer list. Each volunteer volunteers on different days and times. I would like to be able to run a querry where I can see each day separatly and who works at what time on this day.
+Victoria Richter I would use a second table for this. In the 2nd table you can track each volunteer's schedule. I cover multi-table relationships starting with my EXPERT series, which is on my web site. 599cd.com
Hello , I have question : I am creating a Query, and I precised each client if he is a "M" or "Mlle" or "Mme". How can i count how many M's ; Mme's and Mlle's i have ? Thank you !
salam , you explain things weel , would it be poosible for you to teach courses like Human resources , management , secretary and ticketing course please ? Thank you
Hello, I have to make a table, 2 queries, and a report for a class of mine and I'm running into difficulties. I made my initial table and it came out fine but when I need to make my first query, which needs to only have the data for male clients in a certain state, I can't seem to get the query to work. I can however get it t work when i make a separate table with only the male clients but I will have points removed for doing so. I also can't get my report to auto-fill the data from my 2nd query that has only clients from a certain city,state. Please help if possible.
I signed up For the 29.99 membership but there are no details how to access the discounts. It says that my Questions will bounce to the top. We will see.
Hi Teri. Like the Membership instructions say, you have to CONTACT ME so I know you exist. TH-cam gives me NO info on you except your username and memberships level. Email me at amicron@gmail.com so I can set you up an account on my web site.
So Ive got a bunch f different queries set up but for one particular query it always asks to enter parameter value. Does anyone know what to do in this case?
In a query, I need to combine data from multiple rows into a single field, such as: Doc1 Part1 Ship1 Doc1 Part1 Ship2 Doc1 Part2 Ship1 Doc1 Part2 Ship2 Doc2 Part1 Ship1 Doc2 Part1 Ship2 Desired results: Doc1 Part1 Ship1, Ship2 Doc1 Part2 Ship1, Ship2 Doc2 Part1 Ship1, Ship2 Any ideas on how to do this? I'm not well versed at all in the use of VBA, but suspect that I will have to use VBA code for this. Any help will be appreciated.
You did not give me enough information to answer your question. Please be more specific. Also, I get a ton of questions every day, and I don't have time to answer them all here on TH-cam. Feel free to submit your question on my website at: 599cd.com/AskYT
+أحمد سارحان This is covered in part I I think it might be the 8th lesson. With the query you can save the search which is different from the sort that once the program is closed the search is lost.
![ILLSLICK - WINTER IS COMING [Official Video]](http://i.ytimg.com/vi/dwTMeM1zIhQ/mqdefault.jpg)
This guy is a MASTER teacher. Very clear. No stumbling. No mumbling. Covers everything. Clearly. Guy knows his stuff inside out. Most enjoyable tutorial for computer anything on TH-cam.
Thank you very much
I appreciate the kind words. :)
I cannot tell you how thankful I am that you have these out here. I was struggling to the point of tears in my database management class. Once I got through these tutorials, I found Access so simple that I wondered why I had been so afraid of it. It takes a lot of data entry, but it really is simple to use.
My pleasure
i like the way this guy teaches. That is a mark of a good teacher
Thank you. I have watch this series from beginning to end and started over for a second time. YOUR information above all others I have tried to watch is the absolute best because when you say for ABSOLUTE BEGINNERS -- you not only mean it but you are able to teach it as such and that makes your series, in my opinion, heads above all others.
What I am trying to do is learn this . amongst a great many other things, so I can create a DATA BASED -APP. I didnt know how to code until a couple of months ago and started to put my wireframes into code and realized I needed to create a data base system first. I have a ways to go before I will be done with everything but I appreciate not having to waste my time with your series because your information is SPOT ON and -NOT- a waste of time like the PLETHORA of other videos I tried to endure and understand.
I wish you had a APP development course you could create.
ROCK ON.
W. James Rapp
THE LAZY R
Thanks. I appreciate the kind words. Make sure you watch the updated 2021 version of this course if you're using the latest version of Access: 599cd.com/ACB1. Yeah, I haven't done much as far as app development goes. Played a little bit with Android, but it's just not my jam. Maybe I'll pick it up as a hobby one day... :)
Salut you sir you are a true legand i seen 8 videos of other persons to learn access but not a single idea i did got you are the one that i got everything from your videos thanks for that
Thank you. I appreciate the compliment! I'm glad you enjoyed.
This is a good refresher, I have been using an older version and its like getting back to the gym. One thing with this lesson, when you deal with users who may think they know database you have to be careful whenever you use the word delete... in design view on a query, when you delete a column, make sure you emphasize the data is not deleted, you state later that query is not real data, you have to let "know it all type zealots" real time, deleting a column in design view does not delete the data. I have had several bad experiences with impatient users who want the power of Access to fast.
Excellent observation. Thank you for sharing.
I'm currently taking Access in College and the book I had to buy for over $100 wasn't teaching the concepts you already have. Knowledge and tips from someone who has obviously used this program, on what works best and what doesn't is invaluable. This system should be used in schools instead of making students buy overpriced books that don't. I'm going to look into taking more classes from you.
I totally agree with this statement. (y)
absolutely agreed with you Shelbyie has happened to me too but my professor said to continue to understand used youtube they don't care how much you spend in the book I go through to buy the book in cheap price in Amazon
Thanks for the compliments. I actually had one student tell me that her college instructor told them NOT to go on TH-cam and watch videos from people who "didn't know what they're doing." LOL. Excuse me? I've got almost 30 years experience with Access. You've taught 2 semesters in community college. Right.....
This corse is so easy to follow. And was made for a beginner like me! Richard is WONDERFUL!!
Thanks!
I have just started learning Access. This is an excellent course. It explains everything so clearly. I will be going to your Expert series and looking forward to it. Thank you for such a well done course.
My pleasure
All your class has a simple languange and it very full of details and great information.
I´m watching all of them to learn how to use access in my business.
Thanks for sharing yout knowlodge with us and congratulations! I´ve never looked information about access in portuguese like your class.
so Thanks!
My pleasure
Honestly the best tutorial I have seen...So well presented, good pace and covers everything in a simple way. Fantastic
Thank you. I appreciate that.
After watching these tutorials I don't feel so scared of using access anymore. I can feel my stress wither away when I watch theses videos.
+Nathaniel Tyler so do I
Awww thanks
@@599CD my knowledge base has seriously grown because of you over the course of the last 7 years. Today I can do some pretty cool things with MS access because of you.
Currently I'm creating an Inventory database that goes out to the web (MS EDGE) and grabs product data using a Python script and inserts the collected data into an access database via an SQL Insert string/command. I've Been working hard on this project for last 6 months but am still far from complete. The trick to my python code was to make my code flexible enough to pull data from any website and then update the data in my database thru use of some global functions I created.
Really nice tutor.. The learning is really made very simple and user friendly...
My pleasure.
Amazing, just amazing, I was struggling with this stuff in my class(I had a horrible, careless teacher), but watching your tutorials it's just a walk in a park.Thanks again for your help sir!!!
Welcome
Thank you soo much for your lessons. I have a job interview for a Data Analyst position and there will be a basic access test. This was a great refresher as I haven't used it in MANY years!
Awesome. How'd that interview go all those years ago?
hi richard,
Im a begginer on databases and I understanding this course so easily. i love it. keep doing it so great.
thanks,
Welcome
So helpful! Thank you. All of your lessons are great and easy to follow. My office efficiency will increase substantially knowing how to use Access.
So, did it increase? :)
I like the straightforward understandable approach you use. Thank you!
My pleasure.
I picked up "Sams Teach Yourself SQL in 10 Minutes", but couldn't get past the first chapter, as I have never used any database program before, and their description of how to use MS Access didn't correspond to what I saw on my screen. So off to search Google--and everything the book assumed I already knew is spelled out right here! I will definitely be back! Thank you so much for developing thee tutorials!
Welcome. See SQL with Access: 599cd.com/SQLwithAccess
I am still learning so much with these videos.
I learn so much by watch your video, thanks
Welcome
Great videos. The last time I used Access was Office 97, and this is a great way to come up to speed with all the changes. Thanks!
Welcome
Great info! I especially like the easy way to do multiple sort criteria, and how to move columns. Thank you!
Thank you for sharing. This information is very helpful because I am building a database for my task at work.
Glad it was helpful!
Excellent video - One of the best I have seen so far and I have seen a lot.
Thanks!
This is an excellent course for beginners. I'm taking the Level 2 beginner courses next.
My pleasure
Thank you - just learn more through the query. But I did at the beginning entered the HomeAdress differently then your table. I put all the homeaddress in the same field. I could have separate them but for me for this purpose of my database it work better if I have the address in one cell. I don't have to select the different state. However, I did include yes or no in one of the field and this is where the query help me to find out who I need to mail to.
If you still need it: 599cd.com/Ask
to the point and brilliant.
this guy has amazing explanation skills
thanks
I don't know why I asked you that you already have the answer step by step dammm I am so happy
:)
Thank you so much for taking the time to develop these tutorials! Great job
Welcome
This is amazing. I usually program on VBA Excel and I need to learn VBA Access and I really haven't worked with Access at all.
My pleasure
Good Videos, very detailed.
GREAT TUTORIALS. I SUBSCRIBED and will go to your website.
Thanks!
You're my best teacher. Thank you.
My pleasure.
Thanks for illustrating with such simplicity. Where were you when I was crying through my algebra class? Do you teach Algebra?
E = mc^2 - oh wait, that's physics
Wow! What a good tutorial! Thanks a lot.
You're welcome
I wish i can give you two thumbs up!! this was excellent!
(Y) (Y) --- awww... these don't translate into thumbs up on TH-cam. :(
Very good easy to understand video
My pleasure
Excellent Tutorials Thanks
Good job, I like the sequence of these videos.
My pleasure
This was great! Thank you for an easy to follow tutorial.
Welcome
very helpful Asim syef.Dubai
Thanks
Great Tutorial Video. Thank you very much :)
Welcome
These tutorials are really helpful. Great!!!
Thanks
thank you very much you are great help
This is great.
Thanks
Wonderful tutorials sir, terrific work..:)
thanks for the selfless gesture.
Thank u for u'r training parts, let me to learning more
Welcome
Great presentation well done!
Thank you
It seems pretty crude that you have to move fields in the query so you can order the sorts. In excel you can designate first, second, third columns for sorting. Do you have to move the fields after you run the sort query to get them to display FirstName LastName if the boss wants it that way?
You move them in design view to change the sort order. You can display them later however you want.
its just perfect. many many thanks
My pleasure
you are better than my teacher lol
I get that a lot. :)
I'd like to give tones of "thumb up" for classes! Thx a lot!
You are very welcome.
I like it. I need help with calculations. Good video.
Thanks
My professor is having us use this for our class
Hello Sir,
In my university i have been taught to write all the first name with short text in note pad rather than in table design the one you have taught...is that also fine doing in table design..
Thanks
welcome
I'm starting a job tmr, and am expected to know access, currently binging your videos at 2X speed
😅 how did things go?
good luck! at you new job.
Yeah, how'd things go?
Excellent videos. May I suggest an easy way to get to your site. Like a link that is easy to find.
You mean like the link that's on the thumbnail picture for the video... or at the end of the video on the closing screens... or the clickable links in the description below the video? Those links?
My pleasure
Brilliant work
thanks
Great work! Thank you!
Welcome
Thank you I learned several new things!
Welcome
Thank you very good
Welcome
Thanks for the great Tutorial
welcome
Great tutorial...
Thanks
Queries made easy
My pleasure
there is a lesson where you explain how to use query or table data to automatic fill info into some other documents? for example: I have a privacy form that customer have to sign, can i use a query to generate them in ms word? ty
You want to automatically populate the customer's data in a report? Just create the report and based it on the customer table. Or make a privacy form table if you want to store that information as well (date signed, etc.) and then create a query based on both tables, and use that for the report.
I have found the answer in your "mail merge" lesson! ty
Thank you very much
Welcome
Fantastic!!!!
Thanks
you are awesome!
thanks
Thank you
You're welcome
Here is what I need to do, which part of the classs do I need to view to be able to do it.
I am making a volunteer list. Each volunteer volunteers on different days and times. I would like to be able to run a querry where I can see each day separatly and who works at what time on this day.
+Victoria Richter I would use a second table for this. In the 2nd table you can track each volunteer's schedule. I cover multi-table relationships starting with my EXPERT series, which is on my web site. 599cd.com
Thank you!
thanks
Welcome
Hello , I have question : I am creating a Query, and I precised each client if he is a "M" or "Mlle" or "Mme". How can i count how many M's ; Mme's and Mlle's i have ?
Thank you !
599cd.com/Aggregate
salam , you explain things weel , would it be poosible for you to teach courses like Human resources , management , secretary and ticketing course please ? Thank you
I can teach anything that I know... but those topics aren't my areas of expertise.
Thank you.
You are very welcome. Glad you enjoyed!
Hello, I have to make a table, 2 queries, and a report for a class of mine and I'm running into difficulties. I made my initial table and it came out fine but when I need to make my first query, which needs to only have the data for male clients in a certain state, I can't seem to get the query to work. I can however get it t work when i make a separate table with only the male clients but I will have points removed for doing so. I also can't get my report to auto-fill the data from my 2nd query that has only clients from a certain city,state. Please help if possible.
No idea what you mean, sorry
Hi, would like to ask how to compute for networkdays between two dates..hope you could help..
I build a NetWorkDays function for Access in 599cd.com/DateTime
I signed up For the 29.99 membership but there are no details how to access the discounts. It says that my Questions will bounce to the top. We will see.
Hi Teri. Like the Membership instructions say, you have to CONTACT ME so I know you exist. TH-cam gives me NO info on you except your username and memberships level. Email me at amicron@gmail.com so I can set you up an account on my web site.
greatttttttttttttttttttttt
Thanksssssssssss
So Ive got a bunch f different queries set up but for one particular query it always asks to enter parameter value. Does anyone know what to do in this case?
599cd.com/EnterParameterValue
Where are your other beginner levels like 3 and 2??
599cd.com/ACB2
In a query, I need to combine data from multiple rows into a single field, such as:
Doc1 Part1 Ship1
Doc1 Part1 Ship2
Doc1 Part2 Ship1
Doc1 Part2 Ship2
Doc2 Part1 Ship1
Doc2 Part1 Ship2
Desired results:
Doc1 Part1 Ship1, Ship2
Doc1 Part2 Ship1, Ship2
Doc2 Part1 Ship1, Ship2
Any ideas on how to do this? I'm not well versed at all in the use of VBA, but suspect that I will have to use VBA code for this. Any help will be appreciated.
Yeah, this is probably going to involve some VBA programming - probably recordsets which I cover in this class: 599cd.com/XAC320
I am trying to create a query in a Field that has a Y/N data type. I keep getting an error message that says "data type mismatch".
You did not give me enough information to answer your question. Please be more specific. Also, I get a ton of questions every day, and I don't have time to answer them all here on TH-cam. Feel free to submit your question on my website at: 599cd.com/AskYT
i just create client from, if any client want sent a report anything how could i know
Huh?
satisfied
Sweet
How do you search for a customer name like Smith ?
599cd.com/Criteria
what happened with the other information in the queries you only add Name and last name what about the other
Still there. Just hidden.
19:46 Literally or Figuratively?
You don't see me scratching? >scratch
what is the use of the query??
+أحمد سارحان This is covered in part I I think it might be the 8th lesson. With the query you can save the search which is different from the sort that once the program is closed the search is lost.
599cd.com/Queries
When I type PA in the place of NY it says partition . Why?
I think that PA is a programing language for partition. Mine did the same thing. If I typed it within the quotation marks it was ok.
Never seen that before.
How to make query for certain dates ?
Use a date criteria. 599cd.com/Criteria
Shit!
I know the Parameter Queries (Level 5) but I only just learnt normal Queries (Level 1)
#Backwards!!!
Haha. Yep!
all in future lesson you need 1 dollar lol
Yep. Cough up that cold, hard buck.
Thank you
You're welcome.
thanks
welcome