With time, any application is growing into dozens of tables, queries, forms, etc. It’s getting more and more difficult to find an object you need. To simplify this process, I use the following naming conventions.
- t<suff>Name – various tables:
- tblGeneric is for an ordinary table
- tdocDocument – a table for documents of a special type. E.g, I use tdocCalculation to store calculation documents. Usually, I use documents whenever I need to log an event in time. A document might move registers.
- trefReference – a reference table.
- tregRegister – a register table
- tsetSettings – a system table for application settings
- q<suff>Query – various queries
- qryQuery – a simple query
- qaddQuery – an INSERT query to add some data to a table;
- qupdQuery is for an UPDATE query.
- <pre>f<suff>Form is for various forms:
- frmForm is a generic form;
- sfrmMainSubform means a subform for a main form. A good example would be sfrmCalculationTransactions for list of transactions in a calculation.
Code naming convention
Table columns have lower case names with words divided with underscores.
Code variables of different types have 1-3 character prefix indicating their type and CamelCase compound words writing practice.