Access 2016 Intermediate

Lesson 1 – Setting Field Properties

Access 2016

Format

Description

General Date

The default format; if the value is only a date, no time appears; if the value is only a time, no date appears The day and month names are spelled out (e.g., Tuesday, July 4, 1995) The month name is abbreviated, and the name of the day is omitted (e.g., 04-Jul-95) The date appears as numbers separated by slashes (e.g., 7/4/95) The time appears as hours, minutes, and seconds, separated by colons, and followed by an AM or a PM indicator (e.g., 6:30:15 PM) The time appears the same as in the Long Time format, except that no seconds appear (e.g., 06:15 PM) The time appears as hours and minutes, separated by a colon, in 24-hour clock format (e.g., 18:30)

Long Date

Medium Date

Short Date

Long Time

Medium Time

Short Time



Procedures

1. Open the desired table in Design view. 2. Select the field for which you want to set a date/time format. 3. Select the General tab in the Field Properties pane, if necessary. 4. Select the Format property. 5. Select the Format list. 6. Select the desired format.



Step-by-Step

Set a date/time format.

Open the Customers table in Design view.

Page 10

OFFICEPRO, Inc.