Results 1 to 2 of 2
  1. #1
    mduplantis is offline Advanced Beginner
    Windows Vista Access 2003
    Join Date
    Jun 2010
    Location
    Omaha, Ne
    Posts
    65

    Setting up new database


    I have made about 5 different layouts on paper for my database, but still not setting it up correctly. I think I am making it to detailed for my own good.

    I would like to get a minor push in the right direction. I am not asking for anyone to do my work, but a little nudge.

    The database is going to be used to keep track of both overtime (we have 4 types of overtime) and people who are off on leave (we have about 10 different types of leave).

    For the overtime staff I will need to have fields to include name, rank, location they work (dept) and number of hours. We use employee id numbers, so I will have an employee id field and have that with relationship to another table to fill in all the fields (I have made that work already).


    Thanks in Advance
    Mike
    Last edited by mduplantis; 06-06-2010 at 08:37 PM.

  2. #2
    jzwp11 is offline VIP
    Windows 7 Access 2007
    Join Date
    Jun 2010
    Location
    Dayton, OH
    Posts
    2,901
    Are you going to be tracking normal (non-overtime) hours as well? Do you record leave in hours (8hours=1day). What unit of measure do you use for overtime?

    If I were structuring a database like this, it would probably go something like this:

    tblPeople
    -pkPeopleID primary key, autonumber
    -longEmpIDNo (your employee ID number)
    -txtFName
    -txtLName
    -fkRankID foreign key to tblRanks
    -fkDeptID foreign key to tblDepartments

    tblDepartments
    -pkDeptID primary key, autonumber
    -txtDeptName

    tblRanks
    -pkRankID primary key, autonumber
    -txtRank

    If you want to track the actual changes in rank or department over time then you will need separate tables for those and not have fkRankID and fkDeptID in the employee table.

    A table to hold the general categories of overtime or leave

    tblWorkCategories (2 records overtime and leave)
    -pkWorkCatID primary key, autonumber
    -txtWorkCategoryName

    tblWorkCategoryDetails (this table to hold all of the types of leave (10) and overtime (4))
    -pkWCatDetailID primary key, autonumber
    -fkWorkCatID foreign key to tblWorkCategories
    -txtdetaileddescription

    Now a table to hold the actual time (overtime of leave) for an employee

    tblEmployeeTime
    -pkEmpTimeID primary key, autonumber
    -fkPeopleID foreign key to tblPeople
    -fkWCatDetailID foreign key to tblWorkCategoryDetails
    -dteEmpEvent (date when the leave or overtime occurs)
    -spHours (hours associated with the event)

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

Similar Threads

  1. Setting paths different for each form
    By sailinxtc in forum Programming
    Replies: 9
    Last Post: 04-04-2010, 09:03 PM
  2. Setting NOT NULL for an column
    By cwwaicw311 in forum Forms
    Replies: 1
    Last Post: 02-21-2010, 10:30 PM
  3. Setting Focus on a Form
    By MFeightner in forum Forms
    Replies: 1
    Last Post: 07-30-2009, 07:49 AM
  4. Setting a field to be dependent on another
    By CushingMT in forum Forms
    Replies: 0
    Last Post: 11-19-2008, 11:51 AM
  5. Setting combo box properties
    By rathfam4 in forum Programming
    Replies: 1
    Last Post: 12-28-2005, 02:27 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