Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    St. Marys, Ontario, Canada
    Posts
    270
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Naming fields in Access

    About a month ago we had a very long thread about the problems of naming fields in Access -- things like "never name a field 'name'."

    Does anybody know a site where I can go that explains in SIMPLE steps rules or guidelines for naming fields? What I want is a simple how-to for beginners so they will not fall into any traps later on.

  2. #2
    4 Star Lounger SteveH's Avatar
    Join Date
    Jan 2001
    Location
    Chelsea, Gtr London, United Kingdom
    Posts
    587
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Naming fields in Access

    http://www.mvps.org/access/general/gen0012.htm is a good introduction to the LNC naming convention.
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    St. Marys, Ontario, Canada
    Posts
    270
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Naming fields in Access

    Thanks for your prompt response.

    Wow, this is not simple. Are there some rules of thumb somewhere for beginners that say something like:
    1. Name all Access objects using a code determining the type. Thus a form about cities should be called "frmcity".
    2. Name all Access fields using the form name as a prefix. For example, if there was a field called city in two tables called "customer" and "employee", then the respective fields should be called "Customercity" and "employeecity".
    3. and so on....

    The above two are merely examples, but demonstrate (hopefully) the format I would like to see. I'm not even sure what I said is true. In my above example, I don't know whether I should actually have named the city field diffently in each table, particularly if they were related. But don't answer this question. Hopefully there are a very simple set of general rules out there, otherwise there will be a lot of people a bit frustrated on how to name things. Particularly people who know very little about Visual Basic and don't understand what Dim means (which is how I feel at times).[img]/S/smile.gif[/img]

  4. #4
    Star Lounger
    Join Date
    Feb 2001
    Location
    South Carolina, USA
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Naming fields in Access

    In your table, go to design view. Click in the field name box and press F1. Access' online help is good. I hope this helps!

    Deborah

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Naming fields in Access

    There is a good book called Access 97 Expert Solutions, by Stan Leszynski (of naming convention fame), that includes his naming convention and discussions of how to apply it. <A target="_blank" HREF=http://www.helenfeddema.com/>Helen Feddema's site</A> has a couple of add-ins for Access 97 and 2000 that will apply the Leszynski naming conventions to an existing database.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •