Microsoft Access 2010 Tutorial Part 01 of 12 - Database Terminology

[@599CD]

Thank you for the compliments, the feedback, and the business! I really appreciate it. People like you are why I do what I do... and post free lessons here on KZbin for all to enjoy. Thanks for your support.

[@Rampage514]

I m a Desc 200 student and thanks to you I have learned everything the easy way. You are a professional tutor. Thank you so much.

[@Excel1949]

I am studying for my specialist certification, completed Wiley softward - now I am getting from these videos outstanding information, thank you, George

[@truthsetsufree]

This video is great for helping someone with no Access experience. You explain very clearly and precise, thank you!

[@599CD]

You're very welcome

[@599CD]

Thank you. As an American, I actually like listening to people with a British accent. It just sounds so much more intellectual. However I do know what you mean... I often check out video tutorials from other people here on KZbin and a LOT of them put me to sleep too... so I do my best to keep mine entertaining. :)

[@AgronaP]

I greatly appreciate thesse videos! I just got a job as a receptionist, and although I had used several MS programs before I hadn't even hear of Access let alone Access 2010. As a result, after my boss had told me I was going to need to be more then adept at this program, I went online searching, and these are the best videos I have found! Keep up the good work mon ami, I'm sure there are others like me out there.

[@RainStormfront]

These tutorials are good for me since I seem to learn better from lectures? I appreciate the fact that I can access them for free via KZbin. Thank You.

[@599CD]

welcome

[@bboreta4538]

Finished watching the Beginner Tutorials; absolutely love them: The videos are broken down into small,"digestible" categories. Easy to follow, easy to understand. I already purchased "Beginner Part 2" via the 599cd.com website and watched some: great value for money!

[@AnnieVonBraun]

Thank you for posting these videos! My father owns a business and as his secretary I'm always trying to keep him organized. This is very helpful!

[@Knoxxe]

this is 2313021310x better than my university course that i spend 500$ on. Thank you

[@599CD]

Welcome

[@parinthon]

Thank you very much. This is the first time ever that someone can get my brain accessed to the Access. Really Thank you. King.

[@599CD]

Thanks for the comments. I know that people who are familiar with Access already might find the tutorial too basic at times... but it's supposed to be a beginner tutorial for people with little or no experience with Access. My more advanced lessons don't cover the basics in this much detail.

[@nthphillycoach]

This helped me get a data analyst career. I had no experience with data bases and got the job based on what I've learned here.

[@moppet17]

Thank you so much for providing free information. This helps so much, especially for people like me who just want to know how something works without having to go to paid programs that teach less than what's available on your videos! Again, my many thanks to you! :)

[@DavidMcard]

This is the best introduction to ms access I've ever had.

[@599CD]

I appreciate that. Thanks! The 2013 one is better: 599cd.com/AC2013B1

[@81siddharth]

Dear Sir, I am from India ... this is so much helpful to us to learn Ms Acess really so much thankful to you for updating us you are Great !!!!

[@jdac22]

Thank God for KZbin!

[@Exceltrainingvideos]

Excellent introduction to MS Access! Thank you!

[@nadaaflaki2333]

I learned from your tutorial a lot, professional and the best instructor. Thank You.

[@PapaOhome]

Expanding/reviewing my basic Access knowledge, as our Community College Business dept. has arganized a new class based on Access and Excel, and dropping Word, and PowerPoint from the particular course. I did Part 1 just now, lots of tidbits that I didn't know, nice concise definitions, and key information. I will be going through all 12 of your tutorials, so i can push for a section of our new course. -- Adjunct Faculty for Business/Computer Science, Joe

[@599CD]

Glad you enjoy them!

[@Smokiyama]

I learned more in these few videos about Access than I ever did in my weeks of Database classes in school. Thanks, these are very helpful.

[@599CD]

Thank you. I'm glad you enjoyed it.

[@599CD]

I get asked this a lot. It's not for beginners. You can make a message appear on your startup form pretty easily, but anything like this involves a little bit of programming - either a macro or some VBA. I'll be making a TIP video on how to do this soon. It's on my list.

[@Lomaxient]

Excellent Part 1!! Clear and Precise. 10/10 so far.

[@599CD]

My pleasure

[@kkhendricks73]

Thank U for having this!! I just got a new job and I have this weekend it get this information. Thank You for not charging!!

[@rookieakan3410]

Hello there, I watched your video, I followed everything you say in you video, and found out that I understood it after it ended. Thankyou, I feel like a professional database person now.

[@599CD]

My pleasure

[@599CD]

Yep. It's very easy to import your Excel data into Access tables, provided the data in Excel is in a "database-friendly" format (rows and columns all match up).

[@599CD]

You're very welcome. I've got paid tutorials available as well (on my web site) but I try to give people a good, solid foundation with my free course here on KZbin. Then they can decide if they want to move beyond the basics.

[@599CD]

Awesome! I'm glad I could help.

[@599CD]

Yes. Excel is good for managing small amounts of data, or for analyzing data (charting, etc.) but once you get into bigger sets of data (hundreds of records/rows) then you really want to move up to Access. Importing data from Excel into Access is real easy.

[@scramm415]

This is fantastic information! I have been tasked with building a database to track insurance certificates by job and then by consultant. I think I can do it thanks to these videos! Can't thank you enough.

[@599CD]

You're welcome

[@ehsanjanahi]

Long time I wanted to learn Access. First video was easy and very clear. Let me see the second one :)

[@599CD]

Wow. I'm so glad to hear that. That's awesome.

[@gmpapad]

these lessons are a lot useful!One thing you could add are english subtitles,this will surely help your non native-english viewers to understand more!still,that's a great work!

[@599CD]

Awesome. Glad to hear that.

[@IsItOverYet]

Excellent tutorials! Thank you, thank you, thank you.

[@hehe8067]

!

[@599CD]

Alison has a lot of great tutorials on their site. You'll find, however, that my advanced tutorials go into a lot more depth than you'll find anywhere else.

[@599CD]

You're very welcome.

[@VJBlues]

Thank you. I am going to use Access very soon, and my knowledge is limited to Excel.. Thank you for providing this FREE training.

[@nuramahemarafa854]

Excellent! Very professional presentation, Thanks

[@599CD]

There are several different ways to handle this. I would use 1 table to track the radios, and a 2nd table to track the transactions of each radio. You could then use domain functions like DLOOKUP to see if a particular radio is available.

[@599CD]

Sorry to hear that. I love Access.

[@dopplerking91]

dude. you got me a career. thank you so much

[@uthramurari2678]

This video is amazing...hats off...great job...

[@dilipmandal6835]

Thanks a lot to teach Access 2010 to a layman. Best wishes to you friend. This is the best video!!!!!!!!!!

[@599CD]

Welcome

[@PaulaJamesHandiCraft]

Very professional presentation and easy to understand. Thank you and well done. This is lot of work and time invested in these video-tutorials. And, yes, of course, I am your subscriber, I would not miss this opportunity:)

[@AsiaFloydStar]

Haha, I also wanted to comment on the language - I do prefer British accent though and I get goosebumps when I hear 'innerface' (interface) or 'cenner' (center), but I must admit there is something about the US English- it's definitely more dynamic than UK Eng. ;) Nevertheless, the tutorial is just great! Sometimes too basic (all those 'change the folder clicking this little icon'-like instructions, but I guess it's better this way than the other.),but I do appreciate the course! Thanks a lot :)

[@jayvillasenor228]

Thank you man =) This helped me a lot in my job! Looking forward for more and free tutorials =) Thank you again.

[@michaelbotalon9024]

Thanks a lot for sharing videos it help me a lot. Thank you for being always a blessings to other.

[@ElismyJudge]

Thanks for the easy to understand explanations. Good job :)

[@ortwell1]

Just wanted to say THANK YOU !!! I have never used access before, and your tutorials are incredibly useful!

[@AnnetteMurphyger]

Thanks so much for this. I am a tutor, but do not have much experience of teaching Access to Adult learners, so this is ideal for my purpose!

[@599CD]

My pleasure

[@endimion84]

I've been following access tutorials for some time and yours are top notch, very precise in your explanations. Thanks.

[@bradwelch6714]

I'm going to school right now for Business and Accounting and one of the classes we will have is database management which uses Access. So i'm trying to get a little head start. I'm going to look for Publisher tutorial too. We haven't had that as a class yet.

[@tuanmanhvo]

I love your work. i really appreciated your video.

[@599CD]

I hope you did well on your exam. You don't NEED to have Access on your PC in order to learn how to use it. You could just watch my videos and try to remember everything, but it really, REALLY helps if you can build the database along with me.

[@599CD]

You're welcome.

[@jdivergh22]

Thank you for the tips! I just looked this up for my new job. Helped a lot!

[@AsiaFloydStar]

Oh, I'm not familiar with Access either, the things I had in mind were simple windows OS features, but as I said, it's better to make it more basic than too advanced. I am on part 4 now, still enjoying it :) Thanks again :)

[@599CD]

Thank YOU.

[@599CD]

Thanks.

[@599CD]

If you use a combo box then the field will autocomplete if the value is already in there. I cover combo boxes in my Access Beginner Level 8 course.

[@599CD]

I'm 100% self-taught. I learned mostly through books and trial 'n' error. I've been using Access since the early 90s, so I've had plenty of nights struggling with it, pulling my hair out. Hopefully I can prevent some of you from having to do the same. :)

[@GarySinghFornewhomestoronto]

Very Useful I now don't have to worry about my data base Great!

[@Isse016]

Good teacher, we depend on you!

[@galriz2502]

my homieee i love this one... just clicked the subscribe and like button! keep up the good work man

[@599CD]

Thanks.

[@599CD]

Be sure to share my tutorials with your classmates and professor. :)

[@SamMicheck1]

I like your Lessons Great lessons, keep up I have learned many things in them

[@qarnma]

thanks a lot helpful and easy class with professional way

[@dahiyagamer2372]

you explain much better than any other i am from india and i love your explanation

[@599CD]

Thanks

[@BlueCamper2000]

It is easy for beginner to understand. Cool~

[@luanwei8323]

this is very helpful...thanks for your effort

[@sunilsatawlekar3972]

Excellent video series Sir! Nicely arranged topics, simple illustrations, clear commentary. It certainly could have been much better, but it serves its purpose. I'm following. Thanks.

[@599CD]

My pleasure

[@599CD]

I suppose in the BROADEST possible definition, a database is simply a collection of data. I believe I cover this in the tutorial. It can be a card catalog, a phone book, or SQL Server. Since this is specifically a Microsoft Access course, I've narrowed MY definition a little bit to just computer programs... but you're right. A database doesn't necessarily have to be a computer program.

[@TheChrisCoutu]

Good job! This helps up improve our skills. State Rep Chris Coutu

[@599CD]

Lo siento, no tengo nada en español en este momento, pero estoy mirando su traducción. Vuelve en unos pocos meses.

[@LittleDreamersBabyStore]

Well Done! I'm looking forward to seeing more. You are thorough in your explanation. Thanks for creating this video. :)

[@599CD]

Welcome

[@599CD]

Thanks. :)

[@morbidjesterface]

Nice video. I'm not sure if you cover this or not in your other videos, but what is the best way to track assets. Say you have 50 radios, and multiple outside sources borrow these radios for a specific time period. How would you implement a system that would show a specific radio cannot be used due to it being currently in use or reserved for a time period?

[@599CD]

I'll be releasing a Publisher 2013 class later this fall.

[@gauravdawg]

Excellent tutorials

[@abarkcanoe]

Taking the plunge to diversify from Excel! This is a well presented tutorial especially for absolute beginners like me. Hoping you’ll have one for Project. Thank you!

[@599CD]

Honestly, I get very few people asking me for Project. Access and Excel make up most of my business. Word, PowerPoint, and Windows a little bit too. I used to try to branch out with other apps like QuickBooks and Photoshop, but at the end of the day Access is what I do best.

[@OceanBluexp]

Very nice video! Thank you!!!

[@amywalkerartist]

You are very thorough, and I desperately need help with Access in my office. Would there be any way that you could help me? My issue is getting a form to print in the correct place on a dot matrix printer with continuous feed paper. The way it is set up right now, the page measurement is off, and the info never prints in the right place.

[@magikmarc]

Oh don't worry about my comment. You actually taught me access and it got me a job offer lol. But I was so stressed I just wanted to know what to do you were explaining each button. Even on the title bar and status bar lol. So helpful though

[@xiaoranliu]

Great lessions!!!

[@burbafa]

Really thank you for this video,

[@alaahamdy1516]

Great Efforts dude well done

[@599CD]

My pleasure, dude.

[@buyilawrence7813]

Good beginning Thanks

[@paulacidre]

this one is good...thanks a lot...

[@fredchege9909]

I am subscibing to this channel at the end of 2020. Damn! Where was I?

[@599CD]

No idea. I've been here all along. Missed you. Welcome home. :)

[@suhailelanattil3177]

excellent presentation. i am sure this video can provide greater assistance to those who wishes to work with access. thank you sir...

[@599CD]

My pleasure

[@AngelCruz-bl4pf]

thanks. nice tutorials...

[@FeistyJackball]

Good so far, thanks!

[@599CD]

Welcome

[@tjamante4274]

A VERY BIG HELP! THANK YOU

[@599CD]

You're very welcome.

[@notquiteyoung]

this video is so helpful!! i'm taking a course in computer softwares and applications and my exam is in two weeks!!

[@599CD]

How'd ya do?

[@makeitsimple2306]

good works thank you for all

[@bitchassmofo666]

nicely done sir!

[@LiquidSnake1988]

Do you have Tutorial with visual basic? or Would you upload one?