How to Format a Microsoft Access Table Field

Video Transcript

"Hello my name is Chip Browne and I teach computer programming and Microsoft Applications classes at Steven's Henagar College here in Utah. I also create practice tests for Microsoft Office application specialist certification tests. Today we are going to learn how to format a Microsoft Access table field using Microsoft Access 2007. Microsoft Access is a registered trademark of Microsoft Corporation. I am not affiliated with Microsoft Corporation. To learn how to format a Microsoft Access table field it is important to point out the different data types. When you format a field you can format it for output or for input. The field properties below the list of field names is where you do this. After specifying the data type here in the format field property, click on the drop down list. There are some preset formats. You choose a format that applies. The input effects how data is being input. Here the input mask wizard gives you several different formats that are present or you can try your own. This is the mask that is formed by the input mask wizard or this can be custom edited. The other data types such as text and currency also have the ability to specify format and input masks. If you specify the currency format and/or you specify the input mask. The input mask wizard only works with the text or data field types so this would be a custom field that you would edit. Once again each of these have format input masks. There is one the Boolean data type that doesn't have an input mask but this does have and in format it will display either true or false or on or off depending on which one you select. So this is how you format a Microsoft Access table field. For output it is the format field property for input it is the input mask. For more information and videos visit me, Chip Browne, at chipbrowne.com."