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?

[@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

[@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

[@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

[@luwei1120]

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

[@599CD]

Thanks

[@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

[@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.

[@maqsoodkhan7451]

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

[@599CD]

Thanks

[@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.

[@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?

[@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

[@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

[@annekirkpatrick5911]

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

[@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.

[@kegenrodrigues]

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

[@599CD]

Yeah!

[@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

[@jamesneece3131]

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

[@599CD]

Nice!!! :)

[@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

[@sanogobakaramoko9531]

You are the best teacher I never met before

[@599CD]

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

[@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

[@salihubabamusa4038]

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

[@599CD]

Thanks!

[@lauramhina8151]

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

[@599CD]

You're Welcome!

[@mountainman5900]

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

[@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

[@senjeanman]

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

[@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

[@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

[@drfroglegs]

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

[@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!

[@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

[@annmannion7832]

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

[@599CD]

Thanks

[@mikesimpson8558]

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

[@599CD]

Welcome!

[@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

[@omaridaniels8427]

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

[@599CD]

Thanks

[@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.

[@sharonhemphill8398]

This is the best series ever!!

[@599CD]

Thanks

[@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.

[@SaigoRyu]

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

[@599CD]

Welcome

[@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).

[@Rowdyrecords55]

Thanks for these great lessons!

[@599CD]

Welcome

[@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

[@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.

[@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

[@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.

[@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

[@Numilex]

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

[@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

[@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

[@kgomotsopupuma9142]

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

[@599CD]

My pleasure

[@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

[@harshalshinde227]

This lectures are gold!

[@599CD]

Thanks

[@shuaibuabdulrahman9103]

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

[@599CD]

Thanks

[@bobbyebadi3111]

Thank you! I learned and enjoyed your teaching style.

[@599CD]

My pleasure

[@trwesthora]

What lesson shows me how to add a drop down menu with pre-populated options to pick from? For example, "CustomerType" might have two options to choose from: "RE" or "Homeowner" and secondly, what lesson will show me how to have a table field populated by pointing to another table? For example, "field "ReferredBy" can be populated by choosing a person listed in the "ReferringPartner" table. Does that make sense?

[@599CD]

599cd.com/Combo

[@mrbohra]

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

[@guledsm]

Thanks. Very simple and very comprehensive.

[@599CD]

You are very welcome. Glad you enjoyed!

[@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.

[@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!? :)

[@AKK93World]

at the point of saving the table, there appears the notice that onlny one field with AutoNumber is possible and I cannot save it. But I have everything exactly like in the video. whats the problem ?

[@599CD]

No idea

[@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

[@maryannmccoy4650]

I am working on Table Data View on a medical database and want to enter a temperature with a decimal point such as 98.7 F. I changed the field size to double. When I tried to save the info, I received a popup stating: Operation is not supported for this type of object. Can you help with this?

[@599CD]

I get a ton of questions every day, and I don't have time to answer them all here on KZbin. Feel free to submit your question on my website at: 599cd.com/AskYT

[@malharagu]

Simply, you are better than my professor.

[@599CD]

Don't tell him that. :)

[@caseyanderson752]

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

[@599CD]

What? You went over my HELMET?

[@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.

[@tamaratalib2521]

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

[@599CD]

My pleasure.

[@dstimpy73]

Very helpful for my database class! Thanks!

[@599CD]

Welcome

[@bobharris5583]

Very helpful tutorial. However, when I try to save the Access table I created via the Session 5 lesson at the beginner level, Access keeps telling me that the field name (even though I am trying to save a table) does not comply with Microsoft object-naming rules. The table names I tried and which were both rejected for the same reason are "CustomerT" and "ClientT". As a result, I cannot save the table I created and which I will likely need to use for a future Access tutorial. How do I go about saving the table?

[@599CD]

That's very strange, Bob. Those are both valid table names. I suspect a problem with your database or Access. Try creating a table in a blank, new database. Try compacting & repairing your database.

[@599CD]

Oh, and if you're getting a FIELD NAME that is invalid, that's not the same as your table names. I suspect you might have put an incorrect character in one of your FIELD names, like FirstName, LastName, etc.

[@bobharris5583]

599CD Computer Training Thank you for your help. The problem turned out to be that I had a "redirected" file. Never heard of it before. A senior exec where I work was able to convert the file into a "normal" one and then everything worked fine. How the file I was using became redirected, I haven't a clue.

[@599CD]

I've never heard of a "redirected" file before. :)

[@mr-fu3zu]

Very informative and helpful .

[@599CD]

Glad you liked it

[@parislarose5775]

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

[@599CD]

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

[@MrFriedgreentomatos]

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

[@599CD]

F7 just like Word

[@pkpotate]

1-800-druidia... dat spaceballs reference

[@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

[@ramirez368]

I saved the database after part 4, but it shows now horizontally values and can not add the value field to continue.?

[@599CD]

I don't understand

[@bessiechio2797]

Hello sir when im making the table and set for currency and have it as depault value as zero it does not show. How to make it show the $0 thanks

[@599CD]

It should show

[@prasadbm1978]

Thanks for making it super easy ! ☺

[@599CD]

Welcome

[@TubeSurferToo]

Excellent standards and conventions!

[@balagotrd]

Awesome video tutorial. Thank you for sharing.

[@599CD]

Welcome

[@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

[@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.

[@AlanStewartMusic]

Very helpful tutorials. thank you

[@599CD]

You are very welcome. Glad you enjoyed!

[@marwanmohammad8240]

Dear Sir, i follow your instruction an its helpful , and i am searching for the level 4 and 5 i cant find them.. need your help please

[@599CD]

They're on there. 599cd.com/ACB1

[@tomsaefke2901]

Very instructive. Thank you.

[@599CD]

You are very welcome. Glad you enjoyed!

[@musarratzaidi685]

Good methodology to explaining the text

[@599CD]

My pleasure

[@babecakes323]

Thanks for this very unique video. However I made a mistake while trying to save the Customer T name. I selected Customer B. So my question to you is; how do I change to Customer B to T??

[@599CD]

Rename it

[@ferntiger5586]

Thanks! It is easy to understand.

[@599CD]

Welcome

[@varunshetty7361]

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

[@599CD]

You're welcome

[@phattyj811]

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

[@599CD]

Haha Thanks

[@paulschneider6164]

Excellent tutorial.

[@599CD]

thanks

[@hussainali5047]

Loving it, Sir.

[@599CD]

Thanks

[@DreamWorkDrive]

thank you! Excellent tutorial.

[@599CD]

599cd.com/TimeSpent

[@stephenmcgettigan4053]

Thanks for everything this is very helpful

[@599CD]

You're very welcome.

[@RalphNgOfficial]

great video, thanks for sharing

[@shahidpervaiz6647]

Excellent training package

[@599CD]

Thanks

[@vrijendrabalaji7768]

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

[@599CD]

My pleasure