Access: Designing a Simple Query

[@tockct]

Concise, easy to understand, good audio clarity and comes with subtitles as well. These videos are a life saver. Thank you!

[@lowkey_Ioki]

Two years later and you're still saving lives. Thank you so much!

[@gillianfraser1820]

thank you a million times my daughter have been looking all over the internet for a simple video thanks again

[@kemalbasic7468]

A video on the internet managed to explain this better in 5 minutes than an assistant at my uni did in 4 months. Great.

[@girishgarg2236]

when my sir taught me this I was superb confused but I saw your video i said to my teacher that it was very easy and also gave practical of it and I got very good marks

[@paigequeenb8257]

Thank you! Starting my first Finance job next week and I need to brush up on these things.

[@jeanandrewjoseph]

Thank you. You have helped me understand how to create a simple query. This is beneficial to me because I am currently doing an assessment that is based on access, creating forms and query. I wasn't sure how to make a query. If I get a good mark, it's because of you. Please continue making such beneficial and simple videos. From NZ.

[@nicholashm]

I love you stranger with a voice that is like Tina's from Bob's Burgers. Great job.

[@gill2987]

I'm in 11th grade and I take Computer Application Technology as a subject. But I'm completing high-school online so I have no help from anywhere. and I have a task due in two days involving word, excel and lastly the dreaded access. So glad this enabling me to actually complete this assignment.THANK YOU!

[@GCFLearnFree]

You are very welcome. We're so glad we could help you!

[@nickcontabile]

Thank you for the concise easy to understand break down of creating queries

[@ArnavPawar-e7i]

Nice Videos you got here. Helped me for my practical exam really

[@zoeeAlexa]

You are helping me a lot with your videos! Thank you very much!

[@sophiebuchanan9861]

Amazing content. Been sick for half of my course on database design this sem and you taught me everything I need to know for my assignment :)

[@GCFLearnFree]

Best of luck!

[@WayneM1961]

Thank you. It's been years since I used Access. I use Word and Excell all the time, but have forgotten how to use Access

[@vasukhandekar]

Better explaination than my maths teacher. And my school is third in education in india

[@inferiorfrog-filledmeadows5468]

which school

[@mislight8033]

Thank you. This really helped me and it was so easy to understand

[@TanayaAmar]

I'm a Duke graduate working outside NC, and I have an interview next Friday for a role that requires Access. I wanted to watch a short video that explained the basics and this was the first video I selected. Was shocked to see the City column! I guess the interview is gonna go great! :D

[@anybody007_who]

The playlist's simplicity is awesome.

[@GCFLearnFree]

Thank you!

[@Muctronic]

Thanks, video helped a lot.

[@shalawjaza9271]

This was so helpful
I am a student and I was in hurry then I saw this video thank you so much

[@harshdeep5642]

Thank u so much man. I have to submit my project on DBMS tomorrow. This helped me a lot

[@GCFLearnFree]

Best of luck!

[@NeilNileStudios]

0:58 query designs tab. Thank you. You my friend are a life saver.

[@isimbulamadmobenibulsun660]

it's very great explained. I was struggling in the college

[@dalskiBo]

Thanks for the great tutorial!

[@helenandagwedhapo2191]

thank you so much you are a good teacher

[@selenadookaran4984]

Thank you! I really needed help. Getting a test on this.

[@sajht6]

your voice sounds like Tina from "Bob's Burgers"

[@alexschmidt4427]

You have a very good touch of teaching. That is my very first video here and I am feeling reposed here I don't now if that is how to describe it but thank you

[@gsaeri8935]

can't unhear this now

[@rossabrahams7080]

🤣🤣

[@vershawnnelson9092]

Thank you soo much
This helps me in my I.T class. Keep up the good work

[@muffin834]

This was so helpful, thank you so much for posting this!

[@GCFLearnFree]

Glad it was helpful!

[@chamilapradeepika4606]

Thank u a million times it was soo simple

[@epicrafter924boss6]

I appreciate it, this has been a very helpful video for my project :D

[@GCFLearnFree]

Glad to hear it!

[@pronounceword]

I like your video very much. It's really great. I'll keep an eye on your channel. I am your fan and I will support you.

[@bibhavdash3145]

Thank you very much.. From India

[@prashantsharma4311]

Very nice Sir 👍 👍

[@Lam-ll1lh]

Excellent video!! 👏🏼

[@marlonbruce215]

Hi. If I wanted to show/list the last five (5) dates of which any particular customer purchased an item?

[@GCFLearnFree]

You would need data from more than one table to do this. Check out this video to learn more: ua-cam.com/video/pcjXQqKWWNw/v-deo.html. Once you create the query, you can filter and sort it to find the most recent orders from a specific customer. We hope it helps!

[@bigandfine]

Thank you explain everything I needed.

[@EatNWalk]

Very useful, thank you.

[@simplejames1642]

Thanks man 💪

[@GCFLearnFree]

No problem 👍

[@md.rabiulalamhridoy7391]

VEY HELPFUL.. THANKS

[@cjcisbeast]

I live in raleigh so respect

[@ittaiak1246]

thanks you, it helped a lot

[@happykabaso5027]

very helpful thanks

[@GCFLearnFree]

You're welcome!

[@jadesolaogundipe2363]

This was so helpful

[@tirthadey9311]

Thank you for the video

[@nevalauguste4782]

I've followed through but after I click "run" the data expected does not appear ... what do I do then?

[@pankajnegi2397]

Thanks very helpful

[@JohnSmith-td6dn]

Can you just write an SQL Query, much simpler. If you can where would you do that ?

[@GCFLearnFree]

While we don't offer this in our lessons, we did find this tutorial that covers SQL queries: www.tutorialspoint.com/sql/sql-select-query.htm. We hope it helps!

[@JohnSmith-td6dn]

I don't need a tutorial on queries, I just want to use Access on my desktop. I am a retired IT person/ web developer/ DB admin yada, yada. I do not want to set SLQ Server or a web site to do simple at home "stuff". SQL is just a great DB tool and it just seems the Access tool is ugly.

[@GCFLearnFree]

Ah OK. Well, we unfortunately don't offer any information on SQL, as our tutorials are more geared toward beginners and in our experience using SQL gets into more complex territory. Sorry we weren't able to help you more!

[@ClintonSnow]

Very good video, This video is very helpful and easy explanation.

[@DoSomethingProductive]

Could this be considered a QBD? (query by design)

[@salmanagy6382]

I want to learn how to connect to tables with a special way like: I have a database for students and in the main table there is a field of the number of absence days, in the other table is like a calendar with the teachers if she marked on one day or added a link to the document it will automatically count one number more in the first main table under the field of absece and student's record . can you please help me in that ?

[@GCFLearnFree]

This sounds more advanced than what we offer. Sorry we couldn't be more helpful to you!

[@abhikkumarpal]

nice.Vividly explained

[@androidgamezzz5775]

this doesnt even work. It just duplicates my data. im so tired of having to keep up with access for my school work...

[@alyzak.8997]

You're the man

[@ayub_mohamed]

THANKS sir

[@brookep942]

THANK YOU!

[@pufoambysss1]

good sir

[@Shena1580]

Thank you so much

[@zakarya_husaen]

Keep doing it

[@samuelbaje4915]

This guy's voice reminded me of sheldon from the big bang theory.😅
Great video tho👍

[@terrencebob1276]

Ms ramandeep sent me here

[@mdshakibulhossainsikder9313]

excellent

[@insanecxy8741]

another banger

[@jmm4963]

thxx broo

[@qiuxnight]

TYVM

[@omarh1010]

500th like 🔥

[@blesstetteyodjao9605]

VERY SIMPLE

[@subbaramaiahravuri5577]

good

[@jtraffordh]

ok

[@minaafrasiabi1887]

Thank you so much

[@mariamtariq8152]

Thank you so much

[@GCFLearnFree]

You're most welcome