Page 2 of 2 FirstFirst 12
Results 16 to 25 of 25
  1. #16
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Spend 30-45 minutes working through this tutorial. You have to do the work, but you will experience a database design process that can be used with any database. Get your tables and relationships designed to meet your business facts.



    Also, spend a few minutes watching some short free videos from BA-Experts on Business Analysis.
    Here are a few:
    https://www.youtube.com/watch?v=uIHB...PK0Jx&index=26
    https://www.youtube.com/watch?v=bPcy...PK0Jx&index=33
    https://www.youtube.com/watch?v=oLVl...VPK0Jx&index=5

    Good luck.

  2. #17
    Karaline's Avatar
    Karaline is offline Advanced Beginner
    Windows 10 Access 2013 64bit
    Join Date
    Jan 2017
    Location
    Just North Of Antartica
    Posts
    38
    Thanks for the youtube links, they were good. it isn't that part I have a problem with.

    I think i am getting over complicated with database tables from the amount of information i have been given and this is where I am getting mixed up. I was going well and then more and more input seemed to have me believe i needed more and more tables to store and restore information. from your youtube videos i found another linnk to a database structure lesson that is more indepth than the ones i have seen. and gives more fluent information than the reams of books i have already on the subject.

    I need more indepth breakdown and information on tables. i have so much information but it is all repetitive and doesn't go further enough for my needs. Thank you for the youtube links you gave me they weren't what i needed but after clicking through the lessons, i found another link, which led me to the link i hadn't tried before.

    I think my problems started when i reverse engineered Northwinds sample database. I saw the relationship set up and table outline and thought that was correct but it seems I need to go further than Northwind went.

    Only downside to Youtube videos. Data is cringeworthy to hear repeatedly - Darta not Dayta...lol

    Ask me to say Castle or tomatoe.

  3. #18
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    I know I said I wouldn't bring it up again (Post #5) , but.....
    i realised i can't explain what i require to others.
    It would go a long way to see where you are at now with the tables/relationships......
    And maybe a picture of a "Docket" (maybe filled in with bogus info) to get an idea of the data.

  4. #19
    Karaline's Avatar
    Karaline is offline Advanced Beginner
    Windows 10 Access 2013 64bit
    Join Date
    Jan 2017
    Location
    Just North Of Antartica
    Posts
    38
    I have a specific problem with 1 table normalisation question.

    It is the Normalisation of the below information that I am having issues with.
    I am unsure if I am doing the splitting correctly.


    Docket_ID
    DocketDate
    Company_ID
    Resource_ID
    CostCode
    Location
    Start
    Breaks
    Finish
    Operator
    Vstart
    VFinish
    GPS_ID
    GPSQuantity
    Misc_ID
    MiscQuantity
    Addon_ID
    AddonQuantity
    Comments
    Material_ID
    MaterialQuantity

  5. #20
    Karaline's Avatar
    Karaline is offline Advanced Beginner
    Windows 10 Access 2013 64bit
    Join Date
    Jan 2017
    Location
    Just North Of Antartica
    Posts
    38
    normalisation is confusing me on docket table. just don't know what to normalise it all seems related to docket and that is what is confusing me.
    Machine/Plant Docket Labour Docket Materials Docket
    Docket_ID Docket_ID Docket_ID
    DocketDate DocketDate DocketDate
    Company_ID Company_ID Company_ID
    Resource_ID Resource_ID Resource_ID
    CostCode CostCode CostCode
    Location Location Location
    Start Start Addon_ID
    Breaks Breaks AddonQuantity
    Finish Finish Comments
    Operator Operator Material_ID
    Vstart Misc_ID MaterialQuantity
    VFinish MiscQuantity
    GPS_ID
    GPSQuantity
    Misc_ID
    MiscQuantity
    Addon_ID
    AddonQuantity
    Comments

  6. #21
    Join Date
    Jun 2015
    Location
    Wales. Land of the sheep.
    Posts
    1,228
    How do you receive the external data? Is it always consistent with the same formatting? Could you automate the input?

  7. #22
    Join Date
    Jun 2015
    Location
    Wales. Land of the sheep.
    Posts
    1,228
    how about having one docket table.. then categorise each entry.

    category_ID Category.

    1 machine
    2 plant
    3 labour
    4 materials

    Then later you deal with only records that meet criteria. such as category ID = 1 (machine).

    I'm also terrible at explaining things. so good luck.

  8. #23
    Join Date
    Jun 2015
    Location
    Wales. Land of the sheep.
    Posts
    1,228
    just as an idea also.. If you were categorising information you could follow up on your earlier idea. where by the first form has information that is required for EVERY docket.. then the second form opens dependant on the category selected.

    So if its a material then the material form opens to complete the entry.

  9. #24
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    It seems to me that there is a lot of commonality between dockets, so I think there are a couple of options
    Click image for larger version. 

Name:	Capture.JPG 
Views:	12 
Size:	45.6 KB 
ID:	27332

    Those highlighted

    yellow - common to all
    green and pink - common to at least two
    orange - similar, could perhaps be combined
    white - unique to 1

    So you could just have one docket, with an additional field to indicate docket type and leave unrequired fields for labour/material blank. On a form you would have user choose docket type then hide/disable the unrequired controls.

    Alternative would be a single docket for items in yellow and sub tables for the rest, but personally I think you are adding complexity for no real benefit.

  10. #25
    Join Date
    Jun 2015
    Location
    Wales. Land of the sheep.
    Posts
    1,228
    what's the difference between start/finish and v start/finish too? you may be able to store start and finish times in another table if there is a one to many relationship.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 12-05-2014, 12:26 PM
  2. Replies: 9
    Last Post: 04-01-2014, 05:06 PM
  3. Replies: 1
    Last Post: 07-26-2013, 06:01 AM
  4. Replies: 3
    Last Post: 11-29-2012, 11:00 AM
  5. How to store data many row in one table
    By dododo in forum Access
    Replies: 4
    Last Post: 06-25-2011, 12:42 AM

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