🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com 📩 Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: kevinstratvert.com/newsletter/

@tomisinfalode5277

Жыл бұрын

Dear Kevin, do you have an video that covers the advance level?

@trusty.friend

Жыл бұрын

Help! 25:28 😢 my query isn't same as yours I have triple checked every tiny detail to make sure that I'm doing the right thing

@ogbuehimichael3592

Жыл бұрын

😊😊😊😊😊😊😊😊😊

@BUWAMEZULU

Жыл бұрын

Help please I'm confused , in the field of revenue per cookie, what does that mean exactly?

@hashim9802

Жыл бұрын

Do you have to make up people

Sir!!!!!!!!!!!!!!!!!!!!!! You are A lifesaver. You taught me this in 31mins and my teacher couldn't in 3hrs. I have a test coming up on database and this helps me greatly. Thank you!!!!!!!!

@EchoFoxtrot-fs5xd

6 ай бұрын

Mine couldn't trach me in months 😅

@Opshub0

6 ай бұрын

😅😅😅😅 good one

@ultimatejagrav6720

5 ай бұрын

I have also a test tomorrow

@delvinplaysroblox4720

5 ай бұрын

I also have a test tomorrow to

@outsiderfrancis5979

5 ай бұрын

I felt this.

I’m more of a watcher and rarely give comments but I had to speak on how helpful this video was, and how much it will help me at work.

How dare Excel limit me to a million rows?!?! All jokes aside, this was incredibly useful since I've not used Access before. Thanks Kevin!

@user-ws8pm3op2i

Ай бұрын

More surprisingly how does Access manage to allow more than 1m rows 😳

Thank you, Kevin! You show everything without showing too much, and you explain things very succinctly for those of us who have NO clue, but you also don't talk down to us. You are a great instructor, and I will seek you out for other training!

@olliesintown7769

Жыл бұрын

I agree I love u Kevin

@PrinceLied

8 ай бұрын

Yep, just subscribed to the channel.

I feel confident enough to call this KZread channel ''Kevin University." Thanks, Kevin.

@babajan5370

Жыл бұрын

😢

@Odin00

6 ай бұрын

Hmm

@kamelkadri2843

5 ай бұрын

Kevin cookie university

@ando5563

5 ай бұрын

Literally, my uni in introducing us to databases through Ms access and he explained it way better than the lecturer did

@kuviet

5 ай бұрын

I agree with Dave’s comment👌

Oh my ....! It is absolutely fantastic to see how you managed to pack our 2 months of Access academic course in just 31 mins. Thank you so much, Kevin! 😍🥰

@GoldenBearKarl

2 жыл бұрын

and 2x speed 15.5 minutes ;)

@Sunflower94H

Жыл бұрын

Absolutely.

@microsoftofficebasicsmix8341

Жыл бұрын

Sure sure. I need your email Kevin

@carkod

Жыл бұрын

He put your course in 31 mins, offers it for free and you thank him? Maybe your students will come here instead of going to your course?

@hamoodyman9239

Жыл бұрын

npc

My name is Sumani Kudus and I'm watching this video from Ghana, West Africa. I'm a student of the University of Cape Coast, Ghana. Your video has really made Access soo simple for me. I'm having a presentation on Access and with the help of your video I'm pretty sure everything will be easy for me. Thank you!

It's been a long time since I have used Access. I needed a great refresher from start to finish for the basics. This is by far one of the best technical tutorials I've seen on KZread. Thank you!

This was an excellent course! I've been tasked by my customer to create a database using Access, but I have never used Access before. I watched a few other tutorials, but they were either outdated, over simplified, or targeted to a user not familiar with a computer at all, providing more information than a generally experienced Windows user needs. This course is streamlined with clear, concise directions and lots of hands on examples. I created a database alongside Kevin, during the video and it's easy to pause or rewind if it gets ahead of you, or you need further clarification of a step. I will definitely subscribe to more of these videos. Great direction, thanks Kevin!

Kevin is a great educator. Very informative - not too short, not too long - just the right size. Very helpful. It has been ages since I last time used Microsoft Access and Kevin's video was a great refresher! Cheers and thank you

This is amazing... truly a work of art. With your help Kevin, you are going to help me be SO successful in the early stages of my career. The lack of this knowledge throughout companies is mindblowing and you're really giving so much information in such a great and digestible way. Thank you sincerely.

Thank you so much for this video Kevin! I'm trying to take a large, unwieldy spreadsheet and create a database that will tell me what 3rd party vendors are going to be at which site and the date. You've given me enough information to take a crack at it. Your style of explanation is easygoing and understandable. You truly have the heart of a teacher! I've subscribed and liked!

Kevin, i am an Office Trainer in Germany since 1999. I have to say, that you are realy impressing me with your very deep knowledge and the very kind and genius way to make everything easy to understand. You are how an excellent Trainer should be!👍

This was an amazing tutorial to refresh my brain on my Microsoft Access class from 2001. I am an independent bookseller and have an affiliate site where I can get an Excel report of all of the info, and way more than I even need. Now I have all of my customers entered, the books they've purchased, dates, sales, commissions, etc. It's so nice to just click their name and see their entire order history rather than scrolling through a bunch of cells. Thank you!!!

my college professor made us watch this instead of teaching it himself to the class.

@juhgfdsapiyhhnnxc3517

3 ай бұрын

A lot of classes are like that😂😂😂

@satorace

3 ай бұрын

@@juhgfdsapiyhhnnxc3517 yeah I know, a lot of my classes were like that not just the one. Just sucked.

@bridgettenjau923

3 ай бұрын

REAL

@amethystcuffy

2 ай бұрын

Same

@cocoa105

2 ай бұрын

This guy is good. He may be better than the teacher LOL

WOW! In half an hour I have learnt so much than what I was thought in college several years ago. Thank you Kevin

FINALLY! I understand Access. Couldn't image learning anything in just 30 minutes but you nailed it. 20 years of struggling on my own and giving up ... and this video is like life!!

@markheathcote9420

3 жыл бұрын

Likwise. Gone through many videos but this one is by far the best presented

@romeoromeo2026

3 жыл бұрын

@@markheathcote9420 how to download access

This is by far the best introduction to Access I've seen so far. This will actually get me started in creating some very useful databases.

I used access 30 years ago to create lots of databases and in a half hour you restarted my journey back to the next chapter in creating a grant writing database... Smooth teaching, easy to follow, thorough and no over talking.... That's what I call a great tutorial!!! Thanks a million 🤩🤩🤩🤩🤩

@KingAdoLad

7 ай бұрын

❤

Today is my computer practical exam and thanks to you for saving my life

Wow! Really good tutorial and encouraging to get started! Concise, informative, and simple. Well done!!

Thanks Kevin. We need part 2 on how to import data from different sources like Excel and others. More Access tutorials would be so nice.

@ssemaga

3 жыл бұрын

Yes indeed, we need more on importing data.

@MarkBarnardBoise

2 жыл бұрын

After viewing, I feel READY to get started with Access ~ Breathe of Topics & Consise Information make this video a Winner!

@MarkBarnardBoise

2 жыл бұрын

I agree with Andrew, an instruction Video on importing, merging and cleaning the records from my phone's numerous contact sources would be very useful. (Contacts in phone, Google Contacts, etc.) Great work! Keep them coming!

@katieupdegraff4238

2 жыл бұрын

I agree! Keeping my eye on this!

@joeg9561

2 жыл бұрын

Great job. Example of importing antiquated Excel file into data base would be great.

Yes. A great short but informative beginner's guide. I accomplished way more from this short tutorial than all the textbooks and class lecture videos I've had to sort through which takes time.

That's the most succinct and clear Access tutorial I've watched! Really appreciate it! Hope to see more videos on executing SQL batches in MS Access.

I've tried to make sense of this program off and on over many years. You just helped me to finally begin to grasp it which I never even came close before. Always gave up out of frustration. :) Thanks so much! Truly!

Very concise Kevin. No too much unnecessary wording and description added for the learning of a beginner like myself. I could just learn what Microsoft Access Database is from the short vedeo. You are a great instructor. Keep it up.

I have to admit that by watching excellent programmes that my knowledge of both Microsoft Access/Excel is of absolute perfection-impeccably flawless and immaculately excellent to the highest degree! People may sound that I am cocky/arrogant, but you have to AGGRESSIVELY believe in your ability to make it! Thank you very much for the perfect videos, it has benefited/inspired me!

I used access when I was working at an airline. I was great for building reports, data an etc. Love it.

I was so nervous about my interview as an analyst but your videos gave me the refresher and confidence I needed! Thank you!

@KK-wr3ve

3 жыл бұрын

How’d it go ? 😅

I have been struggling for such a long time on how to design a database. This is very simple and easy to understand. By following along I managed to create my database.

Words are not enought to say thanks with how simple you made this, starting a new job requiring producing reports from databases, you are a life saver😃

You have made Access look so simple and easy! Thank you so much for this excellent tutorial Kevin : )

Fabulous intro! I was given a massive Access database (expected a way smaller Excel sheet, which I'm fairly proficient in) for work and was clueless. This was a lifesaver for the nonprofit I work at!!!

Another great tutorial! Thank you. Is it too soon in an introduction tutorial to mention some best practices? *Create field names w/o spaces - this will be of value / ease in queries. *In each table, create a record ID field that is separate / unique from any User readable ID code. *In each table, create a Date_Created field. You may never need to look at it, but it's very handy when troubleshooting. *Name the table with tbl_ prefix. This will create clarity when the database eventually has a Customer table, a Customer form, a Customer report, etc.

Thank you, Kevin! Can you go more into detail regarding queries, forms and reports? MUCH appreciated!

You saved me on my final project for college. Thanks man.

From not knowing anything about Microsoft Access to knowing everything through this video, it was very helpful!

Kevin, you're an excellent teacher! You took a complex subject matter and broke it down to a level that we all can understand in record time. Great job!👍

Thanks for this video, Kevin. You have helped me a lot. I have had to learn how to utilize Access in one week, and because of your tutorial, I'm well on my way. I would love another video on Access. I am in the health profession, so I obviously need some help with the database part of my brain. Thanks so much. I really appreciate your videos.

Beyond super! everything's just perfect - from the tutorial narrative to the presentations to the logic of actions, and that calm, kind voice! Makes everything so easy to grasp. Your video is heaven-sent. Thank you so much Kevin!

@ssemaga

3 жыл бұрын

I like his voice as well.

You ability to explain everything so clearly and easily is out of this world.

I just started to explore Microsoft Access. all this while I used Excel, PowerPoint, and Word. This tutor helps me to understand how to use Microsoft Access and its use. I hope to be able to use this Database apps in the future. Thank you Mr Kevin!!

Wonderful tutorial for beginners with Access. Access is so powewrfull tool, I used it a lot in the past for work. It will be nice if you create another video for more complex databases. It will show the power that Access has. As always thanks for sharing Kevin

Thank you for this Kevin. I've been an Access *user* for years and this simple instructional video has inspired be to do some Access design for my business. Oh, and "Orders Form"/"Customers Form"... nobody caught that ;-)

I work in public health and we're trying to track pathogens and ngl your tutorial has helped a lot in trying to create our own database tracking/reporting! thank you so much!

As an absolute beginner, I loved this tutorial. So, thank you so much Kevin !

Thank you so much, Kevin. You are so great at explaining. It would be great if you could show more about queries, forms and reports. How to and what they can be used for. Also, if you could explain how to use Drop Downs and Mulitple choices for Drop Downs, it would be highly appreciated. Thanks :-)

Extremely useful tutorial, great job - thanks! Would love more on MS Access, please. Especially wrt different kinds of data (not just sales) and different relational options.

Thank you so much for this short tutorial. I have never used Access but am interviewing for a Non-Profit job tomorrow. I feel like I could pick this program up very quickly. Thanks!

Hey Kevin, this is me from India! You cant imagine how simple you make it for people to learn such cool softwares. Thank You, Keep it up and all the best

This was an amazing tutorial, you held my attention throughout. Thank you very much, I've learned quite a bit.

This channel is best of the best, which never fails you. I have been struggling with Access in books and videos. However, this video pinpoint the essentials in half an hour and take you by the hand the necessities all you need to know. Then it leaves up to you to delve into deeper understanding thru other resources. Excellent. This, all in all, unlike others, that give you a huge info and bog you down. HEY, this succinct and effective principle also apply to his other videos that I watched. He's a genius in teaching, and knows the wants of greenhorns. Two thumbs up!!👍👍

I have to say this, you are absolutely amazing and have done such an outstanding job of explaining this in a small amount of time along with so much detail. It was easy to follow along.

This is excellent! What an amazing teacher you are. In just 31 minutes, it is like a whole package taught.

The way you explained every part, is very rare to find in other tutorials. Keep up the good work man❤❤

Really like your instruction style: fast, practical and concise. 👌

Hi I’m Raghad I’m a 8th grade student and i had an exam in this os u saved my life thanks ❤

This is a good intro to Access or a refresh for those beginners who stopped using Access and are coming back to use it. Thanks!

Thank you so much Kevin. A very informative, organized, and easy to understand explanation.

Kevin, this was SUPER HELPFUL! I am a beginner using access. Your tutorial was easy to follow, descriptive without being boring. Thank you. I am now proficient 🙂

As someone has pointed out, Kevin University is the best expression for this Channel, thank you!!! I now finally understand Access even by having a mental block for the last 20 years

Thank you so much. Not only the tutorial ,but the fact you didn't use 50 ads in your video.

Thank you Kevin!! Your videos are helping me so much to pass my database and computer information systems courses 😊

Just subscribed, this was really helpful, I have been tracking customers and orders in separate excel sheets and it is quite clunky. This is a huge help toward getting this all consolidated. Thank you Kevin!

@akinadebayo1988

2 жыл бұрын

Yeah, He hit the nail on the head in just 31 minutes. He used customers and orders as examples. I will an example for driver training records for an organization. Tracking of training records, driver recruitment, accident record etc.

Access exam in literally 2 hours. This was the perfect refresher! Thank you

Infact your channel is now going to be my computer lecture room Thanks for the good work looking forward to having greater heights in the field of ICT

This was a long-awaited tutorial. Thank you Kevin!

@KevinStratvert

3 жыл бұрын

Glad to finally deliver it after such a long wait!

I have a interview tonight , have never used Access before ....Nw after 31 mins i feel i can convince anyone that i have months of experience in access... Thanks kEV...

I like this overview so I can actually get started in 30 minutes. Exactly what I needed. Thanks.

Great tutorial and even for the people who know how to use MS Access it is a good reminder of keeping it simple. I only miss the warning of filling in the id number. In this way it is very easy to fill in a duplicate order ID and maybe a duplicate customer ID too

You are simply amazing Kevin. I've become more valuable and productive on my job based on what I've gleaned from watching your videos. Thanks for sharing 🙏

Thank You, Mr. Kevin, for this Amazing Video. Please make a video on "How we can use MS Access online together collaborating as a team?"

For someone that has been out of the IT business for over 20 years, your beginner tutorial was so helpful at remembering what I used to do decades ago. Thank you so much!!

Kevin, you are the man. From my deep heart I really want to thank you very much for these efforts - much appreciated, good man. Please, keep on doing these amazing tutorials

Love it mate! Short and Simple and covered everything in less than 30 mins. Absolutely brilliant!!!

@karthiksidharth8314

2 жыл бұрын

31 mins

6:28 - Fields in Access = Columns in Excel Records in Access = Rows in Excel 11:48 - The field of "Customer_ID" is also refered to as a primary key. A primary key is a column designated to uniquely identify a table record.

Thank you Kevin. I got a lot out of this! The pace was great. It was super clear and easy to understand!

This was so fun and easy! I haven't had to use Access since I learned it some 20 years ago. Thank you for making it so easy to follow.

Excellent introduction! I am a programmer who works with databases on daily basis but this time needed something simple for my personal task. Your course answered all my questions in 30 minutes! Thanks a lot.

@rhondarobinson3443

2 жыл бұрын

Can i learn something from you?

@gordonsh24

2 жыл бұрын

@@rhondarobinson3443 I am not MS Access expert but I can answer some general DB questions if you like.

Very well done, completely cleared up the basics for me, thank you so much

Thanks Kevin. This video is quite simple and easy to understand. I previously thought it was so hard but now, I know better. Thank you.

I have an important exam for graduation where I need to get 70% to graduate. It includes understanding the basics of access. Hopefully you and your video pulls me through it.

This was a great training video for a true beginner. Thank you very much for taking your time to make this video. It helped me tremendously. More tutorials for importaing data and other Access functionality would be great.

I need to watch this video one more time. And then I’m ready. Thank you, Kevin.

Great video, helped me decide to buy microsoft for business rather than just personal since business includes microsoft access. I've used all sorts of database solutions and EBS stuff (SAP, oracle EBS, even stuff like quickbooks etc) at various jobs but it looks like I can get much of this core functionality for incredibly cheap using access! Perfect for a new small business just starting out. Thank you!

Access is good for building forms/reports to front end SQL Server databases. I think this is great I hope it encourages people to stop using excel to manage data. Not the best tool for the job

Really solid introduction and also refresher. Hope you go on to do some slightly more advanced MS Access topics, like follow-ups to this great introduction. Thank you, sir.

@Chris-qq6nj

Жыл бұрын

Did he?

Wow thanks for the simple and clear walk through! I feel like I have a good start now to create my own databases with Access!

This has helped me like crazy! I got dropped into my current position with little to no help learning how to track certain Data we need and this just saved my life and possibly my job :D I now know how to use Access Database better than the people over in IT!!😆

This video is so helpful! Tomorrow is my computer exam and I didn't know anything regarding MS Access! But now I do!

@theskullcrusher2753

Жыл бұрын

sameeee bro like one vdo is enough and 15 marks are in the bag

@SamStuffs0

Жыл бұрын

I am Having Problem when he jump 25:27 to dataview sheet,, my access says - TYPE MISMATCH IN EXPRESSION. What should i do ??

@khadeejanoma7888

Жыл бұрын

@@theskullcrusher2753 SAME DUDE

Excellent tutorial! Concise, to the point, and well organized. Very non-threatening for someone such as myself, who's tech experience is limited.

This is just what I need to track my customers! Thank you. I am starting a little late, but once I catch up with inputting my data, I will be so organized! Thank you!!!

I don't know how, but this guy makes a seemingly boring topic exciting.

18:00 MIND = BLOWN. I always thought constructing these nice ER diagrams was some sorcery that you need special software for, but you can actually build these with a few clicks in DBMS tools like Access. Very interesting - thanks Kevin!

Very good introduction to Access. Well done, sir. :)

Next week Im starting on a new workproject. This gives me the edge to be well prepared and have a good edge. I already found a solid book in the library but these types of knowledge is best to learn when practicing. Thank you so much!

Just starting to learn Nursing Informatics and this was very helpful as my classes are online. Thank you for taking time to create this video

You literally covered whole 3 topics of my book

I’m just ready for you to provide us with a tutorial on how to make amazing cookies

@stuartbrown3859

3 жыл бұрын

Totally agree. Kevin enough talking about it

@KevinStratvert

3 жыл бұрын

I seriously have this on my list. It'll land sometime soon 😂

@lhommedieu5489

3 жыл бұрын

Funny , Ive watched probably 20 of these videos; I thought the company was a front to have something to talk about to make the samples for excel, other ms programs. It looks like a real thing. Pretty cool. And if the data are real, i bet he makes a fair bit more than he did at MS... good on ya, bud!

@Jj-rq9sp

2 жыл бұрын

@@lhommedieu5489 😂 I may very well be wrong but I think you are right that the cookie company is an example. But we like hear him talking about it so much he might decide that maybe he should/could give it a go.