Microsoft Access 2010 Tutorial Part 04 of 12 - Customer Table, Part 1

[@diamondrose34]

I just started my Access class a few weeks ago and have been completely lost. Watching your Access Tutorial has been extremely helpful. I feel like I've found gold!

[@TheMICHELL54]

I never used MS Access so I decided to search KZbin for a class. So far I'm satisfied and I can learn at my own pace without worrying about grades! Thank You

[@ndimoforatanga7512]

I have just started studying data base management systems and found your tutorials on Access 2007 2010 a wonderful starting point. I will like to complete the tutorials before settling down to precise comments. Thanks, AMIR, and do not stop.

[@iezzieg]

Being an instructor myself, you're right, repetition is the best way of learning. Some people are so ungrateful....thanks for all you do. Keep doing what you're doing!

[@caps008]

Hey just want to say you are a big help, My database teacher at Uni is useless! Iv only had 4 classes so far with him this semester and Iv learnt more from your first 3 videos than all my classes at uni, thanks heaps for the tutorial vids. It is a great help to me, will surely subscribe!

[@599CD]

@tfortwins660 Just go back into table design and change the data type to text. You shouldn't lose any existing data since numbers will easily become text. Going the OTHER way can sometimes cause problems.

[@599CD]

I would go with either a NUMBER (double) field and store the length in minutes (like 90.5) because you can always format that in different ways. OR you could use a date/time field and store minutes:seconds. The choice is yours.

[@599CD]

Ideally, yes... you would have a Country table that would list the country code and full country name, and then another Currency table that would like the currency code and it's full name. Then, if you want, you could have a currency FIELD on your country table so you could specify the currency for each country. Now, this is getting WAY beyond what I cover in my Beginner Access tutorials. Relating multiple tables together is getting into my Expert Level material (201+).

[@599CD]

I honestly don't recommend storing ANY external files in your database (as attachments OR objects). Personally, I recommend storing the files in an external folder and just saving the FILENAME in your database. You can still launch the PDF if needed from inside Access. I cover something similar with graphics in my ACCESS IMAGING SEMINAR: 599cd(DOT)com/XACIMG

[@599CD]

I explained why you should use TEXT and not numbers for ZIP codes in the video.

[@599CD]

This is a video for Microsoft ACCESS, not PowerPoint. However, it sounds to me like you just need to insert a text box or some other object on your slide that will allow you to type in it. I always set up ONE slide and then just copy and paste it to make more. If you need more help, don't post here (again, this video is for Microsoft Access). Contact me via email or my web site.

[@Chiko6666]

You're a great teacher Rick, and a great help! Thanks for the lessons.

[@599CD]

Nope. You would need a 2nd table, related to the first, with a DateTime field in it. You can set the default date to =NOW() and that will put the current timestamp in the record. I cover this in my EXPERT series of classes because it involves multiple, related tables.

[@deannahautz6527]

Richard, is there a way to put a automatic date stamp for each entry in the Notes field?

[@twilishyflutter]

having major exams on this on my coarse im taking..spent my last week watching this...i got an A..TYVM

[@jaworskij]

6:27 - Is that true? I use LibreOffice and the AutoNumber starts at '0'. I usually don't put anything into '0' and just use it for "Testing".

[@599CD]

Access starts at 1

[@TraderS75]

Your Access tutorials are superb!

[@599CD]

Thank you... thank you very much...

[@LordStanley94]

Thank you very much for taking the time and uploading these videos. Do you offer full blown courses on Access? I am assuming these are bits and pieces, right?

[@nazyrnezer9680]

being trying to buy database software even tried paying to make one when all i needed was a goo tutorial. Thanks

[@heismyhightower]

Hello, I do hope you can help I'm getting at my wits end here I opened my PP2010 & wanted to start to do a presentation I have a problem being able to type, every time I bring up a Blank slide & hit a key to start typing a chime rings & it will not let me type anything The weird thing is that when I use those arranged slides for titles etc. it allows me to type . I've already did 2 successfully in the past. Do you have any ideas? I am new at this. Any help would be so greatly appreciated.

[@nickwalco]

if you want to create a length of movie field name what should you use?

[@Rincon009]

Question about tables: I have currency and country information that I am trying to put in tables. My excel sheet is like this Country , CountryCode , Currency , CurrencyCode (ie,American Soma , AS , Euros , EUR). Do I need a table for Country with CountryCode and another for Currency and Currency Code?

[@arthurkandakai4002]

I love and enjoy your lesson. I will specialized in IT/ICT, Most especially in database management

[@annaMiyam]

Can I use Access for inventory? Or record a product delivery?

[@ashleyoneill304]

Hi Can you add information quickly that you already have saved in an excel file to your customer table I.E copy and paste or lookups??

[@599CD]

Absolutely. I cover this in my advanced classes.

[@599CD]

Screen capture software. I use HYPERCAM.

[@oblvion]

How do you record what you're doing as a video?

[@599CD]

Thanks for the clarification. It's hard to keep them all straight sometimes. :)

[@JevonOng]

Thank You for your effort. Really appreciate your video.

[@599CD]

I should clarify my previous response by saying, "YES, it's possible, but it will involve some programming, and you really shouldn't do it this way anyhow, so the answer for all practical purposes is 'Nope.'" :)

[@kieferonline]

Just for convenience, if you specify the zip code as a number, it will automatically drop the first digit if the zip begins with a 0.

[@cygealogo]

this is really helpful. thank you so much for creating this tutorial. you're so great! :)

[@TheOliverjhoy]

Thank you very much for sharing your knowledge God bless you sir...

[@599CD]

This is the complete Level 1 tutorial for Access 2010. All 2.5 hours of it are here on KZbin. I've got many hours of additional video tutorials (Levels 2 to 9) plus many advanced lessons and seminars available only on my web site at 599CD(dot)COM.

[@gobindwalecha6101]

excellent presentation making learning very simple, great work

[@599CD]

Thanks

[@599CD]

You're very welcome. Thanks!

[@tfortwins660]

Hello, I have a question.I accidentally selected PostalCode as Number. How can I change it to Text after I Saved the table? Thanks..

[@HelloMyNamesNino]

Great tutorials, thanks for your effort.

[@tammymatthews6924]

If a field in your table has set values, is it better to create another table for those values only? For example, in an Employee Table, you could have a Role field, that has 10 set values for different roles in the company. Should you therefore have another table for Roles? I guess my question is this - if a field always has set values - should that field be getting it's values from another table?

[@599CD]

Tammy Matthews Yes, you would use a Roles table to list all of the roles, then you could use a COMBO BOX to select a role for each employee. I cover using multiple tables together (with relationships) in my Access Expert Level 1 class: 599CD.com/XVDWN2

[@monicav6535]

I am trying to build a database by finding a product by it's characteristics. For example vent, 2c, hinge... etc. Is it possible to look up something from the Notes section (Memo) section using search?

[@599CD]

Sure. 599cd.com/Ask

[@rcx8666c]

ARE WE DESCRIBING THE NATURE OR FORMAT OF THE PARAMETERS OF THE DATABASE HERE ?

[@599CD]

Huh?

[@lbtvnews]

Great help! Thank you for doing this.

[@Rincon009]

Thanks for responding! I really really appreciate it.

[@joyjamiebrady]

Im working on my budget. I've inserted my checkbook from my bank to my excel. I'm new to Access. I'm familiar with Excel formulas, but not IF Functions. How can I create a link from an item's value to a specific column, based on the category to which it belongs? My columns are Date, Transaction, Category, Debit, Credit and Balance. Then, I have each category individually named, for each column. I've been copying the amount from the Debit column and pasting the link in it's coordinating category column. But I don't want to continue doing that for every single item. The purpose is to have a column for Income, Deposits, Utilities, Fuel, Groceries, Medical, Eating Out...and so on. It makes it easier for when I want to see each month's totals, and the yearly total for taxes. What tutorial do you suggest I look at for this? Thank you so much!

[@599CD]

tl;dr

[@lesettew7331]

very informative, well explained

[@princesswarrioramy]

If I want to run a query on my clients who have a birthday in Janurary then I use that data to link in Publisher to make birthday postcards. Currently I'm using Excell and just filter the birthday field to find January birthdays then past the data in another excell sheet which I link to publisher to make the birthday cards. As I convert to Access, do I need to create a separate field for Birthday Day, Birthday Month, Birthday Year, or can I use one birthday field?

[@599CD]

599cd.com/DateSerial

[@samanthahayes3679]

Would you make "PostalCode" a number field?

[@jaworskij]

No! If you're referring to Canadian Postal Codes, such as LNL NLN (where L=Letter/alpha N=Number) then use a Text field instead.

[@599CD]

Even US ZIP codes I would make TEXT fields.

[@markusulrichsen1879]

Isn't it wise to limit the amount of characters for e.g the FirstName and LastName field? A field size of 255 characters is way more than any name requires. :)

[@jasonblack4208]

thank you for the free videos! my broke, college-going ass needs to develop some marketable skills. no time like the present! XD

[@599CD]

Still a broke college kid? :)

[@jasonblack4208]

@@599CD i got a job with a prop trading firm, but I'll be kinda poor until my account grows a bit 😂

[@korndog87]

mate...you could teach a dog.....your that good

[@599CD]

I've been trying to teach my dog how to properly walk on a leash without pulling. It's definitely a challenge.

[@NooR-zp5lf]

​@@599CD😂 your a great teacher 🙌🏻

[@ChrisGordon15]

I am sure the answer to my question will present itself in future videos. When I format a field to accept numbers it only accepts integers. If I enter a fraction it doesn't accept the input and if I enter a decimal it follows math rounding rules.

[@599CD]

Change to a Double

[@irmajulita585]

fantastic tutorial..

[@billjuss5331]

Thank you, another great video/youtube... Can't wait for the next one...

[@599CD]

You're welcome

[@DanielWhite46]

Awesome thanks man

[@petrapetra2002]

we have postal codes D1 , D2 .........D12 so I think it will be better text

[@elsie992]

Wonderful!

[@TreyA64]

Your Postal Code Table entry would be numerical, not text.

[@heismyhightower]

Your right LOL. Thanks much!

[@makleapheng3500]

good

[@599CD]

Thanks

[@chughakshay20]

he should sell a book or something

[@599CD]

I actually did write a book on EXCEL: cigexcel.com --- I tried to get my publisher to let me write an Access book for them, but they weren't interested. :( I focus mainly on video as I personally feel that's the BEST way to learn. Books are great, but video is even better.

[@muhammadadnanakmal9590]

599CD Computer Training Thanks Sir Awesome tutorials Please Sir you must make a fan-page on Facebook where we recive your channel update

[@lilibethspencer4256]

You actually explain it in the next lesson, not this one.

[@hradyendra]

first two parts are boring but fourth got my attention

[@599CD]

cool

[@Kevovaz]

The voice could be less of a drawl, and you could stop referencing things you've already mentioned in the last two videos, if I wanted to hear the same old stuff I would have clicked on a previous part. And I can't tell if I should really take these 'lessons' seriously as half of your instructions are 'personal preference'.

[@599CD]

Thank you for your opinions, however I find that repetition is often the best way to reinforce learning new topics. You don't have to follow my personal preferences, however the reason I give them is so that you can benefit from my 20 years of experience with Access. There are many ways to do things in Access. I'm trying to save you time by showing you my recommendations for best practices, and to avoid poor ones. As far as my voice goes, that's usually the one thing I get the most compliments on. Sorry you don't find it to your liking.

[@tommyquentin]

599CD Computer Training Keep it up! Love the videos, and agree repetition is key especially for me for it to fully sink in. Thanks for the videos!

[@ultimatepirate9589]

+PC Learning Zone - Computer Training people always find shit to complain about XD sir your videos are awesome