Microsoft Access 2010 Tutorials
Working with Tables / Access Data Types
Visitors to VTC.com will be able to view all introductory videos for each training course.
Free Trial Members will gain access to first three chapters for each training course.
Full Access Members have full access to VTC.com�s entire library of video tutorials.
Learn More
Subtitles of the Movie (Microsoft Access 2010 / Working with Tables / Access Data Types)
In this video I want to show you the specific Access Data Types that you're going to have to choose from when you're creating your tables. Now, I'll talk a lot about Data Types in a lot of different places in the course here, but they're very important for optimizing your database to store exactly what you need but not to go overboard and waste memory. But when you're working in Access and, by the way, let me hop out to Access and show you what I'm talking about here. When we're creating our table, and I'm in Design Mode here, when I create a new Field Name - this is going to be our column names in our table - right here is where I choose the Data Type. And notice the drop-down: Text, Memo, Number, and so forth. And so, I just want to go through these and I'm not going to talk about Calculated right now. We will talk about him a little bit later on. But, I just want to make sure that you see and are aware of the types you have and kind of what they mean in English. First of all, the Text Data Type, you're going to use that to store alphanumeric numbers. Now notice that's a-b-c's and 1-2-3-4-5's, alright? You can store up to 255 of those. And so, as long as you're storing like people's names and their names aren't more than 255 characters that's a great Data Type. The Memo Data Type is for when you need to store a lot of characters, need to write a mini-autobiography or something in there, a short novel, 65,536 characters. A Number Data Type will store numeric values. Now that's going to use 1, 2, 4, or 8 bytes, depending on something that we're going to talk about in a separate video which is called Field Size Settings, but we'll get to that later. Now if you're using Replication, there'll be a 16 byte thing there, don't worry about that. We'll get to it later. Date-Time. This is going to store your Date and Time data and this is going to be 8 bytes. And we can also tweak this one and we will talk about Date-Time formats in a separate video as well. Currency. When we're trying to store monetary data, which is going to be numbers with decimals involved, that's up to 8 bytes. AutoNumber. This is an auto incrementing number. This is a cool trick we can use in databases. I'll show you an example of that in a separate video. That guy's going to use 4 bytes. I'm assuming it's a guy. It might be a girl. And again, we can use Replication, Global Unique Identifiers, there. That would be 16 bytes. Yes-No. This is very popular in Access. These are logical values. It will indicate Yes, No, True, False. It uses 1 bit, either a zero or a negative 1. OLE Object, Object Linking and Embedding Object, and this is for storing pictures, graphs, sound, video, and you can store files here up to 1 gigabyte. A Hyperlink, we all know what that is now. This is a link to an Internet site and you can have up to 64,000 characters for a URL. That's a big URL. And then Attachments. We can attach files to the database, much like attaching documents to an email and that sort of thing. And then a Lookup Wizard which will do something really cool which is display data from another table. You'll see an example of that a little bit later on. And that's about 4 bytes. So, that's the 10 Data Types you have to choose from and we will drill into a couple of these a whole lot more as we go through the course and you'll see quite a few of these used.
Tutorial Information
| Course: | Microsoft Access 2010 |
| Author: | Mark Long |
| SKU: | 34224 |
| ISBN: | 1-936334-91-7 |
| Release Date: | 2011-05-12 |
| Duration: | 9 hrs / 121 lessons |
| Work Files: |
Yes |
| Captions: | No |
| Compatibility: |
Vista/XP/2000, OS X, Linux QuickTime 7, Flash 8 |
VTC Sign up & Benefits
- Unlimited Access
- 81,350 Video Tutorials (14,200 free)
- Video Available as Flash or QuickTime
- Over 715 Courses
- $30 for One Month Access
- Multi-User Discounts Available
