Access naming convention

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.

Objects naming

  • 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.