Microsoft Access Day Six

Data Type & Formatting Group :

Data Type: Set the data type for the field. Data types control the type of data that a field stores, such as integers, text and currency.

Format: Specify how data is displayed and/or printed, such as what format dates appear in or how many decimal places number are displayed with.

Unique: Make it required for the values in the field to be unique for all the records in the table.

Is Required: Make this a required field. All instances of this field must contain a value.

Apply Currency Format: Apply the Current Format like Number, Text.etc.

Apply Percent Format: To Add Percent Symbol to the Numbers.

Apply Comma Number Format: To Apply the Comma Number Format.

Increase Decimals: To Add Decimal positions.

Decrease Decimals:  To Remove Decimal Positions.