Field Naming Conventions

[Cosmos75]

Are there any rules to naming fields in tables?

I've seen naming conventions for tables (tblNAME), forms (frmName, fsubNAME) and reports (rptNAME).

Is there such a naming convention for fields names?
Can I just use "natural" field names? First Name instead of FName or FirstName?

Are there drawbacks to not using a tblNAME type convention?

 

[Cosmos75]

Pat,

Thanks!! I couldn't find anything about that in any of the books I have.

What do I do about an existing database where I have all the fields named with spaces?? I know you can compact a repair the database when you've changed form/query/report/field names but I understand it doesn't fix everything. Is there anything that can help out with going back into a database and revamping a naming convention?