[MUSIC PLAYING] MR. HAMBURY: Now we're quickly going to look at field properties. Now, these are my fields. But how do I get to the properties? Well, I've got to change the view. So I'm making sure I'm in the correct table, going up to View, then I'm going to go over to Design View. And when I click on each one of these fields, you'll see I've got my section at the bottom here that actually says Field Properties. 

And each one based on the data type will have a different set of properties to it. Here, you can see these are the properties that relate to the data type number. If I go to surname and short text is my data type, you can see how those properties change as well. So some of the basic ones are things like your field size. This is going to specify the maximum size of the field, the maximum number of characters that's going to be going into that field. 

The next one is format. In other words, how is the value or how is the text going to be displayed? Another one is our input mask. And this is where we can put a mask, as it were, in place to make sure that somebody enters the data the way we want them to enter it. For example, if I have a cell phone number, and I know a cell phone number is 10 digits, I can put 10 zeros in place. And in that way, when somebody enters a cell phone number, they would have to enter 10 digits. 

I've also got my default value, which here indicates that there will be a specific value that I'm going to specify that will remain in that particular cell, regardless of whether I complete that record or not. So it will be there by default. 

And then the validation rule and text. Here, I can put a rule in place to say what must be entered in that cell. If the rule is met, everything is OK. But if the rule is broken, the validation text will then pop up. 

Required, probably the last one that we're going to deal with, and that just means that the data that has to be entered in that cell is required, which means you can't move on entering info or entering data until you've completed or you've entered something into that specific field. Guys, those are just some basics around our field properties. 

[MUSIC PLAYING]