Results 1 to 3 of 3
  1. #1
    mixfeat is offline Novice
    Windows XP Access 2003
    Join Date
    Mar 2011

    Relationships/Data Organization

    Hi there!

    I need help with organizing data. The database should contain annual Health & Safety tests results for each employee. Although, I'm not very familiar with MS Access, I thought that building a huge table holding all info wouldn't be the best way to go. Building separate tables for each year doesn't seem like a particularly good idea either, considering that Employee names and info would be the same in all of them. Now, is it possible to have one table with Employees names, departments etc. (e.g. Employees) and several tables containing tests results (e.g. Test2008, Test2009)? How do I link them together? Your help is REALLY appreciated. Thanks!

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Ottawa, Ontario, Canada; West Palm Beach FL
    Here's a link with several good references

    Briefly look at the Entity Relationship Diagramming,
    then go back and read the Normalization and Normal Forms.
    Then work with your own data and do the Entity Relationship Diagram.

    As a first guess, I would suggest
    Employee -id,name,address,phone,BirthDate, etc
    Test -id, name of test, description, info about the test not employee

    EmployeeTest - id, id_ofEmployee, id_ofTest, Date ofTest, resultOfTest

    You may also have a Department table depending on your company's size, number of Employees etc.

    This structure will allow you to have as many test per employee as you want, since the DateOfTest, EmployeeId,and TestId are readily available. No need for separate tables for each year.....

    Good luck

  3. #3
    mixfeat is offline Novice
    Windows XP Access 2003
    Join Date
    Mar 2011

    Thanks, I'll definitely take a look at that.

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

Similar Threads

  1. Replies: 2
    Last Post: 03-14-2011, 07:56 PM
  2. Replies: 0
    Last Post: 03-13-2011, 06:46 PM
  3. Relationships and pulling data.
    By Subhunter in forum Queries
    Replies: 2
    Last Post: 02-08-2011, 01:18 PM
  4. Report organization
    By kstyles in forum Reports
    Replies: 7
    Last Post: 01-10-2011, 02:47 PM
  5. Organization help needed
    By Logan in forum Database Design
    Replies: 2
    Last Post: 07-30-2010, 11:00 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