How to Define a Date Format for a Microsoft Access Field

Next Video:
How to Define a Many-to-Many Relationship in Microsoft Access....5

In Microsoft Access, the definition of a date format means creating a date field in which an individual must specify it when designing the table. Discover how to modify the date format with help from a computer programming teacher in this free video on Microsoft Access.

Part of the Video Series: Microsoft Access Tutorial
Promoted By Zergnet


Video Transcript

Hi, my name is Chip Browne. I teach computer programming in Microsoft Office applications at Steven Henagar College here in Utah. I also create practice tests for Microsoft Office applications, specialists, certifications. Today we're going to learn how to define a date format in Microsoft Office Access 2007. Microsoft Access is a registered trademark of Microsoft Corporation. I am not affiliated with Microsoft Corporation. To create a date field you must specify it while you're designing the table. Or to modify a date type you need to have a table with a date field in it. Here is a table which has date fields in it, order date and shipped date. To modify the date format and see the options available we need to go into design view. Here we have order date and shipped date, the format date/time in both. When we click on this we see that the field properties panel updates to have the format of that date. If we click on this there's a drop-down here and this is the various types of date formats we can have in this date/time field. It can be a combination of date and time or date or time. Let's chose medium date. We save this. And when we reopen that tail we see that the format of our date has now been changed to medium date. This is how you specify the date field format type using Microsoft Access. For more information and videos please visit That's Chip Brown with an E .com.


Related Searches

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!