Results 1 to 2 of 2
  1. #1
    justinm1015 is offline Novice
    Windows XP Access 2007
    Join Date
    Sep 2009
    Posts
    1

    Question advice on planning tables

    Hello All,

    I'm new to this site and relatively new to Access. I am in the process of creating a new database and need some advice about how to go about creating my tables. I would appreciate very much thoughts any of you may have:

    The database will be used to track important "milestones" that occur in matters that my employer handles. Basically, each customer of ours has 12 milestones that occur during the course of my employer providing its services.



    I need a way to track how far along each matter is at any point in time.

    What I am trying to accomplish is:

    1. add new customer's info
    2. automatically have the 12 milestones already listed for this new customer
    3. as time goes on and more of the milestones are completed, I will check them off

    So....each customer has 12 milestones, some customers have more milestones completed than others.

  2. #2
    dcrake's Avatar
    dcrake is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Aug 2009
    Posts
    435
    Before you actually start building your application there are certain subjects you need to read up on.

    1.Data normalsation
    2.Naming conventions
    3.Reserved words

    Having made your self familiar with the above you should be able to make a more intuative start to your project. Come back with any questions you have at that point.

    David

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

Similar Threads

  1. Advice on How to Create these Tables
    By rochy81 in forum Access
    Replies: 2
    Last Post: 05-04-2009, 04:32 PM
  2. Joining tables two tables and another table that is not
    By DevintheDude in forum Database Design
    Replies: 0
    Last Post: 09-12-2007, 08:56 AM
  3. Need advice on what I have so far
    By rumplestiltskin in forum Database Design
    Replies: 2
    Last Post: 05-25-2006, 12:48 PM

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