Nomenclature

When designing an access database it helps to have a consistent nomenclature (naming conventions)

When referring to objects in code you will always know what the defined object is

Tables – Start with tbl

For system tables or tables you wish to automatically hide start with Usys

Access System tables start with Msys

Queries – Start with qry

Reports – Start with rpt

Code Modules – Start with mod

Macros – start with mcr – I dont tend to use macros prefer to use vba code