Microsoft Access 2010 Tutorial Part 02 of 12 - Planning Your Database

[@roberttrupp3947]

My wife and I have wanted to put a database together for several years. Today we brought the subject up again and I found you through Google search. We have now subscribed and when we are through, we will be sending more people to you for training. Thank you

[@599CD]

I take that as the highest compliment. Carl was The Man. :)

[@micheleotten5016]

I am so glad I listened to your video. Great information and very well delivered. The ist video I listened to was done by someone else. It was the slowest more repetative boring lesson I have ever listened to. I could not even finish the first one. Your class is perfect. Right pace and great information. Thank you.

[@mrtijuana99]

You give informative information in a short period of time. Very good.

[@599CD]

Yes... and that's how most people learn. Books are great for reference. Tutorials - being SHOWN how to do something step by step - are how most people are more comfortable learning.

[@599CD]

Thank you. I'll take that as a compliment. He's a very eloquent speaker.

[@599CD]

Not with JUST Access. You could use Access as the back-end database server on the web site, but you would still need to code a front-end with a web programming language like ASP. I show how to do this in my Web Database Seminar: 599cd(DOT)com/XPS0ER

[@michaeljones8537]

Maybe it is mostly the learning preference each person has. For me, I find this approach is exactly what I need to get started. The initial explanations are putting the entire subject in a context that is helping me understand what to do and how to do it with Access. Much better than just opening a book; I will use that more for quick reference, once I know what I'm doing.

[@sweetboo1022]

Thank you for this. I've been putting off building a database for years because I was terrified how to do it and now I am surrounded by loads of excel spreadsheets to track out 3 million plus inventory for our small business. I hope by Christmas I can get this all sorted out and work to increase sales next year by planning better. These videos are exactly what I needed for myself to learn this and not feel so intimidated.

[@599CD]

I appreciate your feedback. I prefer to give the user enough background to understand what it is they're going to be building - assuming they have no prior knowledge of Access or databases in general. I've been teaching Access since the 90s, and this is the approach I've always taken. Judging by the overwhelmingly positive feedback I've received on my methods for the past near-20 years, I think most people learn best this way. Of course, there are always exceptions. Those people are generally...

[@mb211273]

These Access videos are imensely straightforward and helpful good work my friend !!!!

[@loriec0ver]

Awesome training videos. I was getting very frustrated in trying to do this myself and your videos are clear and to the point. It gave me a good understanding in a very short period of time! Wonderful job!

[@randyhimura1]

Thank you so much for making these videos. I will surely finish all of your lessons. I hope to create a database to help my business and be able to keep track of the product inventory, receivables, etc. More power to you!

[@cascreis]

Best Access tuto I've ever found... thank you so much!!

[@599CD]

I don't understand your question. Are you asking me what tables and fields you should set up in your database? That's up to you. Probably a list of guests, what tables they're at, etc. I've never planned a wedding before, so I have no idea. :)

[@TsarDNB]

Just the best explanation, so much better than the lecture at my college.

[@599CD]

Thanks

[@599CD]

Thanks! Enjoy the lessons.

[@irmajulita585]

very clear tutorial, love your voice very easy to understand. Great job helping me a lot to pass through the exam. thank a lot for the video.

[@Trey50Daniel]

Very informative and not monotone like some instructors may be. Very engaging and well worth watching to be able to do well in my intro to information tech class

[@MathatongNtoane]

Thank goodness for these lessons. Great presentation.

[@599CD]

Thanks

[@599CD]

Thanks. I try to keep it fun as well as informative. :)

[@2SHOTDAVE]

GREAT VIDEOS!!!! I took this course last semester and this is a great review for me! like riding a bike! THANK YOU VERY MUCH!

[@599CD]

They do, for the most part. This one, for example, is "Planning Your Database." Part 10 is "Customer Form" which is building the customer form. The description field can only be SO long. :)

[@Redyear20]

Like you videos ;) this will help a friend of mind, Access have change a lot.

[@lisab8421]

I am SO glad you offer these tutorials! I am new to Access and in the process of creating our company wide phone directory which will then be shared on Sharepoint. This is going to help me a Great deal!

[@599CD]

My pleasure

[@599CD]

This goes WAY beyond this Beginner Access tutorial... but as I mentioned in my last comment, I believe the best solution is to create a web-based database (using Access, SQL Server, or whatever you have) and then code your own custom ASP-based front-end (web pages) for it. Again, I show how to do this in my seminar (see previous post). It's far too complicated to explain it all here.

[@ahmedsaid886]

Thank God for such helpful people like you .. Excellent work, keep it up ! ;)

[@599CD]

Welcome

[@smilezhil]

Nice Work Pro its really useful...

[@nathanmartinez5587]

You're a fantastic teacher

[@jeffstowe4860]

old skool unix, sql. oracle type..never cared about microsoft equivaents until now for a sudden volunteer job in a couple of weeks. I lot of folks know this stuff but they are such lousy instructors! Damn you are an excellent one that keeps it simple, yet not long, " uhhh this...well uhhh that" nor developer level after beginner. In just 1day Ive learned the basics of both excel and access...ready, to take your expert level next. Great Job!

[@roland1241]

great video for user like me who have zero knowledge on Access..

[@Kwintessential2]

I am really understanding the uses of Access. I am trying to learn this and then use Sharepoint.

[@eckyf15a]

Great video. Short enough to keep you focused but enough to keep you interested. Could you describe a field (column) be regarded as an attribute.Secondly can you explain what a primary key and foreign keys are in relation to entity. Thanks

[@JuliantoFirman]

such a champion video!

[@599CD]

I don't understand your first question. Primary keys are used to uniquely identify each record in your table. Foreign keys are used to create relationships in the secondary tables. I cover these in much more detail in my Access Expert Level 1 class and my Relationship Seminar. I also have a KZbin video on the subject. Search for "Microsoft Access Relational Tables". I hate that we can't post URLs in comments or I'd give you the direct link.

[@md.arshiya4858]

Sir u can give block notes also sir please sir

[@599CD]

Well, there are many different ways to implement this. I personally would use an online database. Your VB app could check the web site database to see if the user's information is in there. If so, activate the software.

[@akshayramdin8787]

THIS ENABLED ME TO PASS MY EXAM!!!! (Y) (Y) (Y) ♥♥♥♥ Thanks bro!!

[@Lucream2]

Hi 599CD, I have tried to purchase your videos for MS access, however having tried twice your system just says it does not recognize my credit card. I am in Africa hopping to learn from your great lessons. I have purchased products from Amazon, ebay for several times but when it comes to your site everything just fails.

[@billjuss5331]

Yes, I love it, similar to 2013 Access, but still good and clearly explained concepts, thank you.

[@599CD]

You're welcome. Yeah, even 2019 hasn't changed that much.

[@nabilas.9571]

Thanks. Really helpful. Appreciate it much.

[@fsmit80]

I ask this question because Im not sure if this video series is for me. We currently use MS Access w/ InfoPath. With Access, is there a way to send private information (employee data) to Manager B, who can make real time updates, but also be able to share it with Manager A and C who can also make RT updates. The trick is, no Manager can see their own information. Manager C only see his employees data, Manager B sees Manager C and his emp, Manager A sees B & C and emp.

[@ruberxwibebadhi]

greatest video ever

[@599CD]

It's possible, but with Access you'd need to add some security to keep users from seeing data they're not supposed to. It's a lot more advanced than I can explain here, and for a beginner tutorial series like this one. I do have a seminar that covers it, however. See my web site at 599cd(DOT)com/X1HPXD

[@zss123456789]

I RUV YOU SOOOO MUCH!!!! THANK YOU!

[@TheSohail316]

thanks so much man

[@kimberlyd2789]

Great videos!!

[@599CD]

Thanks

[@TheMedicaidGuy]

Just try not to read straight from the slide. Intelligent people can read for themselves so it has a bit of redundancy. However love the videos and you are a great teacher!

[@utsavraj5684]

a really helpful video.i did not know that ms access was so easy

[@599CD]

Yep!

[@599CD]

I'm not sure what the problem is. I know I have many students around the world (including Africa) who purchase my products. Perhaps my credit card processor doesn't like your bank? I have no idea. Perhaps try something different like Paypal. We also do take checks or money orders. Contact me via the customer service form on my web site and perhaps we can work something out.

[@truthsetsufree]

Thanks, great video series!

[@599CD]

Welcome

[@FoodNJoy2022]

Many Thanks. God bless you..

[@ruberxwibebadhi]

greatest video

[@lukeizay]

You made understanding Access so much easier! One question though: are you able to generate charts and diagrams using Access?

[@HottKitz]

Right, but what I'm asking you is if it's possible to do this with MS Access (build an online database).....? Thanks again...

[@niten_21]

excellent lessons! Thanks for the content.

[@599CD]

welcome

[@Razor20131]

great job bro thank you

[@olimacabc13]

great video......A++++++++

[@yashaggarwal6847]

I'm a kid of age 12, and I understand Richard Sir's explanation so well

[@599CD]

Sweet. How are you doing now at 15? :)

[@yashaggarwal6847]

@@599CD Very well :)

[@599CD]

...book learners and prefer to be able to jump around from topic to topic in a textbook where they can experiment, instead of following a step-by-step guided video tutorial. Whatever works best for you.

[@acrexia]

Thanks for the video. I organized my tables and forms in a sheet of paper. Love it. god bless

[@599CD]

Welcome

[@temosuladze7668]

thank you! you saved me from failing final exam!

[@599CD]

Welcome

[@MrBatsieboy]

You really help me with school. Ty

[@599CD]

Welcome

[@HottKitz]

Hi Richard, I was just wondering if it would be at least a decent idea to use MS Access as a way of Software Protection. Basically I would like to protect my software that I created in VB.Net, have MS Access store the Hardware ID's of those who have purchased my software and if they're Hardware ID's match what's in the database, then the software will activate. Does this sound secure to you? What do you think about this idea? Thanks Ric! - Aaron C. ---------------------

[@HottKitz]

Does this show how to connect to the db with vb.net 2010? If not, could you please refer me over to a learning resource of how to do so or make a tutorial on how to accomplish this? Oh and are you saying that there's a better way of connecting to an online db with the need of MS Access to verify people who have bought my software? What do you think would be best for Software Protection in this case? Thanks...

[@inasnosa8517]

thank u it's so helpful

[@599CD]

welcome

[@nevearenas9289]

excellent!

[@viveksingh222]

hey hi there, I am just beginning these tutorials, they are good so far..thanks heaps..but I want to know if I can make a workflow tracker using access(where we save the list of various types of jobs coming in) and restrict the users to check only jobs they are assigned to..I have used excel earlier, but it became difficult to manage as I had to share the file with huge number of people..please advise..thanks in advance

[@599CD]

Sure you can

[@rapistelimanator1]

what would a person need in the database if they were trying to run a game design business, and how can a employee access the database?

[@mbashiir938]

execeelent lessons

[@599CD]

Thank you!

[@allahyarrahamni4971]

Thank you sir

[@599CD]

Welcome

[@EngSH-qw4fv]

thanks it was very helpful

[@599CD]

welcome

[@sprachenwelt]

Hi there, very nice Film. I have a question before going on. Can multiple Users get different personalized Forms to add Date into the same Databank. Put into practical life. I need my IT-Teachers to add their Usersupport into a central Databank without interfeering into other Teachers. All of them are scattered over the country. Thanks in advance for your reply.

[@599CD]

I'm very sorry for taking so long to reply to your comment. I wasn't very good at keeping up with the comments 4 years ago, but I've been trying to make an effort to get back to everyone. If you still need help with this problem, please feel free to submit your question on my web site at 599cd.com/TH.

[@francarlosmoldescruz412]

Great videos! I'd like to create a database where I can set appointments (date/time/name/phone number) and then be able to track down who showed and who didn't.

[@599CD]

599cd.com/Appointments

[@nahidtaherian4867]

Hi, How about if I have many different people in an organization, that I want to find out how many times they have logged in to different customer page, how can I make a query of that? Thanks

[@599CD]

You'd need to setup logins first: 599cd.com/Security

[@maxmakaya6784]

Hi,i would like to carry on with the courses I mean I ve watched level 1 for datatabases and 4 videos of level 2.How do I get the rest

[@599CD]

599cd.com/1dollar

[@truthseeker16]

the best

[@599CD]

Thanks

[@rcx8666c]

In Access you have input and output files and then you have operations on the input files to produce the output files

[@599CD]

Uhm... sure

[@mahi_maai]

si r i need to know.. how to connect access table with sharepoint.

[@599CD]

599cd.com/Sharepoint

[@mahi_maai]

can you please guide how to upload live access to sharepoint site.

[@599CD]

Sure: 599cd.com/Sharepoint

[@Nyikili]

is it ok to use an underscore instead of spaces?

[@599CD]

I wouldn't. No spaces, dashes, underscores, etc. Letters and numbers ONLY. Trust me.

[@eyedalehim2469]

Would this work as a maintenance software?

[@599CD]

Dale Deodor I don't see why not. Access databases are like Legos. They're all made up of the same basic parts, just rearranged differently.

[@rudyrodriguez3242]

PC Learning Zone - Computer Training YOU MAKE GREAT VIDEOS AND THEY ARE EASY TO UNDERSTAND. KEEP UP THE GREAT WORK. I AM SURE THIS IS GOING TO HELP ME IN MY NEW JOB BECAUSE MY JOB REQUIRES SOME DATABASE KNOWLEDGE. TRY TO KEEP US INFORMED OF ANY NEW TRAINING VIDEOS. I HAVE TO START CREATING DATABASES OF MY OWN. I STARTED PROGRAMMING COMPUTERS BACK IN THE 1960'S USING THE FORTRAN LANGUAGE. PROGRAMMING WAS LOTS OF FUN BECAUSE I WAS A MATH MAJOR IN COLLEGE.

[@lastnoeltech]

excellent

[@aracelyospina8331]

Hello! In my lab we have a very complicated excel spreadsheet in which we store all information related to our samples, i would like to build a database for it but I would like to get an advice or orientation from you to start. Could I email you the field that it contains so will have and idea?

[@599CD]

I'm very sorry for taking so long to reply to your comment. I wasn't very good at keeping up with the comments 5 years ago, but I've been trying to make an effort to get back to everyone. If you still need help with this problem, please feel free to submit your question on my web site at 599cd.com/TH.

[@rcx8666c]

WHERE IS A RELIABLE WEB SITE SOURCE OF ACCESS AND EXCEL TEMPLATES ?HOW MANY DIFFERENT TYPES OF DATABASE TABLES EXIST ? ARE THERE AN INFINITE NUMBER IF TABLES ??

[@599CD]

Uhm...

[@1gopalakrishnarao]

Sir, I am interested to learn VBA from scratch. Please guide me.

[@599CD]

Gopala Krishna I start covering VBA in my Access 301 class: 599cd.com/XAC301

[@joshuasbuttka5347]

thnx man :D

[@TheGreenMullet]

I never lose ether drinking contests

[@voswouter87]

This is way too bureaucratic for me. First video only had administrative stuff that I don't care about. Then you go on about the planning of the database, why not just get started? The database can be refactored into a better design, later once the user has an idea what they are doing.

[@599CD]

LOL

[@showqihamshari9466]

please help me to download access on my computer

[@599CD]

Sure. Here you go: amzn.to/3rognsw

[@johnmcnulty8746]

Sorry these free videos are not good enough for you

[@geeeter]

Great videos. Anyone ever tell you that you speak similar to Barack Obama?