Field names identify the table from which they come, the primary key, any foreign keys, and the tables to which the foreign keys relate.
The first three characters of the field name;
•will be the same for all fields in a table
•is an abbreviation of the table name. If the table name is one word, the first three characters will be the first three characters in the table name
•if the table name is two words the first two characters come from the first name of the table and the third character comes from the second name of the table
•if the table name is three words the first three characters of the field name will be the first letters of each name in the table name