Field name

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

2020-10

back to glossaryback to glossary