Results 1 to 2 of 2
  1. #1
    Sleepymum is offline Novice
    Windows XP Access 2007
    Join Date
    Jan 2011
    Posts
    14

    Help please in design!


    I currently have an excel log that is used to record our non-conformance data.
    I am trying to setup an access database to record the above information and I would like the data to be entered using an user form.

    I have limited experience using access and so far have messed around with a few examples. Out of this I have a few questions on how to set up the database correctly.

    1. What is the best way to set up the tables?

    These are the fields:
    Non conformance number – Number format
    Date Opened
    Initiator – Would like this to be selected from list
    Defect Owner – Would like this to be selected from list
    Shift – Would like this to be selected from list
    WorkCentre – Would like this to be selected from list
    Major Quality Issue – Yes/No

    Prd Number - – Would like this to be selected from list, If a number is picked it would autofill in the next 2 fields
    Prd Description – See above
    Material Type – See above
    Material Defect – This would relate to the material type (again a drop of options)
    Defect Description – General comments

    Initial Amount – Manual input
    Unit of Measure – Select from list
    Initial Cost – This would be a calculation of the initial amount by unit cost (this is tied to the prd number field)

    Supplier – Select from list
    Supplier Details – auto fills from supplier picked

    Final Disposition – select from list
    Final Amount – manual input
    Final Cost This would be a calculation of the final amount by unit cost (again this is tied to the prd number field)
    Date Closed

    Can anyone give me the best advice to lay this out.

    Thanks in advance for your help!

  2. #2
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    Your line breaks seem to be a good starting point for your table setup. Further, any field that you commented "..selected from a list" should have it's own table and joined to the table you want to put them in. You would either use a lookup field or a form to put those in.

    Since you mentioned you are a beginner, I'd highly recommend you read up on "relational databases" and "database normalization". These two concepts are probably the most frequent sources of database issues.

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

Similar Threads

  1. Design help
    By jacko311 in forum Database Design
    Replies: 0
    Last Post: 11-12-2009, 05:57 AM
  2. DB Design
    By Merkava in forum Database Design
    Replies: 2
    Last Post: 11-10-2009, 05:51 PM
  3. DB design question
    By dlburkins in forum Database Design
    Replies: 2
    Last Post: 08-28-2009, 07:06 PM
  4. Attendance design
    By 8rxtx8 in forum Database Design
    Replies: 0
    Last Post: 07-19-2009, 04:42 AM
  5. Design help
    By marix in forum Database Design
    Replies: 1
    Last Post: 04-18-2007, 07:54 AM

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