Access: Designing a Simple Query

  Рет қаралды 1,301,855

LearnFree

LearnFree

Күн бұрын

Пікірлер: 90
@tockct
@tockct 7 жыл бұрын
Concise, easy to understand, good audio clarity and comes with subtitles as well. These videos are a life saver. Thank you!
@lowkey_Ioki
@lowkey_Ioki 5 жыл бұрын
Two years later and you're still saving lives. Thank you so much!
@gillianfraser1820
@gillianfraser1820 7 жыл бұрын
thank you a million times my daughter have been looking all over the internet for a simple video thanks again
@kemalbasic7468
@kemalbasic7468 6 ай бұрын
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
@girishgarg2236 3 жыл бұрын
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
@nicholashm
@nicholashm 5 жыл бұрын
I love you stranger with a voice that is like Tina's from Bob's Burgers. Great job.
@jeanandrewjoseph
@jeanandrewjoseph 6 жыл бұрын
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.
@gill2987
@gill2987 6 жыл бұрын
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
@GCFLearnFree 6 жыл бұрын
You are very welcome. We're so glad we could help you!
@paigequeenb8257
@paigequeenb8257 7 жыл бұрын
Thank you! Starting my first Finance job next week and I need to brush up on these things.
@NeilNileStudios
@NeilNileStudios 5 жыл бұрын
0:58 query designs tab. Thank you. You my friend are a life saver.
@zoeeAlexa
@zoeeAlexa 8 жыл бұрын
You are helping me a lot with your videos! Thank you very much!
@nick_UponTheFallen
@nick_UponTheFallen 6 жыл бұрын
Thank you for the concise easy to understand break down of creating queries
@vasukhandekar
@vasukhandekar 7 жыл бұрын
Better explaination than my maths teacher. And my school is third in education in india
@inferiorfrog-filledmeadows5468
@inferiorfrog-filledmeadows5468 6 жыл бұрын
which school
@sophiebuchanan9861
@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
@GCFLearnFree Жыл бұрын
Best of luck!
@TanayaAmar
@TanayaAmar 5 жыл бұрын
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
@sajht6
@sajht6 6 жыл бұрын
your voice sounds like Tina from "Bob's Burgers"
@alexschmidt4427
@alexschmidt4427 5 жыл бұрын
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
@gsaeri8935 5 жыл бұрын
can't unhear this now
@rossabrahams7080
@rossabrahams7080 4 жыл бұрын
🤣🤣
@shalawjaza9271
@shalawjaza9271 4 жыл бұрын
This was so helpful I am a student and I was in hurry then I saw this video thank you so much
@ArnavPawar-e7i
@ArnavPawar-e7i 5 ай бұрын
Nice Videos you got here. Helped me for my practical exam really
@mislight8033
@mislight8033 3 ай бұрын
Thank you. This really helped me and it was so easy to understand
@epicrafter924boss6
@epicrafter924boss6 2 жыл бұрын
I appreciate it, this has been a very helpful video for my project :D
@GCFLearnFree
@GCFLearnFree 2 жыл бұрын
Glad to hear it!
@WayneM1961
@WayneM1961 5 жыл бұрын
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
@anybody007_who
@anybody007_who 2 жыл бұрын
The playlist's simplicity is awesome.
@GCFLearnFree
@GCFLearnFree 2 жыл бұрын
Thank you!
@Muctronic
@Muctronic 2 ай бұрын
Thanks, video helped a lot.
@harshdeep5642
@harshdeep5642 Жыл бұрын
Thank u so much man. I have to submit my project on DBMS tomorrow. This helped me a lot
@GCFLearnFree
@GCFLearnFree Жыл бұрын
Best of luck!
@pronounceword
@pronounceword 5 жыл бұрын
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.
@vershawnnelson9092
@vershawnnelson9092 4 жыл бұрын
Thank you soo much This helps me in my I.T class. Keep up the good work
@dalskiBo
@dalskiBo 6 жыл бұрын
Thanks for the great tutorial!
@isimbulamadmobenibulsun660
@isimbulamadmobenibulsun660 2 жыл бұрын
it's very great explained. I was struggling in the college
@selenadookaran4984
@selenadookaran4984 6 жыл бұрын
Thank you! I really needed help. Getting a test on this.
@muffin834
@muffin834 2 жыл бұрын
This was so helpful, thank you so much for posting this!
@GCFLearnFree
@GCFLearnFree 2 жыл бұрын
Glad it was helpful!
@prashantsharma4311
@prashantsharma4311 3 жыл бұрын
Very nice Sir 👍 👍
@helenandagwedhapo2191
@helenandagwedhapo2191 4 жыл бұрын
thank you so much you are a good teacher
@bibhavdash3145
@bibhavdash3145 5 жыл бұрын
Thank you very much.. From India
@marlonbruce215
@marlonbruce215 7 жыл бұрын
Hi. If I wanted to show/list the last five (5) dates of which any particular customer purchased an item?
@GCFLearnFree
@GCFLearnFree 7 жыл бұрын
You would need data from more than one table to do this. Check out this video to learn more: kzbin.info/www/bejne/ppTNiYSngLyKhNk. 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!
@chamilapradeepika4606
@chamilapradeepika4606 4 жыл бұрын
Thank u a million times it was soo simple
@Lam-ll1lh
@Lam-ll1lh 6 жыл бұрын
Excellent video!! 👏🏼
@bigandfine
@bigandfine 6 жыл бұрын
Thank you explain everything I needed.
@EatNWalk
@EatNWalk 4 жыл бұрын
Very useful, thank you.
@simplejames1642
@simplejames1642 Жыл бұрын
Thanks man 💪
@GCFLearnFree
@GCFLearnFree Жыл бұрын
No problem 👍
@happykabaso5027
@happykabaso5027 4 жыл бұрын
very helpful thanks
@GCFLearnFree
@GCFLearnFree 4 жыл бұрын
You're welcome!
@ClintonSnow
@ClintonSnow 6 жыл бұрын
Very good video, This video is very helpful and easy explanation.
@tirthadey9311
@tirthadey9311 4 жыл бұрын
Thank you for the video
@DoSomethingProductive
@DoSomethingProductive 4 жыл бұрын
Could this be considered a QBD? (query by design)
@md.rabiulalamhridoy7391
@md.rabiulalamhridoy7391 7 жыл бұрын
VEY HELPFUL.. THANKS
@salmanagy6382
@salmanagy6382 6 жыл бұрын
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
@GCFLearnFree 6 жыл бұрын
This sounds more advanced than what we offer. Sorry we couldn't be more helpful to you!
@cjcisbeast
@cjcisbeast 7 жыл бұрын
I live in raleigh so respect
@ittaiak1246
@ittaiak1246 5 жыл бұрын
thanks you, it helped a lot
@samuelbaje4915
@samuelbaje4915 3 ай бұрын
This guy's voice reminded me of sheldon from the big bang theory.😅 Great video tho👍
@JohnSmith-td6dn
@JohnSmith-td6dn 7 жыл бұрын
Can you just write an SQL Query, much simpler. If you can where would you do that ?
@GCFLearnFree
@GCFLearnFree 7 жыл бұрын
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
@JohnSmith-td6dn 7 жыл бұрын
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
@GCFLearnFree 7 жыл бұрын
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!
@pankajnegi2397
@pankajnegi2397 5 жыл бұрын
Thanks very helpful
@jadesolaogundipe2363
@jadesolaogundipe2363 4 жыл бұрын
This was so helpful
@nevalauguste4782
@nevalauguste4782 3 жыл бұрын
I've followed through but after I click "run" the data expected does not appear ... what do I do then?
@abhikkumarpal
@abhikkumarpal 6 жыл бұрын
nice.Vividly explained
@ayub_mohamed
@ayub_mohamed 2 жыл бұрын
THANKS sir
@alyzak.8997
@alyzak.8997 2 жыл бұрын
You're the man
@zakarya_husaen
@zakarya_husaen 6 жыл бұрын
Keep doing it
@mdshakibulhossainsikder9313
@mdshakibulhossainsikder9313 4 жыл бұрын
excellent
@pufoambysss1
@pufoambysss1 2 жыл бұрын
good sir
@brookep942
@brookep942 5 жыл бұрын
THANK YOU!
@Shena1580
@Shena1580 6 жыл бұрын
Thank you so much
@androidgamezzz5775
@androidgamezzz5775 4 жыл бұрын
this doesnt even work. It just duplicates my data. im so tired of having to keep up with access for my school work...
@omarh1010
@omarh1010 6 жыл бұрын
500th like 🔥
@jmm4963
@jmm4963 4 жыл бұрын
thxx broo
@terrencebob1276
@terrencebob1276 5 жыл бұрын
Ms ramandeep sent me here
@qiuxnight
@qiuxnight 2 жыл бұрын
TYVM
@subbaramaiahravuri5577
@subbaramaiahravuri5577 2 жыл бұрын
good
@insanecxy8741
@insanecxy8741 Жыл бұрын
another banger
@blesstetteyodjao9605
@blesstetteyodjao9605 6 жыл бұрын
VERY SIMPLE
@jtraffordh
@jtraffordh 5 жыл бұрын
ok
@minaafrasiabi1887
@minaafrasiabi1887 4 жыл бұрын
Thank you so much
@mariamtariq8152
@mariamtariq8152 2 жыл бұрын
Thank you so much
@GCFLearnFree
@GCFLearnFree 2 жыл бұрын
You're most welcome
Access: Multi-table Queries (Part 1)
5:25
LearnFree
Рет қаралды 573 М.
MS Access - Queries Part 1: Basic queries
19:10
Mr Long Education - IT & CAT
Рет қаралды 145 М.
Cheerleader Transformation That Left Everyone Speechless! #shorts
00:27
Fabiosa Best Lifehacks
Рет қаралды 16 МЛН
Cat mode and a glass of water #family #humor #fun
00:22
Kotiki_Z
Рет қаралды 42 МЛН
Правильный подход к детям
00:18
Beatrise
Рет қаралды 11 МЛН
How to use Microsoft Power Query
16:35
Kevin Stratvert
Рет қаралды 2,1 МЛН
Microsoft Access - Tutorial for Beginners [ COMPLETE ]
15:40
Skills Factory
Рет қаралды 1 МЛН
Creating a Query in Microsoft Access
26:09
Computer Learning Zone
Рет қаралды 15 М.
2024's Biggest Breakthroughs in Math
15:13
Quanta Magazine
Рет қаралды 358 М.
MS Access - Tables Part 1: Creating a database and tables
18:56
Mr Long Education - IT & CAT
Рет қаралды 218 М.
How to use Microsoft Access - Beginner Tutorial
31:07
Kevin Stratvert
Рет қаралды 3,4 МЛН
Access: Multi-Table Queries (Part 2)
3:36
LearnFree
Рет қаралды 247 М.
MS Access - Forms Part 1: Basic forms
11:05
Mr Long Education - IT & CAT
Рет қаралды 105 М.
How to Add Simple User-Level Security to Microsoft Access Databases
26:44
Computer Learning Zone
Рет қаралды 43 М.
Cheerleader Transformation That Left Everyone Speechless! #shorts
00:27
Fabiosa Best Lifehacks
Рет қаралды 16 МЛН