Creating Table in Access - Best Practices
Hello,
When I am creating tables to store data – for example product specific in a table – what are some good or best practices I need to do in the Field Properties > General for all the fields within a table?
Please suggest what best practices you have learnt from past experience.
When I am creating tables to store data – for example product specific in a table – what are some good or best practices I need to do in the Field Properties > General for all the fields within a table?
Please suggest what best practices you have learnt from past experience.
ASKER
Settings some good to have field properties for maintaining the data within the table in the long run
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you Jim,
That’s a GOLD. One question>
3. Set the Caption field, even if it is the field name.
If I set up caption in the table and then create a form out of it, then will the form display that caption I originally set in the source table? Also why would need a caption?
Thank you
That’s a GOLD. One question>
3. Set the Caption field, even if it is the field name.
If I set up caption in the table and then create a form out of it, then will the form display that caption I originally set in the source table? Also why would need a caption?
Thank you
If you set the caption, it will be picked up when creating a control based on the field.
As for why, you might have a field such as SSNum, but want it displayed as Soc Sec #
# in a field name being bad because it's a date delimiter, so you don't want it there, but might for the caption. Or "EmpID" might be "Emp ID" for the caption.
Jim.
As for why, you might have a field such as SSNum, but want it displayed as Soc Sec #
# in a field name being bad because it's a date delimiter, so you don't want it there, but might for the caption. Or "EmpID" might be "Emp ID" for the caption.
Jim.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This is perfection to the ultimate, thank you :)
ASKER
fieldProperties.png