Browse by alphabet:
A field is a single piece of data about one person or one thing.
Many fields make up a record.
A field is usually a single column within a multi-column table.
It is good practice to give a field a sensible name. For example a name such as 1234 is likely to be useless - it hardly helps someone understand what the field is for.
On the other hand, a good descriptive field name is very helpful e.g. Surname. You are likely to understand what this is for.
Another poor practice to be avoided is the use of spaces within a field name
e.g. 'mountain height'. A space can lead to all kinds of confusion especially when forming database queries. Avoid.
There are two popular methods of avoiding spaces
a) Use capitals to form a compound word e.g MountainHeight
b) Use an underscore e.g. Mountain_height
Challenge see if you can find out one extra fact on this topic that we haven't already told you
Click on this link: Naming database fields
Copyright © www.teach-ict.com