Sifat medan adalah satu lagi fungsi yang terdapat pada paparan jadual MS access di 'Design View'. Fungsinya adalah untuk  menetapkan ciri-ciri bidang tambahan pada jadual dan mengawal saiz medan teks, number,date/time dan sebagainya dengan menetapkan data type.

senarai field properties (sifat medan)

Sifat Medan (field properties)	Keterangan
Format	Determines the way that the field appears when it is displayed or printed in datasheets or in forms or reports that are bound to the field. You can use any valid number format. In most cases, you should set the Format value to Currency.
Caption	The label text that is displayed for this field by default in forms, reports, and queries. If this property is empty, the name of the field is used. Any text string is allowed.
field size	Determines the amount of space that is allocated for each value. For AutoNumber fields, only two values are allowed.
Decimal places	Specifies the number of decimal places to use when displaying numbers.
Input mask	Displays editing characters to guide data entry. For example, an input mask might display a dollar sign ($) at the beginning of the field.
Default value	Automatically assigns the specified value to this field when a new record is added.
validation rule	Supplies an expression that must be true whenever you add or change the value in this field. Use in conjunction with the Validation Text property.
validation text	Enter a message to display when a value that is entered violates the expression in the Validation Rule property.
text align	Specifies the default alignment of text within a control.
smart tags	Attaches a smart tag to the field.
Required	Requires that data be entered in the field.
Indexed	Specifies whether the field has an index.