4. សិក្សាអំពី Field Properties ភាគ១  | Field Properties part 1 Microsoft Access 2013

សូមអរគុណចំពោះការទស្សនា សូមជួយគាំទ្រស្នាដៃកូនខ្មែរដោយ​ចុច Subscribe និងតាមដាន​សិក្សារាល់គន្លឹះល្អៗជាច្រើនទៀត។

  Field Properties
Controls the appearance and behavior of fields and data type.
1. Field Size
Set the maximum size for data stored as a Text, Number, or AutoNumber data type.
2. Format
Format data that appears in field by default when it is displayed or printed.
3. 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.
4. Decimal Places
Specifies the number of decimal places to use when displaying numbers.
5. New Values
Determines whether AutoNumber field increments with each new value or uses random numbers. Select one of the following:
  +Increment   Starts with the value 1 and incrementally increases by 1 for each new record.
  +Random   Starts with a random value and assigns a random value to each new record. Values are of the Long Integer field size, and range from -2,147,483,648 to 2,147,483,647.
6. 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.
7. Default Values
Automatically assigns the specified value to this field when a new record is added.
8. 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.
9. Validation Text
Enter a message to display when a value that is entered violates the expression in the Validation Rule property.
10. Required
Requires that data be entered in the field.
11. Indexed
Specifies whether the field has an index. There are three available values:
  + Yes No duplicates Creates a unique index on the field.
  + Yes Duplicates OK Creates a non-unique index on the field.
No   Removes any index on the field.
NOTE: Do not change this property for a field that is used in a primary key.
Although you can create an index on a single field by setting the Indexed field property, some kinds of indexes cannot be created in this manner. For example, you cannot create a multi-field index by setting this property.
12. Smart Tags
Attaches a smart tag to the field. Smart tags were deprecated in Access 2013

ទំនាក់ទំនងព័ត៌មានផ្សេងៗតាមរយៈ Contact and Follow me via:
Youtube channel: https://www.youtube.com/channel/UC5VaqqGRMNczOIVYJTIY6mA
Facebook Fan Page: https://www.facebook.com/hosicam/
Google+: https://plus.google.com/communities/100067385720145087107