Naming ConventionsDatabase development includes naming object files consistently. You do this by using the assigned naming conventions for each object within Microsoft Access 2000. Naming conventions are not mandatory, but they do make your work consistent. If you plan on sharing a database with others, then it is a particularly good idea to use them.
The Leszynski Naming Convention
Object Naming Conventions
The Leszynski Naming ConventionThe naming convention used in this document is called the Leszynski Naming Convention (or LNC). Originally suggested by Stan Leszynski and Greg Reddick in a white paper entitled "The Leszinskieddick Guidelines for Access 1.x, 2.x" it has become the convention used by Access and Visual Basic developers. This naming convention suggests that you precede object names with three letters. These letters are called "tags" and enable you to open, edit, and troubleshoot without having to decode what is contained within the object itself.
Let's say you have just created a table called "My Table". The LNC way to save that table is to start the filename with the tag "tbl" (see Figure 1, below). Please note, file names can be more than one word, but underscores and spaces should not be utilized and each word within the file name should begin with a capital letter. Since databases are often shared with others, this format allows other users to easily identify the file and it saves you time when you begin to use some of the more advanced features that Access has to offer.
As you can see from Figure 1, the file name is preceded by "tbl" for table, and the file name does not contain any spaces or underscores.
Object Naming ConventionsThe same format applies to the other objects within Access, the only thing that changes is the naming convention for the object you are working with. For a listing of the different naming conventions, please refer to table below.
这个命名习惯使用在文档中被叫做Leszynski命名法则。起初这个建议被一个叫Stan Leszynski and Greg Reddick写进一张有资格的白纸里“LeszinskieddickACCESS1.X、ACCESS2.X指导方针”。现在已经被ACCESS和VB开发者变成了一种规则。这个命名规则建议使用文件开头的三个字母。这三个字母叫做标签，它能够引导你打开或编辑窗体。在一些没有解码的代码中包含它自己还可以充当故障检修员。