【转载 / 文章】Access开发者的摩西十诫

LucasLynn

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.



1.Thou shalt design normalized tables and understand thy fields and relationships before thou dost begin. 在开始编程之前，应当先完成表设计、数据常态化、了解每个字段和关系。



2.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. 永远不要允许你的用户直接看到或者编辑数据表，而是必须通过窗体来进行。不要使用查阅列。



3.Thou shalt choose a naming convention and abide by its wisdom and never allow spaces in thy names. 你应当选择一种命名规则并且严格遵守他，决不允许有任何一个例外。



4.Thou shalt write comments in your procedures and explain each variable. 你应当在你的过程/函数中加入注释，解释每一个变量。



5.Thou shalt understand error handling and use it faithfully in all thy procedures. 你应当理解错误处理，并且在你所有的过程/函数中忠实地使用他。



6.Thou shalt split thy databases. 你应当分离你的数据库



7.Thou shalt not use Autonumber if the field is meant to have meaning for thy users. 如果一个字段对你的使用者而言有任何应用上意义，不应当对其采用自动编号。



8.Thou shalt not copy and paste other people's code without at least attempting to understand what it does. 你不应当复制/粘贴他人的代码，而没有哪怕至少是尝试着去理解这段代码是做什么的



9.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. 你不应当使用“SendKeys”“Smart Codes”或“GoTo”（除非GoTo作为错误处理的一部分），他们将把你导向错误的方向。



10.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!

leyan2016

经典

honot

学习学习

cpxie

学习了

zenweng

谢谢指教！

leonshi

学习了

evayx1022

学习学习

accessbenhum

其余都同意, 唯独此条不解：
如果一个字段对你的使用者而言有任何应用上意义，不应当对其采用自动编号。

何解？

leifashen

太复杂了。。。直接看不懂

seanone

收获，这就是收获