Microsoft Access Table Properties with Functions

Subject:

Microsoft access table properties with functions and descriptions.

Summary:

We know already that access table contains one or more columns with their respective datatypes. Every datatype keeps their own property. We can customize these column properties as per user requirement. In this Bangla Video Tutorials I shall discuss about the properties and their functions and also how to implement these properties on a column. The followings are the topics which I shall describe here:

1. What is the "Field Size"  and why we shall use it.
2. How to set "Field Size" property in a column.
3. The process to use "Default Value".
4. Why you use "Validation Rule and Validation Text" and the procedure to implement these properties.
5. The functions and the using procedure of  Format, Caption, Input Mask properties.
6. When we shall use "Required" and "Allow Zero Length" and how to use it.
7. Importance of "Indexed" property.
8. What is the time to utilize "Decimal Places".
9. How you will check condition and show your own error  message when input value will not match the specified conditions.
10. What is the difference between YES(Duplicates Ok) and YES(No Duplicates) of Indexed property.
11. Use current date in a column.
12. The step by step to set a mask for phone no and password.

Required Documents:

Click Here to get syllabus and source code file of the video tutorial series.

Video-1: Microsoft Access Table Property - Part 1.
Video-2: Microsoft Access Table Property - Part 2.

Video-3: Microsoft Access Table Property - Part 3.