Microsoft Access 2010 Tutorial Part 03 of 12 - The Access Interface

[@599CD]

I've always believed that the best way to help yourself is to help others. By providing free training to folks here on KZbin, I only hope that a small percentage of people love my lessons enough to buy more. Thanks for the compliments.

[@massiusamerbud7653]

a member of IT just pulled a "f it i quit". this free lesson showed me enough to be able to fix a few very important payroll issues. It probably saved my job since im the only IT left. ive since purchased a few more lessons from your site. thank you very much.

[@599CD]

Of course they're not fake. I take great pride in knowing that my lessons here on KZbin have helped TENS of THOUSANDS of people.

[@TheAnimeStop]

Just thought that you should know that because of your videos I aced my exam which accounted for 1/3 of my overall grade. You sir, are a gentlemen and a scholar.

[@dianavarona3630]

I am going to a computer school and our professor uses your channel as a guide for what we couldn't understand in his class you both are great i believe if i take the rest of your videos i can do a great extra credit report thanks you guys rock cant wait to purchase your program

[@kanavukadhalan21]

You are probably the coolest online tutorial. No crap. No rubbish. Just step by step awesomeness.

[@599CD]

Haha. Thanks.

[@erking55]

I landed a job because of your tutorial, I appreciate it. I feel like I owe you half my salary but Im sure a thank you is enough. Thanks again.

[@lloydsutcliffe3479]

Been struggling with Access text books for the last week and was becoming more and more confused,thank you so much for the tutorials,As a beginner I have learnt more in 4 lessons than I have in a week of classes.Well done for keeping it simple,some of us have come to computers recently,and it drives me mad when people assume your familiar with the principals. Which I'd discovered you before doing Word and Excel!.

[@mikeoxbig4705]

I am learning so much. Microsoft Access has been out of my range. I find your tutorial educational and informative. You are teaching at a pace that I find works for me and I appreciate the effort and time you have put into making these video. Knowledge is power and also job security. Please continue teaching and I will do my part to "learn. Keep it up and may God bless us all.

[@GhingerT]

I agree! I've spent over 4 thousand dollars to New Horizons to be talked rude to by David Deriniak! In Troy Michigan. I'm so glad to be able to get the same education on line thanks to this man!

[@bboyfocus12]

i see well you deserve it dude you helped me out with access exam there for which i was behind in notes! mad to think how many people you help out for free need more innovators like yourself good stuff!

[@599CD]

I didn't make any Access 2007 tutorials at the time... and it's SO similar to 2010 that there's no need. If you're using 2007 you should be able to follow along with my 2010 lessons.

[@ClawleenMeowlen]

Thank you for these tutorials! I recently began collecting data for a project and although I've used Access databases at work, I hadn't actually created a database in Access in a little over ten years (in a BCIS course I took in high school). Needless to say, I don't remember anything about how to get started or how to set it all up, so these videos are proving extremely helpful - very easy to follow!

[@599CD]

welcome

[@599CD]

Thank you very much for the critique. It's very hard to strike a balance between going too slow and too fast. I've had people take my Access/Excel classes who have never used any Office apps before, so I try to err on the side of not losing anyone. I feel if the material is too slow for a more experienced student, they can always skip ahead. I do certainly appreciate the feedback though.

[@asmaaelsayed6069]

well never thought I will need to learn Microsoft access now, but really thank you for ur detailed way of explaining everything

[@599CD]

Access is one of those things where you don't realize ahead of time that you need it, but once you learn it you don't know how you ever lived without it. :)

[@iwondery75]

These beginner tutorials are excellent. Thank you very much for offering them!

[@dchakraborty1]

Wohooo great.. you made my day. I would take the Visual basics and look forward to summer. I have no words to thank you enough.There are lots of tutorial in KZbin but yours is unique because it explains everthing from scratch... :)

[@599CD]

I do have a Visual Basic 6 course on my channel. I might make a C course this summer.

[@kblyaq]

You're great and well be remembered by your help those who are in need. God bless you.

[@candialexander5443]

Your such a great teacher! I have a job interview in a couple days that will require to have strong Access skills and i am confident that after studying these videos over the next couple days i will have the necessary skills to be hired. Thank you!

[@599CD]

I don't recommend storing files inside of Access databases. I recommend you store them in a folder and then just store their location in your database. I show how to do this in my Access Imaging Seminar (I cover mostly images and pictures, but it works for any file type).

[@jennifer7685]

this is the perfect pace. a little slow, but that gives your brain enough time to think about what it would mean before a new bit of data shows up. thank you, this is really helping me.

[@599CD]

My pleasure

[@599CD]

I make my money by impressing people with my beginner lessons so much that they come to my web site and sign up for my more advanced tutorials. I'm glad to give away beginner instruction for free to gain new students. But to answer your question, yes, I do earn a little income from the ads that play over my videos here on KZbin.

[@ibrahimcity2000]

great work! these are really helpful for beginners... I am waiting for more advance tutorials from ur side...as the way u explain is tremendous... keep it up!

[@599CD]

I use Hypercam for my screen capture recording. As far as using Access data on the web, I prefer writing custom pages in ASP (Active Server Pages) to do that. I'm not sold on Access Web Databases yet. They are fine for small teams, but they have a long way to go to be used on public web sites.

[@599CD]

I'm sorry you feel that way. This is a BEGINNER tutorial, so if you feel that it moves too slow for you, I have plenty of other advanced tutorials you can watch on my Channel and my web site. If you find this boring, then perhaps you should skip it.

[@599CD]

Well that's certainly not good. I just finished moving the web site to a new server, so I know there were some forms that weren't working right. Do you remember what page it was? I haven't had any other complaints so far.

[@beccarendell2854]

Your lessons are fantastic!! I have always had trouble getting my head around DataBases and working in an office full time as a trainee makes it harder. Thank you soo much!!

[@599CD]

Thanks, everyone! I appreciate the thoughtful comments.

[@AuthenticYEMANI]

Sorry I just purchased the 2010 from my school so I can keep up my group to work on the Project. Your videos helped me alot to utilize Access. Thank you so much

[@mruth0006]

Agreed. Great job with these tutorials 599CD!

[@DavidWrightfan11]

This is so helpful..thank you! I have a bachelors degree in accounting and a lot of jobs want you to know access so this is perfect. The Professor I had in college didn't teach this class very well lol!

[@davidc1303]

Hi Your videos are great but I would like to know what screen capture program you use? It is almost seamless. Also, I use a access database on a webpage. Do you have any lesson on that because the results that show on the page I need to know to edit that and configure it.

[@599CD]

Nope... it's Access 2010. The file format of the database was 2007, which is why it says "2007" in the title bar. It's definitely Access 2010 though. If it were 2007, you'd see the round OFFICE BUTTON instead of the FILE tab.

[@dturnerbyfield]

Thanks for the information, but I have experience with Access and haven't used it in a long time and needed a refresher. I acutally am looking for a free refresher on how to build and expand. do you have any of these that are free

[@599CD]

Glad you like it.

[@umairwaheed14]

Thank your very much i am very impress with your Access video because i am searching about complete Access videos so when i see your videos i like it so thanks alt for this bye bye

[@priscole]

Thank you for posting these helpful tutorials!

[@rexdunn6036]

That's the beauty of UTube, just move on if you don't need all of the details. I personally like the thoroughness.

[@dhogan1967]

Awesome series, thank you for breaking it down and making it dummy proof. On a side note, you sound like you are from Chicago.

[@599CD]

You're welcome. Buffalo, New York originally. Not far from Chicago. It's all the same "Midwestern" accent. :)

[@dchakraborty1]

BTW do you intend to make a course on Visual basics or C' programming?. :)

[@anamariehernandez4093]

Thanks its really helpful. More power to you.

[@599CD]

Most of my free tutorials are here on KZbin. I do have some additional free lessons on my web site in the TIPS section... but most of those are up here.

[@nathanielstemerdink2654]

do you ever mention any thing about the BCT tables or the R.S.O style formulas? please get back to me, thanks.

[@599CD]

No idea what those things even are.

[@599CD]

You're very welcome. I'm glad you enjoy the lessons.

[@599CD]

You're very welcome.

[@Untranslate]

Wait what do the little dash,square, and "X" on the top right of the screen do again? Could you go into a little more detail? -_-

[@599CD]

Ha ha. :/

[@599CD]

I hear that a lot.

[@TheOriginalJoven]

Thanks for you tutorials !! you're very thorough and comprehensive in your tutorials... !!

[@ArthurMcGDM]

I'm noticing that in version 2007 that when you click on Create > Table, that the additional tabs "Fields" and "Tables" does not appear automatically. Is there a way to make them appear?

[@599CD]

599cd.com/Ask

[@rcx8666c]

HOW SECURE IS AN ACCESS DATABASE FROM INTRUDERS ? DOES THE ACCESS DATABASE HAVE A WAY OF SREENING OUT INTRUDERS ?

[@rutherfojr]

probably about the same as sql server

[@599CD]

Access is nowhere near as secure as SQL Server. You can do a pretty good job of hiding the FRONT-END (forms, VBA code, etc.) but the table data is very hard to secure. You can encrypt it, but you can't completely prevent intruders. 599cd.com/Encryption

[@tankgirl3032]

Your tutorials are impressive. I have very little experience with MS Office...I own a MAC and iPhone...am spoiled...find that PC programs are more difficult to figure out and not intuitive. Never in my working life did I have a class or training on any MS program or in the operation of a PC...do all employers think we were born with the knowledge? Anyway...starting a new job in a few days...and will be required to know MS Office and Access...thanks for the help...just wish I had the actual programs to tinker with...Not the same on MAC....

[@machopineiro3105]

Once again, you did a great job with your video1

[@599CD]

Thanks

[@rcx8666c]

Where do I get me a set of general purpose Access database templates ?? Is there a reliable web site free of computer viruses that I can go to to get templates ??

[@599CD]

599cd.com/Templates

[@happy26676]

Hi, Greetings from Taiwan. I plan to use Access to build an Access File for sorting Church worships . Any good advices? How can I attach Songs APP onto Access?

[@Maxsdiscos]

What if you have files from decades ago/on, will it fail to read/write?

[@599CD]

Well, since this question is almost a decade old, you tell me. How'd it go? :)

[@BageshwarMahadev]

Please also upload a video Playlist series of Microsoft SQL and Oracle for learner.

[@599CD]

I do have SQL Language classes: 599cd.com/SQL. I will be covering SQL Server later this year. Oracle, probably not.

[@Sakiftechcamp]

i am loving it

[@bravekingsolomon]

Great, but can someone help me? I want to create a report to cllect information "between dates". What can I do?

[@599CD]

599cd.com/ask

[@inngridar5486]

Hello Very usefull tutorials. Do you know how can I change the language to from Spanish to English in Acces 2013? I'm doing as follows: options, language, enable English, then rebooting, but is not working. It keeps displying in Spanish. Thanks

[@599CD]

Sorry. I'm English only. I've never touched any of the language options.

[@dchakraborty1]

Its very nice Video Thanks for sharing it.

[@dianavarona3630]

I am sorry quick tip i would love to share you should think about doing this in Spanish there are so many people in the others Spanish classes that will benefit from your great program. I am also a Spanish voice over artist if you need any help in translation please advise me great day and keep rocking you rock

[@maxineaten3709]

I was told by friend to use your tutorial. I am simply trying to build a very simple data base for my clients so I can send monthly birthday cards by printing labels, and to have their info at my fingertips. Is this the program I want? Sounds VERY complicated. Never worked with Excel and very little word. I was following until you got to query and creating reports, etc. Is this what I really want?

[@599CD]

Access is definitely the best tool for the job, but as you've noticed it does take a lot more setup work than just using Word and Excel. Finish all 12 lessons and then make the decision for yourself. Hang in there. It's really quite easy once you get the hang of it.

[@maxineaten3709]

599CD Computer Training Thanks for the encouragement! Would love to find someone who could actually set it up for me show me how to use it and then I'd be good to go! Guess it's the time element for me as I'm always swamped. But thank you.

[@599CD]

Maxine Aten I do have a team of developers that I work with who could build the database for you. You can find out more at 599cd.com/TechHelp

[@bboyfocus12]

do you make any money off these vids at all from youtube or anyway?

[@599CD]

Glad I could help! Sounds like your former IT guy could probably use a few lessons too. :)

[@599CD]

Of course it's possible. Almost anything is possible with Access.

[@378983149]

Very good job. Thank you!.

[@599CD]

welcome

[@beeville73]

Very Easy, go to Access and Import data(function on the far left) and select "Import Data" and it's very easy after that.

[@jab71man]

Thanks for uploading these tutorials, They are great!

[@cookiemonstrarrr]

I wish there was a "start here if you are familiar with Microsoft programs" note.. It takes soo long to get in to actual access.

[@599CD]

Yeah, I try not to assume people know Word & Excel. Some people have never used them.

[@599CD]

Newest version doesn't do as much of that: 599cd.com/ACB1

[@billjuss5331]

Nice and instructional!!!

[@599CD]

My pleasure.

[@papadaurhel]

Great Job

[@599CD]

thanks

[@imrangujjar3433]

Great Job....

[@elymasable]

Good but please speed up delivery.

[@zochbuppet448]

Do not listen to the current generation. They want everything done in seconds. Look at some of the videos they make. He has a excellent speaking voice and pace. This is how people are supposed to teach a new subject. The pace gives the your brain a chance to think about what he says, and to rest for the new bits of information. You can always fast forward the video yourself, or listen to it at a faster speed, using the settings option

[@susisongket7900]

this is for beginner not for advance

[@599CD]

Thank you, Zoch and Susi. Tiffany, if you want faster-paced courses I recommend my Expert or Developer lessons: 599cd.com/Developer

[@knsrulz]

Good tutorial

[@angelalewis7943]

Thank you so much

[@599CD]

Welcome

[@ohenebantiri]

Has been of immense help, God bless you!

[@599CD]

I'm sorry I'm too verbose for you. I'm sure there are plenty of other tutorials here on KZbin that you can find that move at a faster pace. I prefer to take the time to explain things in detail... especially for BEGINNER users. This tutorial was designed for the NOVICE user. If this is too long-winded for you, then perhaps you need a more advanced lesson.

[@599CD]

Thanks, Colin.

[@ashugrai]

2007 version BUSTED!! 4:32 .... Just kidding :P btw beautiful tutorial!!!

[@rogelioyb]

The 2007 simply denotes that you're using the modern format of database, which was introduced in Access 2007 and is still used in Access 2010.

[@refatjabeen-17]

just wonderfull.

[@AuthenticYEMANI]

2007 ?

[@599CD]

Exactly. I do have more advanced, fast-paced lessons available. If you're not learning anything with the beginner lessons, don't watch them. They're not for you.

[@mahvashghajari4975]

really helpful and instructive. thanks so much

[@599CD]

Awesome. Glad I could help.

[@599CD]

Thanks for the compliments. :)

[@qaispayman2934]

Thank you very much for teaching really it's helping me a lot

[@599CD]

Welcome

[@599CD]

On my web site I accept Visa, MasterCard, American Express, Discover, Paypal, and checks or money orders. I will also accept Western Union via bank transfer. Contact me on my web site for details.

[@bhagyajayarathne8205]

Thanks

[@599CD]

Welcome

[@599CD]

Thank you!

[@azifri]

The customer example was you, right? ^^ Thanks for the tutorial, this is so helpful for me

[@599CD]

Mayyybeeee

[@kaddouraouachria5768]

thank you 10/10

[@599CD]

My pleasure.

[@599CD]

Wow. That's awesome. I'm so glad to hear that. Now, I wouldn't ask for half your salary, but I do have more Access training available on my web site [hint hint]. Ha ha. :)

[@Linderjw]

I have to agree on the too much unnecessary information all ready on video 3 and over 30 mins and haven't learned anything yet. I know its for beginners but you don't need to show people things like how to start the program. I am no trying to be negative I think this will be a good lesson it's just to slow. try to work on your pacing. you are doing a good job it just starts slow.

[@599CD]

Hey... what's wrong with my tie? Haha. Actually, I almost never wear a tie. I just happened to be dressed for a wedding I was going to and decided to take a head shot for my web site. :)

[@AlexPotthast]

Anyone else notice that his name is Richard from his C drive? lol

[@599CD]

Tell your professor I said THANKS... and if he wants to use more of my videos in his class, I do have educational discounts available [wink wink]. :)

[@599CD]

Thank you, Rex. If you find the beginner tutorials too simple for your tastes, just find something more advanced.

[@jaskkainth1840]

Istilldontknowwerethespacebaris

[@599CD]

well-find-the-hyphen-key-then

[@מוריהכהן-ק9ס]

amazing ! thank you so much

[@599CD]

welcome