🏫 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/
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!!!!!!!!
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! 😍🥰
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!
heey excellent tutorial! i loved the way you explained each step in a clear and simple manner. access may seem complicated at first, but i want to use it because i just bought a new computer and i've already set it up 100%, i just needed to learn how to use access thankss Kev!
Hi Mark! I recently found a product key for Office from a website called BHN Software, and it worked perfectly for me. Thought you might find it useful too!
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!!
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!👍
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 🤩🤩🤩🤩🤩
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!
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
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!
Thank you for saving me ! working on a project and my professor is having us teach ourselves! you saved me so much time and stress, its a shame that my professor can not explain the material as well as you did. thank you thank you thank you !
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!!!
Thank you Mister Kevi Statvert, This video taught me the reality of Microsoft access. It was lying around in my computer, and this helped me go through it very efficiently . This also prepared me for my practical computer IT exam tomorrow. Again, Thankyou Mister. Kevin Statvert💻
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!
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 TH-cam. Thank you!
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!
Thank you so much, This video helped a lot, I have a test tomorrow on MS Access, My teacher has been teaching this for 3 hours collectivly but I still could not understand clearly. Thank You !
I am an estate manager. I intend to use Google sheet or Excel to fill in tenant details. My boss recommended MS Access so that different tables can be created for different estates. I thought within me "what an archaic software to use". I only know how to use Sequel not Access. That's the only Office package I didn't care to learn. But watching Kelvin's video now, I'm already in love with the package.
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
i really appreciate this study tutorial, kindly take me through creating specific table to track orders for a full a month, per individual but within the same table and well the table showing dates
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 🙂
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.
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!
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.
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
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!
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...
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 so much for the video. I always wanted to see how you can use Access. No video in this world was briefly explained except this video. Learnt a lot and now I think I am gonna start loving access just like the way I love PowerPoint. You are such a great person. Also for the first time I have heard Kevin saying "Hey Everyone Kevin Here" instead of "Hi Everyone Kevin here". 1000 thank you's from me. :)
I think he said *Hi Everyone Kevin here* a lot of times! Probably your not an OG in his channel! I am watching Kevin for about 5 years! I wish to be Kevin JR for now!
@@SavageGothamChess Okay.. So the thing is I am into technology since 3 I use to type on my dad's laptop I use to play songs myself! Which gave me an interest in tech! My dad himself is very good at tech! So it makes sense even if I watch from 6!
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.
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.
@@KevinStratvert It looks so good! Really cool work Kevin. I have been trying to learn adobe premiere, but maybe I will have to try out DaVinci as well :)
@@TylerStanczak Ikr! But the thing is Adobe Premiere Pro costs money! And which might be a little disappointing thing! But well Davinci offers all the main editing stoof! Well, I prefer Davinci! But 1 caveat is it takes tooooooooooo much space! Which just lags my PC :(
This video is just what I was looking for! I have taken many comp sci courses but my last class, which was an intro to bioinformatics, did not cover this software. I have a new opportunity for work and I need experience with Access and this video was so helpful. Just the right amount of detail, loved the examples. Thank you so much.
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 :-)
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 ;-)
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.
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.
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!
@@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.
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.
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
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!!
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
Great intro to Access, Kevin. And it'll work fine provided you're willing to stay away from writing actual program code. But you're setting up people to have serious problems with field names if they decide to go deeper into programming in Access - with the underlying MS Office coding language, VBA (Visual Basic for Applications). As I'm sure you know, when referencing field names in your code you should make them easy to type in AND make their actual data type recognizable within the code. Putting spaces in field names, for example, creates problems. The 'space' in the field name "Customer ID" you created would create problems for the built-in compiler. A better strategy is to use common linking characters (like we used to have to do in DOS or Windows file names). So simply using "Customer_ID" as the field name will make coding MUCH simpler. Also, it's useful to use a prefix to imply the data type. I use lower case single letters. But many programmers use three lower case letters, which gives you even more flexibility. I use n (numeric), s (string [straight text]), lower-case l (logical - yes/no) etc .... So, the numeric customer ID field name would then by "nCustomer_ID" (I'd probably just use "nCustNum" or "nCustID"). I recognize there's no real need to do this at the level you're starting at. But if you want to build a real-world useful system in Access you're likely to want to branch out into VBA at some point. So best to start off on the right foot to avoid having to rewrite the whole application (database) again. Using field names like you've done results in queries written like this: SELECT Customers.[Customer ID], Customers.[First Name] FROM Customers WHERE (((Customers.[Customer ID])=1) AND ((Customers.[First Name])="Fred")); Note the [ and ] brackets that must be used each time you try to reference a field. Using the fields nCustID and sFirstName instead makes the same query a lot easier to read; and makes code much easier to write - SELECT tblCustomers.nCustID, tblCustomers.sFirstName FROM tblCustomers WHERE (((tblCustomers.nCustID)=1) AND ((tblCustomers.sFirstName)="Fred")). AND, you can tell immediately what KIND of data type each field is. Note: I also used the prifix "tbl" to identify the data table, too. This will then distinguish it from other Access objects like queries (qry), forms (frm), reports (rpt) etc. Otherwise you can end up with a table named Customers, a query named Customers, a customer form named Customers and even a report named Customers. So which one is being referenced when you simply code using the name Customers? Very confusing! Much better to use some kind of identifier in your naming to distinguish the object type.
Great video as usual Kevin. I love everything about all your videos. Quality content, great editing, different chapters and all those little details. Keep making these videos !
MY goodness, I'm an old man that learned how to use MS Works, an old suite of tools, including databases. I still use it to this today to keep track of my non-profit for our memberships and subscriptions. MS Works is basic, basic basic. Great for this old man. I've tried using my MS Access program the past 10 years but could never figure out how to make it work as easily as it's been using Works. I'm going to try again. The big thing I see are the new terms, not in Works, like Query. Forms were always my biggest Waterloo, as I wanted to create a form at the beginning of Access. I think I see now that I need to create the different tools of Access in a certain order and the other options, like forms then appear in the menu, but not until? It's been really hard for this old dog to learn new tricks. I'm retired now, so I'm going to give it a go. I googled searching for a tutorial on converting an existing Works database into an Access database so that I didn't have to do all the adjusting, creating, etc. etc., but it looks like that kind of a cool wizard does not exist. Help me lord, here I go.
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.
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!
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.
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.
I have an exam in less than 12 hours, and just 2 days ago, my school suddenly decided to use MS Access in our exam, a software I've never even heard of, and don't have access to at home. Hoping this video will at least make me somewhat less hopeless for the database portion of the exam, thank you so much for making a concise and easy to understand video
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.
Thanks for this video Kevin! I use MS Access a lot and have done for years. It’s so powerful, I’ve been using it to transfer data from a website to a desktop accounts software and much more. But do you have any thoughts on the future of Access? I keep hearing rumours that it might go away at some point.
I have used Access, as an enthusiast, for over 20 years. It’s truly a powerful shell for SQL application in general, if you commit to understanding the principles underlying principles of SQL, Because it hides the principles of SQL and added forms and reports. I am not related to Microsoft in anyway, or any other software, but from what I’ve read, Access intentions was originally designed to kill the other larger SQL products, in favor of bringing data to the personal desktop. You could call it the era of the database wars. This was before Microsoft SQL was developed, or before Microsoft SQL had a place in the backend office, owned by the big 3 database companies. Once Microsoft SQL took off and penetrated IT’s back office. Microsoft lost interest in developing Access as a personal desktop database, for the front end. Basically, Access was designed to be a backend killer, owned by IBM, Oracle and Sybase, before they had a place in the IT backend. Now that they have won over the backend with Microsoft SQL, they lost interest in Access and it’s market objectives. This is my opinion from what I’ve read. I encourage you develop your own opinion based what you’ve read. The rumor of it might be going away has been around for years... But then again, Access has no real competition for personal desktop databases.
@@rajarorauk Hi Guys, Can you suggest me if i can use access to create a form which can me used by different people to add details and then anothe staff to acknowledge or approve that. Also, the creator and acknowledge could only see the data added by them not by others
Hi! How do you store a database in Microsoft 365? I heard that it isn’t recommended to store access files in SharePoint. But instead store the database in SharePoint lists. Does that remove functionality or does it work the same, even wth more complex access databases?
Hi @Kevin do you think that MS Access is still worth learning giving the other types of databases? One of my colleagues said its becoming redundant now
I am not related to Microsoft in anyway, but from what I’ve read, Access intentions was originally designed to kill the other larger SQL products, in favor of bringing data to the personal desktop. This intention was before Microsoft SQL was developed, or before Microsoft SQL had a place in the backend office. Once Microsoft SQL took off in the backend. Microsoft lost interest in developing Access as a personal desktop database, for the front end. Basically, Access was designed to be a backend killer, before they had a place in the IT backend. Now that they have won over the backend with Microsoft SQL, they lost interest in Access. This is my opinion from what I’ve read. I encourage you develop your own opinion based what you’ve read.
![Hands-On Power BI Tutorial 📊Beginner to Pro [Full Course] ⚡](http://i.ytimg.com/vi/5X5LWcLtkzg/mqdefault.jpg)
🏫 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/
Dear Kevin, do you have an video that covers the advance level?
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
😊😊😊😊😊😊😊😊😊
Help please I'm confused , in the field of revenue per cookie, what does that mean exactly?
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!!!!!!!!
Mine couldn't trach me in months 😅
😅😅😅😅 good one
I have also a test tomorrow
I also have a test tomorrow to
I felt this.
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! 😍🥰
and 2x speed 15.5 minutes ;)
Absolutely.
Sure sure. I need your email Kevin
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?
npc
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!
I agree
I love u Kevin
Yep, just subscribed to the channel.
heey excellent tutorial! i loved the way you explained each step in a clear and simple manner. access may seem complicated at first, but i want to use it because i just bought a new computer and i've already set it up 100%, i just needed to learn how to use access thankss Kev!
Dude one question, how did you set up access? I also have a new computer but I don't understand how to get the product keys for Office
Hi Mark! I recently found a product key for Office from a website called BHN Software, and it worked perfectly for me. Thought you might find it useful too!
@@countrymanWayne you save me! I bought it and It's working perfectly for me, thanks!
Thanks, well understood
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.
I feel confident enough to call this TH-cam channel ''Kevin University." Thanks, Kevin.
😢
Hmm
Kevin cookie university
Literally, my uni in introducing us to databases through Ms access and he explained it way better than the lecturer did
I agree with Dave’s comment👌
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!!
Likwise. Gone through many videos but this one is by far the best presented
@@markheathcote9420 how to download access
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!👍
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 🤩🤩🤩🤩🤩
❤
would love to learn from your experience.
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!
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
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.
Yes indeed, we need more on importing data.
After viewing, I feel READY to get started with Access ~ Breathe of Topics & Consise Information make this video a Winner!
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!
I agree! Keeping my eye on this!
Great job. Example of importing antiquated Excel file into data base would be great.
Thank you for saving me ! working on a project and my professor is having us teach ourselves! you saved me so much time and stress, its a shame that my professor can not explain the material as well as you did. thank you thank you thank you !
WOW! In half an hour I have learnt so much than what I was thought in college several years ago. Thank you Kevin
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!!!
I was so nervous about my interview as an analyst but your videos gave me the refresher and confidence I needed! Thank you!
How’d it go ? 😅
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.
Thank you Mister Kevi Statvert, This video taught me the reality of Microsoft access. It was lying around in my computer, and this helped me go through it very efficiently . This also prepared me for my practical computer IT exam tomorrow. Again, Thankyou Mister. Kevin Statvert💻
Today is my computer practical exam and thanks to you for saving my life
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!
You saved me on my final project for college. Thanks man.
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 TH-cam. Thank you!
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.
This is excellent! What an amazing teacher you are. In just 31 minutes, it is like a whole package taught.
Very good introduction to Access. Well done, sir. :)
Thank you so much, This video helped a lot, I have a test tomorrow on MS Access, My teacher has been teaching this for 3 hours collectivly but I still could not understand clearly. Thank You !
I am an estate manager. I intend to use Google sheet or Excel to fill in tenant details. My boss recommended MS Access so that different tables can be created for different estates.
I thought within me "what an archaic software to use". I only know how to use Sequel not Access. That's the only Office package I didn't care to learn. But watching Kelvin's video now, I'm already in love with the package.
You have made Access look so simple and easy! Thank you so much for this excellent tutorial Kevin : )
Wow! Really good tutorial and encouraging to get started! Concise, informative, and simple. Well done!!
Thank you, Kevin! Can you go more into detail regarding queries, forms and reports? MUCH appreciated!
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
i really appreciate this study tutorial, kindly take me through creating specific table to track orders for a full a month, per individual but within the same table and well the table showing dates
This video is so helpful! Tomorrow is my computer exam and I didn't know anything regarding MS Access! But now I do!
sameeee bro like one vdo is enough and 15 marks are in the bag
I am Having Problem when he jump 25:27 to dataview sheet,, my access says - TYPE MISMATCH IN EXPRESSION. What should i do ??
@@theskullcrusher2753 SAME DUDE
This was a long-awaited tutorial. Thank you Kevin!
Glad to finally deliver it after such a long wait!
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 🙂
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.
Thank you so much. Not only the tutorial ,but the fact you didn't use 50 ads in your video.
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!
I like his voice as well.
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.
So how are your early career years going?
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
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!
Kevin, you're the very best! Thank you!❤
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...
So, how did it go?
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 so much for the video. I always wanted to see how you can use Access. No video in this world was briefly explained except this video. Learnt a lot and now I think I am gonna start loving access just like the way I love PowerPoint. You are such a great person. Also for the first time I have heard Kevin saying "Hey Everyone Kevin Here" instead of "Hi Everyone Kevin here". 1000 thank you's from me. :)
I think he said *Hi Everyone Kevin here* a lot of times! Probably your not an OG in his channel! I am watching Kevin for about 5 years! I wish to be Kevin JR for now!
@@SavageGothamChess Okay.. So the thing is I am into technology since 3 I use to type on my dad's laptop I use to play songs myself! Which gave me an interest in tech! My dad himself is very good at tech! So it makes sense even if I watch from 6!
@Nice Boy IK man! But still "Hi Everyone Kevin Here is in his channel"
@Nice Boy WDYM how will IK! Well that's still a fantastic achievement Nice Boy
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.
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
my college professor made us watch this instead of teaching it himself to the class.
A lot of classes are like that😂😂😂
@@juhgfdsapiyhhnnxc3517 yeah I know, a lot of my classes were like that not just the one. Just sucked.
REAL
Same
This guy is good. He may be better than the teacher LOL
Thank you Kevin!! Your videos are helping me so much to pass my database and computer information systems courses 😊
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.
Can i learn something from you?
@@rhondarobinson3443 I am not MS Access expert but I can answer some general DB questions if you like.
I like this overview so I can actually get started in 30 minutes. Exactly what I needed. Thanks.
Thank you, thank you, thank you!!! You are easy to understand, clear & concise! I've learned soo much already!!!
do you have 0417 paper 2 today? cus i do. my finals.
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?"
oh snap! that intro though! 😎 Love the microsoft access tutorial.
Exactly!
I've been getting my hands dirty with Fusion in DaVinci Resolve and I'm loving it 😁
@@KevinStratvert It looks so good! Really cool work Kevin. I have been trying to learn adobe premiere, but maybe I will have to try out DaVinci as well :)
@@TylerStanczak Ikr! But the thing is Adobe Premiere Pro costs money! And which might be a little disappointing thing! But well Davinci offers all the main editing stoof! Well, I prefer Davinci! But 1 caveat is it takes tooooooooooo much space! Which just lags my PC :(
Thank you so much Kevin. A very informative, organized, and easy to understand explanation.
This video is just what I was looking for! I have taken many comp sci courses but my last class, which was an intro to bioinformatics, did not cover this software. I have a new opportunity for work and I need experience with Access and this video was so helpful. Just the right amount of detail, loved the examples. Thank you so much.
apply for intern and they required some knowledge regarding this data base and you help me understand it so much ! thank you so much !
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.
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 :-)
Really like your instruction style: fast, practical and concise. 👌
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
The tutorial is straightforward, clear and easy to understand.
thank you 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 ;-)
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.
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!
More surprisingly how does Access manage to allow more than 1m rows 😳
As an absolute beginner, I loved this tutorial. So, thank you so much Kevin !
From not knowing anything about Microsoft Access to knowing everything through this video, it was very helpful!
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.
I’m just ready for you to provide us with a tutorial on how to make amazing cookies
Totally agree. Kevin enough talking about it
I seriously have this on my list. It'll land sometime soon 😂
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!
@@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.
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.
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
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!!
more videos about Access please
Let me know what other topics would be helpful. Cheers!
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
Excellent tutorial! Concise, to the point, and well organized. Very non-threatening for someone such as myself, who's tech experience is limited.
i really enjoy your lesson your the best teacher here on TH-cam i rate you 5 stars
The way you explained every part, is very rare to find in other tutorials. Keep up the good work man❤❤
Great intro to Access, Kevin.
And it'll work fine provided you're willing to stay away from writing actual program code. But you're setting up people to have serious problems with field names if they decide to go deeper into programming in Access - with the underlying MS Office coding language, VBA (Visual Basic for Applications). As I'm sure you know, when referencing field names in your code you should make them easy to type in AND make their actual data type recognizable within the code.
Putting spaces in field names, for example, creates problems. The 'space' in the field name "Customer ID" you created would create problems for the built-in compiler. A better strategy is to use common linking characters (like we used to have to do in DOS or Windows file names). So simply using "Customer_ID" as the field name will make coding MUCH simpler.
Also, it's useful to use a prefix to imply the data type. I use lower case single letters. But many programmers use three lower case letters, which gives you even more flexibility.
I use n (numeric), s (string [straight text]), lower-case l (logical - yes/no) etc ....
So, the numeric customer ID field name would then by "nCustomer_ID" (I'd probably just use "nCustNum" or "nCustID").
I recognize there's no real need to do this at the level you're starting at. But if you want to build a real-world useful system in Access you're likely to want to branch out into VBA at some point. So best to start off on the right foot to avoid having to rewrite the whole application (database) again.
Using field names like you've done results in queries written like this:
SELECT Customers.[Customer ID], Customers.[First Name]
FROM Customers
WHERE (((Customers.[Customer ID])=1) AND ((Customers.[First Name])="Fred"));
Note the [ and ] brackets that must be used each time you try to reference a field.
Using the fields nCustID and sFirstName instead makes the same query a lot easier to read; and makes code much easier to write -
SELECT tblCustomers.nCustID, tblCustomers.sFirstName
FROM tblCustomers
WHERE (((tblCustomers.nCustID)=1) AND ((tblCustomers.sFirstName)="Fred")).
AND, you can tell immediately what KIND of data type each field is.
Note: I also used the prifix "tbl" to identify the data table, too. This will then distinguish it from other Access objects like queries (qry), forms (frm), reports (rpt) etc. Otherwise you can end up with a table named Customers, a query named Customers, a customer form named Customers and even a report named Customers. So which one is being referenced when you simply code using the name Customers? Very confusing!
Much better to use some kind of identifier in your naming to distinguish the object type.
You literally covered whole 3 topics of my book
Great video as usual Kevin. I love everything about all your videos. Quality content, great editing, different chapters and all those little details. Keep making these videos !
Much appreciated!
@@KevinStratvert Please I need MS Excel for complete beginners.
Thank you, your Excel teaching was good. Now I am following Your Access
MY goodness, I'm an old man that learned how to use MS Works, an old suite of tools, including databases. I still use it to this today to keep track of my non-profit for our memberships and subscriptions. MS Works is basic, basic basic. Great for this old man. I've tried using my MS Access program the past 10 years but could never figure out how to make it work as easily as it's been using Works. I'm going to try again. The big thing I see are the new terms, not in Works, like Query. Forms were always my biggest Waterloo, as I wanted to create a form at the beginning of Access. I think I see now that I need to create the different tools of Access in a certain order and the other options, like forms then appear in the menu, but not until? It's been really hard for this old dog to learn new tricks. I'm retired now, so I'm going to give it a go. I googled searching for a tutorial on converting an existing Works database into an Access database so that I didn't have to do all the adjusting, creating, etc. etc., but it looks like that kind of a cool wizard does not exist. Help me lord, here I go.
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.
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!
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.
Did he?
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.
I have an exam in less than 12 hours, and just 2 days ago, my school suddenly decided to use MS Access in our exam, a software I've never even heard of, and don't have access to at home. Hoping this video will at least make me somewhat less hopeless for the database portion of the exam, thank you so much for making a concise and easy to understand video
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.
Thanks for this video Kevin! I use MS Access a lot and have done for years. It’s so powerful, I’ve been using it to transfer data from a website to a desktop accounts software and much more.
But do you have any thoughts on the future of Access? I keep hearing rumours that it might go away at some point.
I have used Access, as an enthusiast, for over 20 years.
It’s truly a powerful shell for SQL application in general, if you commit to understanding the principles underlying principles of SQL,
Because it hides the principles of SQL and added forms and reports.
I am not related to Microsoft in anyway, or any other software, but from what I’ve read,
Access intentions was originally designed to kill the other larger SQL products, in favor of bringing data to the personal desktop.
You could call it the era of the database wars.
This was before Microsoft SQL was developed, or before Microsoft SQL had a place in the backend office, owned by the big 3 database companies.
Once Microsoft SQL took off and penetrated IT’s back office. Microsoft lost interest in developing Access as a personal desktop database, for the front end.
Basically, Access was designed to be a backend killer, owned by IBM, Oracle and Sybase, before they had a place in the IT backend.
Now that they have won over the backend with Microsoft SQL, they lost interest in Access and it’s market objectives.
This is my opinion from what I’ve read. I encourage you develop your own opinion based what you’ve read.
The rumor of it might be going away has been around for years...
But then again, Access has no real competition for personal desktop databases.
@@geekmeee I love Access, and I hope there's enough of us to stop Microsoft taking it away any time soon.
@@rajarorauk Hi Guys, Can you suggest me if i can use access to create a form which can me used by different people to add details and then anothe staff to acknowledge or approve that. Also, the creator and acknowledge could only see the data added by them not by others
Thanks Kevin! amazing tutorial, I hope to see more of MS Access in the future.
Let me know what else you'd be interested in. Cheers!
I loving and easy to understand because you explain it in a very simple way
Thanks for this video! I built tables and I finally got my first query to work. Now I need to perfect it for the stuff I really want to know. 🙏
Hi! How do you store a database in Microsoft 365? I heard that it isn’t recommended to store access files in SharePoint. But instead store the database in SharePoint lists. Does that remove functionality or does it work the same, even wth more complex access databases?
12:50 "This will allow you to ACCESS this database." That reminded me of when characters in movies say the movie's name 😂
Hi @Kevin do you think that MS Access is still worth learning giving the other types of databases? One of my colleagues said its becoming redundant now
I am not related to Microsoft in anyway, but from what I’ve read, Access intentions was originally designed to kill the other larger SQL products, in favor of bringing data to the personal desktop. This intention was before Microsoft SQL was developed, or before Microsoft SQL had a place in the backend office.
Once Microsoft SQL took off in the backend. Microsoft lost interest in developing Access as a personal desktop database, for the front end.
Basically, Access was designed to be a backend killer, before they had a place in the IT backend.
Now that they have won over the backend with Microsoft SQL, they lost interest in Access.
This is my opinion from what I’ve read. I encourage you develop your own opinion based what you’ve read.
it's still SQL. MS Access is gui on top of SQL. its the same structure. Just learn SQL
@@jasonreviews thanks
Thanks so much! This is the best beginners Access video I've seen! It is very helpful!
Kevin you ar truly a life saver. All I'm going to say is THANK YOU!!! ❤❤❤❤❤