Microsoft Access 2010 Tutorial Part 05 of 12 - Customer Table, Part 2

[@jimmyd6223]

First of all, thank you for putting this training together to teach us ignorant folks but that's not why I am leaving a comment. I'm on Microsoft Access 2010 Tutorial Part 05 of 12 - Customer Table, Part 2 at the 2:17 minute mark and saw the number 1-800-DRUIDIA and knew right away that was a Spaceballs plug. I really appreciated the laugh in the middle of your instructions. Thanks and have a good one my friend.

[@599CD]

Sorry for taking 5 years to get back to you... but my Winnebago crash landed on some desert planet and I was lugging around my industrial strength hairdryer. I CAN'T LIVE WITHOUT IT!

[@mikeoxbig4705]

Four lessons in and about to start Lesson 5 and I feel like I am accomplishing so much more than my previous attempts. Thank you and I have subscribed. Great job so far of explaining even simple tasks. I feel comfortable navigating but I need MORE instruction and will continue. Brass knuckles and Jesus. God bless us ALL. Thanks again!!

[@VincentTarantini]

I must say, your teaching style is excellent. Very clear. Many thanks!

[@599CD]

I don't understand your first question about the check boxes and preventing "multiple duplications." Please elaborate.

[@599CD]

You want to store information entered into a web page in your Access database. Yes, this is certainly possible. You have to use a server scripting language like ASP to do this. I cover it in some of my advanced seminars, but like I said before this is WAY too complex for me to help you here.

[@denisea3465]

This is helping me so much, thank you! I would like your opinion on tables. If I were to create a library catalog of books, handbooks (no isbn, not mass published works), cd's, and notebooks. Would you make a separate table for each? I started that way, but there seem to be so many things that fall into a grey zone between each, very old military handbooks, for example. Is there a standard for how to determine what separate tables to create?

[@599CD]

Always store phone numbers as text. The only time you want to use a NUMBER is if you're going to be performing CALCULATIONS on a value, as I talk about in the tutorial.

[@599CD]

I would make ONE table for all of your books. You don't need to fill in every field for every book. If a book doesn't have an ISBN for example, leave it blank. You can categorize them with a CategoryID.

[@felixpalmer7665]

our grade nine class is using these videos to learn about MC access. thanks!

[@599CD]

Sure. You can create an aggregate query, then add ZIP code twice: once GROUP BY and another COUNT. See my "Microsoft Access Aggregate Query" video for more info.

[@ricklwb]

Very nice job. Wish I had this when I was trying to teach it myself. Much better than a book.

[@599CD]

The answer to your second question is "no." You cannot have multiple fields in a table with the same name. Each field needs a unique name. If you're dealing with selecting multiple items, you should use a second, related table and most likely a subform.

[@vdogaymer]

I have a job interview tomorrow, hopefully your vids will help me snag the job :)

[@599CD]

Good luck.

[@atulsonisadhna]

This is the best training module I have come across on the Internet. Thanks so much....:-)

[@adolfohernandez3446]

Hi, thanks so much for these tutorials! Do you have sample data we can use to build the database?

[@captanoperlib]

Through the lessons that you described. I think that each one can be programmed access. I appreciate you these lessons, which made me understand most of the lessons. And thank you very much for this fatigue.

[@599CD]

Welcome

[@djkaotic1989]

Thank you for puting these videos together. I'm learning so much in such little time. 1-800-DRUIDIA !!! Love the Spaceballs reference !!

[@599CD]

What? You went over my HELMET?

[@599CD]

Unless you have just 1 or 2 people, I would recommend using a second, related table to store individual employees for a company. I cover this in my Access Expert Level 1 class. See my web site for details.

[@kraigorcutt1394]

It's great to have a basic understanding of Java and to already know the integer sizes. =)

[@jaredc8281]

In your video you say you like to use text fields instead of numbers when it comes to zip codes. So if you wanted to run a report on sayy, how many customers live in a certain zip code, would the report know what you're asking for? Even if its in a "text" field and a not a number field?

[@Lomaxient]

Gliding through these so far, cheers boss!

[@599CD]

My pleasure

[@partyrockerchun]

awesome videos was able to help my niece in her project

[@TankenkaNeko]

Question, I toyed with Access a bit after watching these this afternoon, and noticed that a full length phone number does NOT fit for "long integer" under numbering... I of course just set it to text after, but I wanted to play with something. This meant that a number with an area-code was truncated by 1 number space (so 5558884444 appeared as 555888444 and the last number wouldn't work) Suggestions? (I used decimal to fix this and set it to 0 decimal places).

[@BlossomOu1989]

Your video is very good. Thank you so much. You are a good instructor.

[@PigBosley]

Hopefully this tutorial will be enough for me to test out of my intro to Microsoft.

[@newmwafaq]

Thank you so much .these saved me alot of time that i needed. still im on my knees begging for videos about ES-Builder (Expert System) . the problem is i need it as soon as possible ,Today befor tomorrow . is it possible? plssssssss thank you

[@gaillove04]

I need this program for a job... I am learning a lot thanks!

[@azifri]

I feel like I am actually learning this! Will see how it goes over the next videos :3

[@599CD]

Sweet

[@599CD]

Dylan, what do you mean "do a password?" Can you be more specific?

[@599CD]

I would make a COMBO BOX that has "boy" and "girl" in it. You could save the values in a Yes/No field and just make girl 0 and boy 1.

[@MatthewJBurns89]

Hi What would be the Data type with a field that is a room number but the room number might have a letter in it. I will need to sort these room numbers from 1 to 5 as well as 1 to 5A 5B 6 7A 7B and so forth.

[@Deep_Thoughts99]

please make a video on topic, how can i find the next available number in the table. i will be very grateful to you

[@hadireg]

Awesome way of putting things! Thanks!

[@599CD]

You're welcome.

[@norina195]

Sounds a bit complex and a bit of programming...do you explain this in future classes?

[@dylanforsyth6165]

I meant how do make access recognise a password so it is able to be lined to an html web file - preferably without lots of coding (only if neccessary)

[@margarett3762]

Hi, is CustomerID (the indexing) similar to excel row numbers? What is the difference between tables and table design? Why make CustomerID the primary key? What is the purpose for the primary key?

[@599CD]

The purpose of the primary key is to maintain a unique identifier for each record. You may have 100 "Johns" in your database, and even 25 "John Smiths" in your database, but you'll never have more than one customer ID #82723.

[@pranshul67]

Thankyou for the informative lessons. Keep posting. Great help!

[@599CD]

welcome

[@599CD]

I still have no idea what you're trying to do. Can you please be more specific? I assume you mean "linked" to an web page, but what are you trying to do? Import data from a web site? If so, that's WAY beyond the scope of these beginner lessons. Contact me privately for help.

[@jahnava]

Hi I have a question, I'm having such a hard time to add 4 or 5 contacts name in a contact, that I already created. The contact name that I created, it's under the name of the company, now what I would like to do it's to add the name of the people in charge and their positions. How can I do that??? SOS HELP thanks for your time :)

[@norina195]

I'm thinking about creating a database for a large kindergarten school. If I want one field to be Boy/Girl, how do I manipulate the "Yes/No" field?

[@trycatchangler]

Thanks, these lessons are great!!

[@Murdershaunwrote]

Gotta love the cheeky Spaceballs reference in there!

[@rcx8666c]

GREAT JOB "PC LEARNING ZONE" I ENJOY WATCHING YOUR VIDEOS.

[@599CD]

Thanks

[@tfortwins660]

Thank you for the TEXT and NUMBER hints....

[@599CD]

Yes. Level 1 is only the first of MANY levels. You can find them all on my web site at 599CD(dot)COM.

[@pmdelgado01]

Thank you very much, great video. Can't wait until I get your more advance course. I have a question: I need the CustomerID, which in reality is an employee ID to be assigned by me, since this is their HR assigned number. How can I do that? Thank you PedroM Semper Fi

[@599CD]

I use two fields - one is the Autonumber ID that Access generates. Create a second field for yourself if you need to track a "real world" number.

[@pmdelgado01]

599CD Computer Training Thank you very much

[@599CD]

Sorry, but I don't use ES-Builder at all.

[@RicardoBarreraArellano]

Hi! Is there a reason why you put "CustomerID" instead just "ID" for the primary key? Thanks in advance

[@RichardRost]

I find that it becomes easier, later on, when you're working with forms and queries that have joined multiple tables together to refer to CustomerID and OrderID than have to remember the more complicated nomenclature of [CustomerT]![ID] and so on. Just one of my personal preferences. I like to name the primary key TableNameID.

[@RicardoBarreraArellano]

Richard Rost Got it! Nice tip. Thank you very much!

[@599CD]

You're welcome

[@heathergarcia8331]

Hello, I am doing your tutorial and Access doesn't give me the option of memo as a data type anymore. Must be from newer versions. Anyway, I used Long text instead. Could you let me know if this is right please ?

[@599CD]

You are correct. See this: kzbin.info/www/bejne/r6LGpZiGftmYjs0

[@harissid]

how did it automatically make customerID field, the primary key? Because it is on the top?

[@599CD]

Yep

[@sava1606]

Can the primary key be something else other than the Customer ID? I'm building a database of school children and each has a unique Admission Number.. Can this be my primary key?

[@599CD]

I strongly recommend an Autonumber for your PK. Keep that admission number in their record, sure, but the PK should be an Autonumber. See 599cd.com/Autonumber

[@TardesdelpsconelVicMac]

Thank you. Excellent tutorial

[@nausheennadeem4523]

salam, can we print alpabetically list of names of customers in access please or numerical list of any data ?

[@599CD]

Sure can.

[@KainOfNosgoth]

Such an amazing lecture.

[@599CD]

Thanks

[@dr3dmodel]

How can I change the currency symbol for different countries in Microsoft Access?

[@599CD]

This is something you handle in your Windows Control Panel under Regional Settings.

[@kelvinscott7509]

Thank you: you are a good teacher.

[@no-wahala9738]

my access won't allow me to set the display control of YES/NO datatype fields to Text Box. It will allow check box, but I want a drop down box to appear so that i can click YES or NO. How do I resolve this?

[@599CD]

You want a COMBO box.

[@kathiefortner9335]

Why is the Postal Code field before the Country field?

[@599CD]

Kathie Fortner That's the way it would appear on postal mail here in the USA. Name, address, city, state, ZIP, country.

[@fracturedude]

Ahhh your a spaceballs fan. Nice. Are all your passwords 1,2,3,4,5,?

[@RedDog-ql5ry]

Did you just reference Space Balls- haha! that's awesome! Trying not to crack up at work...

[@599CD]

What...? You wen't over my HELMET?

[@TheWskiller]

i need this for my exams thanks!

[@599CD]

This is not easy to do. I do cover how to do this in my SECURITY SEMINAR. You learn how to lock down your database properly, set up user logons, and track everything they do with an audit trail. It does require some programming. You can learn more about it on my web site at 599CD(dot)COM/XSECYTC

[@599CD]

Sure. You can find the sample databases use in all of my classes on my web site here: 599CD(DOT)com/XW3IK2

[@loriec0ver]

Ha! Love the 800 number you used. One of my favorite movies. :o)

[@edwardsherman6309]

Thanks for this tutorial, excellent!

[@599CD]

My pleasure

[@gelineavenir5905]

Excellent video!

[@599CD]

Thanks

[@MiSsToyaBoo]

Great videos! Thanks a million!

[@ProveThyself826]

what are queries wizard ? my teacher taught me but i still dont get it is function ._.

[@599CD]

+joel miracle I never use it. Just build the query from scratch using the techniques I teach in my lessons.

[@tooa115]

Thank you very much for this tutorial

[@599CD]

Welcome again

[@isaiahakaic6386]

You should creat some podcast. I have poor reception when I'm not connected to wifi

[@599CD]

I thought about an audio podcast, but I don't think it would work for what I'm teaching. It's very visual. You can download my paid video lessons from my web site, however.

[@enidbrechbiel5030]

Thank you so much for the training :)

[@599CD]

Welcome

[@tasneemnasir5984]

Thank you so much it really helped me .

[@599CD]

My pleasure

[@hebatallahrefaei1098]

Very useful!! Thank you.

[@599CD]

Welcome

[@ronarnett4811]

My access 2013 does not have a Memo field available. Office 365.

[@599CD]

It's now called Long Text. Same thing. Different name.

[@dylanforsyth6165]

How do U do a password ???????

[@darkseidjoe]

Does that make you a Druish programmer?

[@neurobiogirl]

Thank you... so helpful...

[@shorty52732]

Is that a spaceballs reference i just seen????

[@stevennaraine9429]

This is great.

[@599CD]

thanks

[@Cwh456]

I legitimately laughed when I saw the Spaceballs reference. Well played.

[@599CD]

:)

[@599CD]

You got it. :)

[@599CD]

It's not complex at all, and there's no programming. I teach how to make a simple combo box with static (unchanging) data in it in my Access Beginner 7 class which you can find on my web site at 599CD.com.

[@599CD]

See my video "Microsoft Access Form with a SubForm Tutorial."

[@arxidolatriae]

thank you!

[@Dseath]

2:14 Spaceballs easter egg!

[@599CD]

Yesss!!!! :)

[@rcx8666c]

WHERE IS THE DATA ITSELF BEING STORED ?

[@BosticReiva]

+rcx8666c bruuuuh

[@599CD]

In a table in your ACCDB file.

[@akash2647]

Hey just thank you so much

[@599CD]

You are so welcome

[@zohaibch823]

Thankyou very much

[@599CD]

I have a video like this using the DMAX function: 599CD-dot-com/X6MOSG

[@newmwafaq]

thank you .

[@tfortwins660]

Thank you....

[@599CD]

No. I would never use anyone's REAL SSN in a video.

[@UrbanChaos20]

Thanks a lot :)

[@599CD]

Only on my luggage. :)

[@shanehoppus6294]

VERY USEFUL.......I STILL REMEMBER THE DAY MY RACIST TEACHER MADE ME DROP OUT OF THIS UNIT IN MY STUDIES.........SHE DID NOT BELIEVE IN ME..I HAD TO QUIT.......BUT THANKS TO YOU...........YOU'VE EXPLAINED EVERYTHING TO ME SO FAAR......YOU'VE KEPT ME INTERESTED :)

[@599CD]

OK

[@latashamccray8246]

If this video gets me this job, I'm gonna find you and kiss you man!!!

[@599CD]

LOL. I live in Florida. :)

[@wjliu9267]

thanks a lot+1 :)

[@dylanforsyth6165]

same I am only 13 but need 2 find out how for school thx anyway

[@599CD]

:)

[@lindamermaid]

1-800-DRUIDIA? I don't have to put up with this! I'm RICH!

[@599CD]

WHAT!? You went over my HELMET!?