Microsoft Access 2013 Tutorial Level 1 Part 05 of 12 - Customer Table, Part 2

[@academicsinc.909]

I'm an educator not a business person, and I found it a great instrument for tracking my students, parents, teachers and the students grades. Maybe it isn't for every educator but with a simple set up with this wonderful instructor it is possible, GO EDUCATORS!

[@599CD]

Thanks

[@SEEpath-kt7jm]

Bro, you are God send. Each one of your lessons is amazingly tailored to guide and educate your audience. I'm truly grateful for your time and willingness to share with us your knowledge about Access. It makes me sad and angry, I'm spending $20,000 each year and wasting 2 hours of my day to get a paper rather than learn from an amazing instructor such as yourself. As far as using titles to identify one's self go, you my friend need a title that FAR EXCEEDS the parameters for the title of a teacher. You are THE ENLIGHTENED ONE.

[@599CD]

Ha ha. Awww... thank you. Your kind words made my day. Sorry it took me 4 years to see this and reply. How did getting that paper go?

[@anncarlson6311]

Haven't played in Access for awhile and am going from 2007 to 2016. I'm going through your series from the beginning to blow the dust off the brain cells. I appreciate the detail and I'm not getting bored - even though it is a refresher.

[@599CD]

My pleasure

[@karirudh7605]

Appreciate your basic down to earth language in your explanations and your level of detail addressing confusions that may arise at each step. Thank you.

[@599CD]

Welcome

[@luwei1120]

This is actually so far the best tutorial on KZbin about Microsoft Access... Doesn't make me sleepy at all!!!

[@599CD]

Thanks

[@rtee4780]

I'm enjoying the course so far and I appreciate all effort you have put into these lessons. It's a great refresher from my Access 97 & 2000 days. I want to make a couple points about what you said though: 1 - Do NOT mistake the AutoNumber field for a true primary key. The AutoNumber type only creates unique numbers for each record. It does NOT prevent or eliminate duplicate information in your table. Meaning you could have the same customer info in multiple records but with a unique CustomerID number. In this case, you will not have data integrity and any query results and reporting for that customer will be inaccurate. 2 - Also, you would likely never delete records from the customer table once the database was actually in use. You would simply set the IsActive field value to No (uncheck the check box). Deleting records from this table would create orphaned records in other tables that held data for these customers. I realize it's early in the series and you may address these points later on, but they are important to know and for people to think about up front when creating tables. Thanks again, I'm looking forward to the rest of the series.

[@599CD]

R Tee The AutoNumber field is a TRUE primary key. It is a unique identifier for each record. I understand what you're referring to, but that's more of a training issue than a database issue. Users should be instructed to see if the customer is in the database FIRST before adding a new customer, and you could set some of the fields that should be unique to "INDEXED, NO DUPLICATES" if you want to make sure you don't have two customers with the same address, phone number, or email address, but this is something you'd build into your database yourself. The AutoNumber, however, is a true primary key in every sense of the word. I do agree with your about deleting records. I personally prefer to NEVER delete records from my databases (especially customer records). Yes, it's much better to mark them inactive. You can prevent "orphan" records by using referential integrity and cascade deletes, however this would then delete things you may not want deleted, such as order information, which would mess up your accounting. Thanks for the feedback! Very helpful.

[@elkhanhamet2561]

sir, I absolutely love the way you teach Access, the way you talk and explain just makes it so easy and accessible for anyone to understand and gain Access skills. Out of all tutorials I've seen this one is THE BEST!!! Thank you very much and I will stick to your advanced videos all the way till the end.Thanks again!!!

[@599CD]

Welcome again

[@nakuru1956]

I have survived tutorials 1 to 5. They are excellent. Easy to understand and follow. I am enjoying the tutorials and will finish them all. Thank you.

[@599CD]

Welcome

[@maqsoodkhan7451]

This is the best Access tutorial I have ever seen. Thumbs up for you.

[@599CD]

Thanks

[@yvonnescott4828]

I have been watching the tutorials and have learned a lot. I enjoy your easy to follow, uncluttered, teaching style. You make it fun to learn. You don't speak over our heads. The design of the screens makes it easy to understand what you are presenting. Thank you very much for your lessons.

[@599CD]

Welcome. Thanks for the kind words.

[@annekirkpatrick5911]

I am learning more than I expected from this series. Thank You

[@darnb100]

dude you have the most awesome and easy to understand tutorials ive ever seen. I would totally pay for the expert course if i had a credit card.

[@sanogobakaramoko9531]

You are the best teacher I never met before

[@599CD]

Haha. Thanks! Nice to not have met you. :)

[@northernlitegirl]

Thank you for these tutorials. Having never studied Access before I find your method of teaching very logical and helpful. It makes the effort to increase computer skills less intimidating when the instruction is well ordered.

[@599CD]

Thanks

[@advocatus360]

Very good tutorial. I find that watching the video at 1.25x speed keeps me actively engaged (in my busy cubical workspace). Thank you for creating these videos.

[@599CD]

You're very welcome.

[@artisticpiscean]

Thank you so much for ALL of your videos! You made me able to build my own database for our home improvements company with about 2000 customers! Greatly appreciated!!!

[@599CD]

welcome

[@tenacoutlaw]

These videos are great, simple clear directions. Going over and explaining how/why as he moves through each step. Makes it all very clear, only hope my teacher IRL is as good as he is. I'll be starting a class in 2 days and wanted a primer, might have saved a bunch money had I found this sooner. Thanks for making them , I'll be sending my wife to the windows tutorial.

[@599CD]

Thanks. How'd the class go?

[@mskstudio_net]

Easy to understand tutorials. Appreciate your hard work and simple to follow way of teaching.

[@599CD]

My pleasure

[@edalvi441]

Evolution of Access had me lost, since the days of Access 2003. It is refreshing to observe Access 2013 explained in such a passionate way. Great Job!

[@599CD]

Thanks

[@salihubabamusa4038]

Great! Not a single important point missed. Very clear and concise. Good for all.

[@599CD]

Thanks!

[@senjeanman]

So clear, so fluid, so easy to follow. Excellent work!

[@jamesneece3131]

*High-Five* Had to pause and give you props for the Space Balls plug. Good series!

[@599CD]

Nice!!! :)

[@lauramhina8151]

I am loving the learning through u. Thank you for making it easy to follow up.

[@599CD]

You're Welcome!

[@JulieKenk]

Thank you following my comments from previous lessons. Now it's make sense. I was able to right client on my previous entry from my client list and I was able to see the table view. Now it's make sense and I understand more the way we put the entry. Thank you

[@599CD]

Welcome

[@kegenrodrigues]

Watch it at 1.5 speed. People this guy deserves more likes..just in case you have forgotten

[@599CD]

Yeah!

[@markgutman3217]

These lessons are fantastic! I took a course in Access (I forget if it was undergraduate or graduate level) in 1995 and got an A in it. But I've learned more, or have a better understanding, from watching these few videos than I learned in that class. (The other two classmates got most of the work done on our project, and I know how to take tests.) Of course, these videos can be stopped and backed up over and over, which is very helpful to me. I'm amazed at how simple the learning seems so far. And excited about all the ways I'll be able to use a database, both at work and at home.

[@599CD]

Thanks

[@enosimon1464]

Thanks for sharing this rich knowledge about Access! I can't wait to get started!

[@599CD]

Welcome

[@cheryllynn5671]

These videos are so very helpful for me as a new Access user and a novice database designer. Thank you for doing these videos.

[@599CD]

Welcome

[@lxrdbxnz6678]

YOUR AN AWESOME KZbinR YET YOUR SORT OF UNDERATED, BUT IN FUTURE I CAN TELL YOUR GONNA GO WORLDWIDE BUDDY!

[@599CD]

THANKS!

[@mountainman5900]

Thank you for these videos. I was looking for a refresher and this is perfect!

[@drfroglegs]

You are a really good teacher. Thanks for taking the time to make these videos. They are very informative.

[@599CD]

Welcome

[@Badger214]

Wow. Just wow. I learn much more than Access. I am learning how to teach. Excellent job. Excellent Job. Pat your self on the back.

[@599CD]

My pleasure

[@sharonhemphill8398]

This is the best series ever!!

[@599CD]

Thanks

[@stephensullivan4888]

Thanks for these tutorials I used Access in the years well gone=by I am following your course as Access 2013 as is it is so very different from the version I have used before keep up the good work !

[@599CD]

Welcome

[@annmannion7832]

I have been doing your lessons, I find them very helpful, very well explained

[@599CD]

Thanks

[@kgomotsopupuma9142]

I meant to say "grateful for you posting the tutorials".

[@599CD]

My pleasure

[@nqobile203]

Thank you it was really easy to understand and was struggling with database design but now I see that basics are important..Thanks again!!

[@599CD]

welcome

[@SaigoRyu]

You are an amazing teacher. Thank you very much for putting this together.

[@599CD]

Welcome

[@mikesimpson8558]

Thanks. Extremely helpful for basic user. I look forward to future lessons!

[@599CD]

Welcome!

[@harshalshinde227]

This lectures are gold!

[@599CD]

Thanks

[@omaridaniels8427]

Actually learning Access right now for my job, so this tutorial has come in handy so far.

[@599CD]

Thanks

[@Numilex]

Thanks so much for these tutorials, you got me an A for my database at school!

[@Rowdyrecords55]

Thanks for these great lessons!

[@599CD]

Welcome

[@guledsm]

Thanks. Very simple and very comprehensive.

[@599CD]

You are very welcome. Glad you enjoyed!

[@malharagu]

Simply, you are better than my professor.

[@599CD]

Don't tell him that. :)

[@mrbohra]

I got what i was looking for last one week. thanks

[@bobbyebadi3111]

Thank you! I learned and enjoyed your teaching style.

[@599CD]

My pleasure

[@potaewhero]

wow I have learnt things I have wondered about before so it has kept me watching on to the next video

[@599CD]

My pleasure.

[@AlastorTheNPDemon]

I appreciate how this is taught, but my school lessons use a completely different lesson priority and pace; probably the reason I'm struggling. I wish my textbook and class were this thorough and methodical.

[@599CD]

My pleasure

[@shuaibuabdulrahman9103]

Awesome turtorial really thanks you so much for data base class may GOD Rewarded you aboundantly

[@599CD]

Thanks

[@barbaraparker760]

This is an awesome "Tutorial"...Although, I have been using Access for years, there are some tips that I have never used.

[@599CD]

Thanks

[@alanhanley214]

Ive been following these tutorials to get a real taste for Access, and I have found the teaching style and instruction to be fantastic, however as part of the course I am doing my knowledge of Access is a little all over the place so what would be really good is if you could create a link where you could download the entire video collection covering all the tutorials so you can have them on a portable device if you're in a location where you don't have internet. For someone like me this would be a very valuable asset to have in my tutorials collection

[@599CD]

Sure... go here: 599cd.com/ACB1

[@zeitgeistry]

I've been following your lessons - great instructional videos and I've really enjoyed your teaching style. So far, one question regarding to "AutoNumber" for "CustomerID" - I noticed that you let this field be "Indexed: Yes (Duplicates OK)" Can you explain why you let this field be "Duplicates OK"?

[@599CD]

Zeitgeist TTD Where in the video did you see this? Autonumbers should always be Indexed No Duplicates. They have to be in order to be a primary key field. You CAN change the setting, but it doesn't matter because you can't change any of the automatically assigned values.

[@michaelsmits8677]

+PC Learning Zone - Computer Training pause the video at 12:42 and there it is, I work on a Dutch version of Access and I got another yes option like

[@jvkenshin416]

+Michael Smits Yes, you're right. But that was BEFORE the CustomerID field was set as a Primary Key. You can check to see that, AFTER setting it up as a Primary Key, it was automatically changed to - Indexed: Yes (NO Duplicates). Hoped this helps and clarifies things. Great lesson by the way PC Learning Zone (Sorry, I don't know your first name).

[@maimster4256]

I just started, and finished level 1. I paid for level 2 and let's see how I go. So far I lovin it.

[@599CD]

Glad you enjoy

[@dstimpy73]

Very helpful for my database class! Thanks!

[@599CD]

Welcome

[@tamaratalib2521]

Thnx for your useful videos. you have a great way for explaining Access Program

[@599CD]

My pleasure.

[@mr-fu3zu]

Very informative and helpful .

[@599CD]

Glad you liked it

[@caseyanderson752]

great lessons so far and nice Spaceballs reference with 1-800-DRUIDIA

[@599CD]

What? You went over my HELMET?

[@ellie1595]

You are a really great teacher. I am completely enjoying learning from you. One question? In older versions I remember that I would add new names at the bottom of my database or table and when I closed it the name would automatically be alphabetized. Now it seems to go in order of the ID. Am I wrong about this?

[@599CD]

You can sort by whatever field you want.

[@parislarose5775]

great point about text vs. number! I never considered that using excel.

[@599CD]

Yeah, Excel doesn't force you to type your data.

[@madmacjr8503]

These videos are fantastic and I'm learning so much from them, but I think my favorite part so far is the 100% straight-faced Space Balls reference just casually dropped while talking about the different considerations for number vs. text fields. I may have had to pause the video for a minute to finish laughing...

[@599CD]

What!? You went over my HELMET!? :)

[@eliseperezalford2178]

Very helpful. Wow - I'm following along while I create a database...

[@599CD]

Thanks

[@DoubtAndWhy]

Thanks for such a very good tutorial!

[@599CD]

Welcome

[@prasadbm1978]

Thanks for making it super easy ! ☺

[@599CD]

Welcome

[@pkpotate]

1-800-druidia... dat spaceballs reference

[@599CD]

What!? You went over my HELMET!?

[@TubeSurferToo]

Excellent standards and conventions!

[@damienro0]

These really are amazing tutorials, thank you for putting your time and effort into it! One question, What if I create one database and 3 different people are entering data each in their own computer, is it possible to later on merge the data coming from these 3 people so we have only one data base in the end? And if this is possible, how would that work with Customer ID Autonumber?

[@599CD]

damienro0 Your best bet would be to use a shared database on a LAN. I show how to do this in Access Expert 21: 599CD.com/XDPJRM If you are in different locations and you don't have Internet access, you could export and import the data into a master database, which I show in my Expert 23 class: 599CD.com/XLNQAX If those people are in different locations, but have Internet access, your best bet is to put the back-end tables on a web-based server, which I show in my Access Expert 24 class: 599CD.com/X1EDR8

[@balagotrd]

Awesome video tutorial. Thank you for sharing.

[@599CD]

Welcome

[@isoboyedan-obu2323]

Thank you so much. This is a great help to me.

[@599CD]

Welcome

[@thepongking]

Thank you so much for these videos!

[@599CD]

You're very welcome.

[@tomsaefke2901]

Very instructive. Thank you.

[@599CD]

You are very welcome. Glad you enjoyed!

[@AlanStewartMusic]

Very helpful tutorials. thank you

[@599CD]

You are very welcome. Glad you enjoyed!

[@musarratzaidi685]

Good methodology to explaining the text

[@599CD]

My pleasure

[@2001BornAgain]

If I were running a non profit organization, would you recommend placing a "giving" value in the customer's information as it is a fluid number? Say for instance I have a member of a church that tithes but offers extra money for a food pantry. Would you create a field for tithing and a field for food pantry in this member's table or would they go into another table completely separate from the member info table?

[@599CD]

I'd use a separate table.

[@ferntiger5586]

Thanks! It is easy to understand.

[@599CD]

Welcome

[@varunshetty7361]

great video this helped me a lot thankyou !!!!

[@599CD]

You're welcome

[@stephenmcgettigan4053]

Thanks for everything this is very helpful

[@599CD]

You're very welcome.

[@DreamWorkDrive]

thank you! Excellent tutorial.

[@599CD]

599cd.com/TimeSpent

[@paulschneider6164]

Excellent tutorial.

[@599CD]

thanks

[@RalphNgOfficial]

great video, thanks for sharing

[@shahidpervaiz6647]

Excellent training package

[@599CD]

Thanks

[@MostafaRaouf]

Thanks for your excellent lessons, i have big excel sheet contains like 120 columns ... its too much to do it ine by one ... how to copy or to export it to the table?

[@MostafaRaouf]

i mean the head of columns ofcours...

[@ipranjali]

I know this is 3 years later but there's a way to import excel sheets, or just column headers. I won't go into details hoping you've already found the answer, but if you haven't, respond and I'll elaborate :)

[@599CD]

599cd.com/ImportData

[@christiancudiamat581]

great tutorial for a beginner like me.

[@MM-fk2js]

Thank you, great video!

[@599CD]

Welcome

[@hussainali5047]

Loving it, Sir.

[@599CD]

Thanks

[@Holabella]

Hi question for you --> You mentioned using a calculation requirement to determine the use of text vs. numbers on an integer input. Is it possible to then change the data type later (3 months after building your db) from text to number if you need to? Thx.

[@599CD]

Sure, you can change data types later. If you have any non-numeric values in that text field, they'll be lost when you change it to a number type. Also, you can convert text to number on the fly using functions like CINT() but that will slow things down.

[@danielleludwigsen4753]

Do you talk about Access documents that are linked to Excel in one of your tutorials? It is not allowing me to make changes to my design view because it is a linked document. I'm just learning Access but I did a linked document so I could utilize all of the data I have already entered into excel. Thank you so much.

[@599CD]

+Danielle Ludwigsen I do cover this, however I strongly recommend IMPORTING the data into Access from Excel if it's something you're going to work with on a regular basis.

[@johnchristophersunol2378]

a carry on of greatwork

[@599CD]

My pleasure

[@vrijendrabalaji7768]

U just dont need to say thank u..bcoz we need to say it ...osmm content..

[@599CD]

My pleasure

[@phattyj811]

I lost it at 1800 druidia!! well done sir!!

[@599CD]

Haha Thanks

[@atulsuri680]

VERY NICELY EXPLAINED.KEEP IT UO.

[@599CD]

Thanks

[@beandavid3651]

I am trying to do this to teach English and I need to record my voice as I read words and sentences....how do I record voice and how would someone be able to hear it??? btw these are excellent videos...thank you!!!!

[@599CD]

You can record sound clips using whatever audio program you have. Then, don't save the clips in Access, just the file locations. 599cd.com/Images uses the same technique. Then you can use FollowHyperlink to play them. 599cd.com/FollowHyperlink

[@Amenofhiz]

There is a question, in the AutoNumbre can i add a time for example : (Year)-AutoNumber or in the advance clases i get that info?

[@599CD]

599cd.com/Counter

[@joysrayil5973]

Excellent video

[@599CD]

Thanks

[@sarahmiracle6508]

Question -- I am creating a database to store a LOT of information about clients. More than just contact information, each client has a profile with household member information and living preferences. Would I create one table with the client contact information AND all the fields for their profile (would be around 40+ fields), OR would it be best to create a separate table for their extra profile information?

[@599CD]

Sarah Vowels There's no reason why you couldn't have one table with 40 fields in it. If you're talking about hundreds-of-thousands of records, however, you might want to make one table with the info you'll have on EVERYONE (name, address, phone, etc.) and then a second table for the details you only have one SOME of the clients (demographics, etc.). This will save space in your database, BUT I wouldn't worry about it unless you've got LOTS of data. I cover this concept when I talk about "extended customer info" in my Access Expert Level 4 class: 599cd.com/XLRZML

[@MrFriedgreentomatos]

Great Tutorials, how do you spellcheck the fields (or entire table) please?

[@599CD]

F7 just like Word

[@Mikebtracks]

You are connecting the dots for me sir

[@599CD]

Sweet

[@muznjamal5807]

thanks a lot it is very helpful.

[@599CD]

Welcome

[@princesoler3184]

after saving there is an error msg appear its says you cannot change one field from an autonumber data type and add another autonumber field at the same time.

[@599CD]

You've done something wrong then.

[@chandlerczy]

Great video. Love it. Thank