Question: how to change date format in microsoft access?
Answer: Open the table in Design View.
In the upper section of the design grid, select the Date/Time field that you want to format.
In the Field Properties section, click the arrow in the Format property box, and select a format from the drop-down list.