Microsoft Access 2013 Tutorial Level 1 Part 09 of 12 - Customer Queries

[@tommynickels4570]

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 KZbin.

[@halidbesher8331]

Thank you very much

[@599CD]

I appreciate the kind words. :)

[@cacybroughton4462]

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.

[@599CD]

My pleasure

[@thomasosei6545]

i like the way this guy teaches. That is a mark of a good teacher

[@williamjamesrapp7356]

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

[@599CD]

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... :)

[@Shaukatali-vd3ov]

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

[@599CD]

Thank you. I appreciate the compliment! I'm glad you enjoyed.

[@sharonneville3164]

Honestly the best tutorial I have seen...So well presented, good pace and covers everything in a simple way. Fantastic

[@599CD]

Thank you. I appreciate that.

[@danilocarrara7494]

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 pleasure

[@garyplummer3305]

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.

[@599CD]

Excellent observation. Thank you for sharing.

[@junecombs4874]

This corse is so easy to follow. And was made for a beginner like me! Richard is WONDERFUL!!

[@599CD]

Thanks!

[@sewintouch]

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.

[@599CD]

My pleasure

[@1012bela]

Excellent video - One of the best I have seen so far and I have seen a lot.

[@599CD]

Thanks!

[@goodairin]

I like the straightforward understandable approach you use. Thank you!

[@599CD]

My pleasure.

[@TubeSurferToo]

Great info! I especially like the easy way to do multiple sort criteria, and how to move columns. Thank you!

[@variadas3888]

hi richard, Im a begginer on databases and I understanding this course so easily. i love it. keep doing it so great. thanks,

[@599CD]

Welcome

[@iberiuspolonius8591]

I am still learning so much with these videos.

[@elkhanhamet2561]

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!!!

[@599CD]

Welcome

[@rohitchandankar1572]

Really nice tutor.. The learning is really made very simple and user friendly...

[@599CD]

My pleasure.

[@smarthought]

to the point and brilliant. this guy has amazing explanation skills

[@599CD]

thanks

[@NathanielTyler]

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.

[@arsalannawabi6201]

+Nathaniel Tyler so do I

[@Kabuldenver]

+Nathaniel Tyler scares getting away from me too

[@599CD]

Awww thanks

[@NathanielTyler]

@@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.

[@ellenmurphy6983]

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!

[@599CD]

Awesome. How'd that interview go all those years ago?

[@LaNoraTolman]

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.

[@599CD]

So, did it increase? :)

[@davidnorthcutt1504]

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!

[@599CD]

Welcome

[@shelbyie]

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.

[@umangtaneja]

I totally agree with this statement. (y)

[@woss2010]

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​

[@599CD]

Thanks for the compliments. I actually had one student tell me that her college instructor told them NOT to go on KZbin 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.....

[@irenetzi]

Thank you so much for taking the time to develop these tutorials! Great job

[@599CD]

Welcome

[@c.m.754]

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!

[@599CD]

Welcome. See SQL with Access: 599cd.com/SQLwithAccess

[@cjbrown8737]

This is an excellent course for beginners. I'm taking the Level 2 beginner courses next.

[@599CD]

My pleasure

[@Chewyinggum7]

I learn so much by watch your video, thanks

[@599CD]

Welcome

[@woss2010]

I don't know why I asked you that you already have the answer step by step dammm I am​ so happy

[@599CD]

:)

[@cherry3464]

Thank you for sharing. This information is very helpful because I am building a database for my task at work.

[@599CD]

Glad it was helpful!

[@JulieKenk]

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.

[@599CD]

If you still need it: 599cd.com/Ask

[@taprim7250]

I wish i can give you two thumbs up!! this was excellent!

[@599CD]

(Y) (Y) --- awww... these don't translate into thumbs up on KZbin. :(

[@charlessitta8247]

You're my best teacher. Thank you.

[@599CD]

My pleasure.

[@heyyou5170]

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.

[@599CD]

My pleasure

[@VijRaghavan]

Wonderful tutorials sir, terrific work..:)

[@sasquatch471]

Good Videos, very detailed.

[@anichekanu1167]

Good job, I like the sequence of these videos.

[@599CD]

My pleasure

[@alanmcdougal]

GREAT TUTORIALS. I SUBSCRIBED and will go to your website.

[@599CD]

Thanks!

[@yisiwang5943]

These tutorials are really helpful. Great!!!

[@599CD]

Thanks

[@dstimpy73]

This was great! Thank you for an easy to follow tutorial.

[@599CD]

Welcome

[@MrHenrywickham]

Excellent Tutorials Thanks

[@enihgilead1427]

Wow! What a good tutorial! Thanks a lot.

[@599CD]

You're welcome

[@dbzamv8393]

you are better than my teacher lol

[@599CD]

I get that a lot. :)

[@elifurahamollel379]

Thank u for u'r training parts, let me to learning more

[@599CD]

Welcome

[@jsmcguireIII]

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?

[@599CD]

You move them in design view to change the sort order. You can display them later however you want.

[@07dmackay]

Thanks for illustrating with such simplicity. Where were you when I was crying through my algebra class? Do you teach Algebra?

[@599CD]

E = mc^2 - oh wait, that's physics

[@stevekey802]

Great presentation well done!

[@599CD]

Thank you

[@jackolynking3640]

Very good easy to understand video

[@599CD]

My pleasure

[@Haider_Speaks]

very helpful Asim syef.Dubai

[@599CD]

Thanks

[@mrformoza5397]

I'd like to give tones of "thumb up" for classes! Thx a lot!

[@599CD]

You are very welcome.

[@joverlabao1763]

Great Tutorial Video. Thank you very much :)

[@599CD]

Welcome

[@AUG31]

I like it. I need help with calculations. Good video.

[@599CD]

Thanks

[@thomasosei6545]

thanks for the selfless gesture.

[@thiccskip1019]

My professor is having us use this for our class

[@KesronMcDonald]

Brilliant work

[@599CD]

thanks

[@arsalannawabi6201]

its just perfect. many many thanks

[@599CD]

My pleasure

[@bibulenok]

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.

[@599CD]

+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

[@bobbyebadi3111]

Thank you I learned several new things!

[@599CD]

Welcome

[@TheWheelchairGuy]

This is great.

[@599CD]

Thanks

[@md.faisalkamal9946]

Great tutorial...

[@599CD]

Thanks

[@joysrayil5973]

Great work! Thank you!

[@599CD]

Welcome

[@anamariehernandez4093]

thank you very much you are great help

[@Kabuldenver]

I use this in a school admin system today my director wanted me to print one of the student's all info but I couldn't get it in a sheet when i was printing all students name were coming out. how can I print only one student info in a time please. another question is this how can I sort a list of my Data in two different type of age for example - 20 and above -19 and below and I need to print these out separately? thanks in advance.

[@599CD]

?

[@ThePyrosquirrely]

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.

[@599CD]

No idea what you mean, sorry

[@Kabuldenver]

Hi Mr Rost I followed your instruction that you said in this video but faced in a problem I had tables before and I create query after I run there is no Data shown only fields name. would you mind telling me what is the problem please? thanks in advance

[@599CD]

No idea

[@Reliscian]

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

[@599CD]

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.

[@Reliscian]

I have found the answer in your "mail merge" lesson! ty

[@Ironbuket]

19:46 Literally or Figuratively?

[@599CD]

You don't see me scratching? >scratch

[@teribridges4598]

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.

[@599CD]

Hi Teri. Like the Membership instructions say, you have to CONTACT ME so I know you exist. KZbin gives me NO info on you except your username and memberships level. Email me at [e-mail] so I can set you up an account on my web site.

[@jaymiller5949]

Excellent videos. May I suggest an easy way to get to your site. Like a link that is easy to find.

[@599CD]

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?

[@599CD]

My pleasure

[@236anoushka]

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

[@599CD]

welcome

[@dramina2326]

Fantastic!!!!

[@599CD]

Thanks

[@elissarrez3462]

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]

599cd.com/Aggregate

[@jialianglow]

I'm starting a job tmr, and am expected to know access, currently binging your videos at 2X speed

[@umertahir4547]

😅 how did things go?

[@woss2010]

good luck! at you new job.

[@599CD]

Yeah, how'd things go?

[@laniersimone]

you are awesome!

[@599CD]

thanks

[@olcurt1966]

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".

[@599CD]

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 KZbin. Feel free to submit your question on my website at: 599cd.com/AskYT

[@JaitaUchiha]

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]

599cd.com/EnterParameterValue

[@mdalamgirhossain6544]

Thank you

[@599CD]

You're welcome.

[@tirumalarao1048]

i just create client from, if any client want sent a report anything how could i know

[@599CD]

Huh?

[@sayedhossain23]

Thank you very good

[@599CD]

Welcome

[@lanalane5267]

Queries made easy

[@599CD]

My pleasure

[@scottmarshall5645]

Thanks for the great Tutorial

[@599CD]

welcome

[@mauriciovelrol]

Thank you very much

[@599CD]

Welcome

[@mandarin408]

When I type PA in the place of NY it says partition . Why?

[@melissamorgan2022]

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.

[@599CD]

Never seen that before.

[@categoryassociate9119]

Hi, would like to ask how to compute for networkdays between two dates..hope you could help..

[@599CD]

I build a NetWorkDays function for Access in 599cd.com/DateTime

[@sasquatch471]

Thank you!

[@woss2010]

what happened with the other information in the queries you only add Name and last name what about the other

[@599CD]

Still there. Just hidden.

[@rudyrodriguez3242]

How do you search for a customer name like Smith ?

[@599CD]

599cd.com/Criteria

[@nausheennadeem4523]

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

[@599CD]

I can teach anything that I know... but those topics aren't my areas of expertise.

[@aaiqs]

what is the use of the query??

[@jampakunchog]

+‫أحمد سارحان‬‎ 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]

599cd.com/Queries

[@aritrabandyopadhyay2706]

Where are your other beginner levels like 3 and 2??

[@599CD]

599cd.com/ACB2

[@amiraldehleb7221]

How to make query for certain dates ?

[@599CD]

Use a date criteria. 599cd.com/Criteria

[@ETOEstate]

Thank you.

[@599CD]

You are very welcome. Glad you enjoyed!

[@MarcusZaua]

thanks

[@599CD]

Welcome

[@psarltx]

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.

[@599CD]

Yeah, this is probably going to involve some VBA programming - probably recordsets which I cover in this class: 599cd.com/XAC320

[@dzulkiflishaaban4638]

greatttttttttttttttttttttt

[@599CD]

Thanksssssssssss

[@shinewellgwanzura697]

satisfied

[@599CD]

Sweet

[@mgnomercy2758]

Shit! I know the Parameter Queries (Level 5) but I only just learnt normal Queries (Level 1) #Backwards!!!

[@599CD]

Haha. Yep!

[@majhoool100]

all in future lesson you need 1 dollar lol

[@599CD]

Yep. Cough up that cold, hard buck.

[@sosasosa2181]

Thank you

[@599CD]

You're welcome

[@احمدعبد-ت2ج]

thanks

[@599CD]

welcome