Results 1 to 6 of 6
  1. #1
    NightWalker's Avatar
    NightWalker is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2016
    Location
    Midwest USA
    Posts
    253

    Blanks in many fields in tables. I think Normalization is not normal.

    I have these 5 tables. There are many blanks in a couple of the tables. Am I off on my normalization? If so are there any suggestions to how I should restructure them? the data in them is just testing data.



    The facility where I work has test facilities on and off site. Each of the sites has a few buildings where testing is done. Some buildings have multiple test pods. I am trying to get my normalization correct for this.

    Click image for larger version. 

Name:	tables.jpg 
Views:	12 
Size:	80.9 KB 
ID:	24719
    Attached Thumbnails Attached Thumbnails tables.jpg  

  2. #2
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    As I said in the other thread, I think you might have gone too far in splitting the tables. But I don't know your requirements.

    What test data do you need to save/track? Start with that, then create the other tables as required.



    Click image for larger version. 

Name:	Tests2.jpg 
Views:	12 
Size:	10.2 KB 
ID:	24721

    Click image for larger version. 

Name:	Loc1.jpg 
Views:	10 
Size:	16.0 KB 
ID:	24722

  3. #3
    NightWalker's Avatar
    NightWalker is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2016
    Location
    Midwest USA
    Posts
    253
    I have a little over 100 different products I will be testing at the different sites. some products can be tested at all sites. some sites can test all products. some sites can only test a certain product and some products can only be tested at a certain site. there will be upwards of 100+ test readings for some of the products and some as little as 1 reading. I will be using calibrated equipment to do the tests and I will be adding tables to track the test equipment also. There will also be a table of employees. some employees are able to test at all sites and others only 1 site.

    I am trying to track which employee tested which product at which facility. using what test equipment, which test pod was used. what the test readings are and what date they were tested.
    I have been watching multiple videos and reading links you all have posted on normalization but I think I missed something or I am just thinking the wrong way with this.

    I know I have to create all the other tables that will be referencing this facility information but all the blanks seem like I am doing something wrong.

    Thank you for helping to normalize my abnormalities!!!
    Walker

  4. #4
    Perceptus's Avatar
    Perceptus is offline Expert
    Windows 7 64bit Access 2007
    Join Date
    Nov 2012
    Location
    Knoxville, Tennessee
    Posts
    659
    Sounds like Sites many to many. Records one to many, employee 1:1, equipment 1:1. Do you have a Relationship snapshot?

  5. #5
    NightWalker's Avatar
    NightWalker is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2016
    Location
    Midwest USA
    Posts
    253
    I will work on the rest of the model and post a snapshot when I get it within the next day or 2

  6. #6
    Perceptus's Avatar
    Perceptus is offline Expert
    Windows 7 64bit Access 2007
    Join Date
    Nov 2012
    Location
    Knoxville, Tennessee
    Posts
    659
    I like to start with the model first. I make mine in DGML. Then take that work and bring its light to Access.

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

Similar Threads

  1. Linked Tables and returning blanks
    By joreyn in forum Access
    Replies: 1
    Last Post: 08-20-2015, 05:19 AM
  2. Replies: 1
    Last Post: 08-01-2013, 08:47 AM
  3. Tables/Normalization
    By intransit2 in forum Database Design
    Replies: 2
    Last Post: 04-03-2012, 04:43 PM
  4. Conatenate fields and also remove blanks
    By Rubijon in forum Reports
    Replies: 3
    Last Post: 10-23-2011, 05:29 PM
  5. Normalization Assistance for Tables Please??
    By webmaniac in forum Database Design
    Replies: 10
    Last Post: 09-02-2006, 05:56 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