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!
|John W. Vinson|
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
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
- 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
- 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!