I have to create a bunch of new fields for several free tables. The previous names given to fields were not consistent. Guess I am looking for naming tips that might make my life easier for future modifications. I do understand

1) be consistent with name given to a field. same field in two different tables should be given the same name

2) be consistent with abbreviations.

But should I ?

3) Keep the field name to under 8 characters?

4) Not use any special characters (such as the underscore)

Any other tips that you can give me will be appreciated.

Thanks

Brenda