Results 1 to 3 of 3
  1. #1
    andy49's Avatar
    andy49 is offline VIP
    Windows 10 Access 2007
    Join Date
    Nov 2016
    Location
    London
    Posts
    1,051

    Have we got a shorter version to direct people to?


    Naming

    http://www.databasejournal.com/featu...uggestions.htm

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,840
    short how?

    It's a good article and I agree with pretty much everything the author states

    my variations include using plurals for table names and instead of prefixing with 'tbl' to tell me it is a table, I use for example 'dta', 'lst', 'jtn', 'tmp' etc to tell me what type of table - data, list, junction or temporary

    if you take out the examples you are left with what to do - but new users generally blithely ignore such advice because they don't see why it matters, or perhaps it's one step too far in their initial steps on the development road.

  3. #3
    HiTechCoach's Avatar
    HiTechCoach is offline MS MVP - Access Expert
    Windows 8 Access 2013
    Join Date
    Jul 2010
    Location
    Oklahoma, USA
    Posts
    705
    Quote Originally Posted by Ajax View Post
    if you take out the examples you are left with what to do - but new users generally blithely ignore such advice because they don't see why it matters, or perhaps it's one step too far in their initial steps on the development road.
    I agree with you that new users to database design don't want to read that article. Their eyes roll back in their head when you mention data normalization. Beginners to database development just don't know enough to see the benefits.

    Microsoft releases Access templates that are not properly normalized or follow good naming conventions. I can see how that only makes articles on naming or normalization seam not very important.
    Boyd Trimmell aka Hitechcoach
    Database Architect and Problem Solver
    Microsoft MVP - Access Expert
    25+ years specializing in Accounting, Inventory, and CRM systems
    "If technology doesn't work for people, then it doesn't work."

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 6
    Last Post: 02-18-2016, 10:15 AM
  2. Replies: 4
    Last Post: 05-30-2012, 07:00 AM
  3. Replies: 5
    Last Post: 01-18-2012, 12:46 PM
  4. Ideas on shorter code for cascading updates
    By usmcgrunt in forum Programming
    Replies: 3
    Last Post: 12-03-2010, 12:17 PM
  5. Replies: 0
    Last Post: 12-28-2009, 12:14 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums