Check the properties

[jt01]

I was doing my assignment with the table in access, and my sister came up to me and ask me “why it is important to check the properties of each field in a table before developing a form based on that table.” Can anyone help me and answer this, because I don’t know how to answer her question.

 

[Laoujin]

Access does some automatic checking based on the field property. It checks that you don't give a string for a numeric field and checks the value of the field to the max size of the field. For string fields it is impossible to enter a string larger then the size of the table field.
All this is done without you entering any code.