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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s