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
