The name game Leszynski Naming Convention

One of the things that can be confusing to new Access users is the Leszynski Naming Convention (LNC), the de facto standard for most Access developers. In essence, the LNC's convention is to name each object in your database using a three-letter prefix, called a tag.

The tag identifies the object's type. It is typed in lowercase letters before the object's name, which begins with a capital letter. For instance, if you're creating a table to store information about your customers, you might name it tblMyCustomers. As a general rule, you should avoid using spaces in your object names.

Most of the LNC's tags are intuitive. However, for quick reference, here are some of the most common tags, with the type of object each one represents:

tbl: Table

frm: Form

qry: Query

rpt: Report

mcr: Macro

Created Date: 05/08/2002  Last Reviewed: 05/08/2002  Rev. Date: