And it came to pass that the cries and lamentations of the Access newbies were heard on high by the gods of the Database, and their hearts were moved to pity for their followers. And they opened their mouths and spake, saying: “Nevermore shall the young and innocent wander witless on their journeys! We shall provide guidance to them, yea, and to all who wish to seek the paths of wisdom.” And they caused these commandments to be written and placed before the eyes of those seeking enlightenment.
So heed the words of those who have come before you, and keep these commandments in thine heart as thou dost create thy Database application. If thou shalt only follow these commandments thy burden shall be made light and thy path shall be made straight.
- Thou shalt design normalized tables and understand thy fields and relationships before thou dost begin.
- Thou shalt never allow thy users to see or edit tables directly, but only through forms and thou shalt abhor the use of “Lookup Fields” which art the creation of the Evil One.
- Thou shalt choose a naming convention and abide by its wisdom and never allow spaces in thy names.
- Thou shalt write comments in your procedures and explain each variable.
- Thou shalt understand error handling and use it faithfully in all thy procedures.
- Thou shalt split thy databases.
- Thou shalt not use Autonumber if the field is meant to have meaning for thy users.
- Thou shalt not copy and paste other people’s code without at least attempting to understand what it does.
- Thou shalt not use “SendKeys”, “Smart Codes”, or “GoTo” (unless the GoTo be part of an OnError process) for these will lead you from the path of righteousness.
- Thou shalt back-up thy database faithfully, working not on thy Production Database, but on the Prototype Copy, as it is right and good to do.
Thus spake the gods of the Database, and blessed be their names! And Blessed, too, are those who contribute to the Access Newsgroup – giving freely of themselves to serve those who hunger and thirst for knowledge and understanding!