Naming convention

Hi Joe,

Thank you for your question and welcome to the forum.

Here are some naming conventions for access:

1. Field Names with no spaces and initial caps.

2. When naming tables use tbl as a prefix and then a number followed by the table name.

e.g. tbl10Customers

3. Then each field in the customers table will have a prefix of fld followed by the table number and letter and then the name of the field.

e.g. fld10aCustomerID
fld10bCustomerName

4. Use prefixes such as frm for forms, qry for queries and rpt for reports.

I hope this helps.

Regards

Simon