Designing and employee vacation / holiday database

Discussion in 'Access Beginners' started by Chris Strug, Nov 9, 2004.

  1. Chris Strug

    Chris Strug Guest

    Hi,

    As something of a pet project, I'm looking to develop a tool to track
    employee holiday (or vacation for those of us in the US) for my company -
    good for the company (if I get something usuable working) and good practice
    for me.

    Before I even open Access I want to get the relationships sorted.

    First looks indicate two basic entities:

    Employee
    - ID
    - Forename
    - Surname
    - Dept
    - other employee details.... etc etc
    - holiday allowance (number of days)

    Holiday
    - Holiday ID
    - Employee ID
    - Holiday Start Date
    - Holiday End Date

    Then its a simple one Employee to many Holiday records. Queries can handle
    days taken by employee X and so on. Business rules handled by forms (not
    letting X take more than their allowance, etc).

    Now assuming that is a workable model, what I'd like to do (and this is
    where I'm stuck) is to include a feature where I can link employees so for
    example, employee X cannot be on holiday if employee Y is on holiday that
    date or employee Z is. I.e. with-in a department there may be that only two
    of its employees may be off at any one time.

    Any ideas? I'm near certain I'm going to require another table linked to
    employees but I'm stuck as to how to develop it. Can anyone suggest how I
    should develop my table structures. I don't want to be spoon fed but some
    pointers in the right direction would be greatly appreciated.

    Any and all replies are gratefully received.

    Thanks

    Chris.
     
    Chris Strug, Nov 9, 2004
    #1
    1. Advertisements

  2. Chris Strug

    Guest Guest

    hi.
    i've done that already.
    post your email and i will sent it to you.
    it doesn't do all that you listed but you might be able to
    use it as a model and idea getter.
    regards

    >-----Original Message-----
    >Hi,
    >
    >As something of a pet project, I'm looking to develop a

    tool to track
    >employee holiday (or vacation for those of us in the US)

    for my company -
    >good for the company (if I get something usuable working)

    and good practice
    >for me.
    >
    >Before I even open Access I want to get the relationships

    sorted.
    >
    >First looks indicate two basic entities:
    >
    >Employee
    > - ID
    > - Forename
    > - Surname
    > - Dept
    > - other employee details.... etc etc
    > - holiday allowance (number of days)
    >
    >Holiday
    > - Holiday ID
    > - Employee ID
    > - Holiday Start Date
    > - Holiday End Date
    >
    >Then its a simple one Employee to many Holiday records.

    Queries can handle
    >days taken by employee X and so on. Business rules

    handled by forms (not
    >letting X take more than their allowance, etc).
    >
    >Now assuming that is a workable model, what I'd like to

    do (and this is
    >where I'm stuck) is to include a feature where I can link

    employees so for
    >example, employee X cannot be on holiday if employee Y is

    on holiday that
    >date or employee Z is. I.e. with-in a department there

    may be that only two
    >of its employees may be off at any one time.
    >
    >Any ideas? I'm near certain I'm going to require another

    table linked to
    >employees but I'm stuck as to how to develop it. Can

    anyone suggest how I
    >should develop my table structures. I don't want to be

    spoon fed but some
    >pointers in the right direction would be greatly

    appreciated.
    >
    >Any and all replies are gratefully received.
    >
    >Thanks
    >
    >Chris.
    >
    >
    >
    >.
    >
     
    Guest, Nov 9, 2004
    #2
    1. Advertisements

  3. Chris Strug

    Chris Strug Guest

    <> wrote in message
    news:438c01c4c686$bc2141f0$...
    > hi.
    > i've done that already.
    > post your email and i will sent it to you.
    > it doesn't do all that you listed but you might be able to
    > use it as a model and idea getter.
    > regards
    >


    Hi,

    Thanks for the reply. Assuming that the database is quite small (under 2
    megs) my mail address is solace1884 .at. hotmail dot com.

    If its over that then let me know and I'll work something out - I'm sure you
    understand that I'd rather not mention my main address in Usenet :)

    Thanks again

    Chris.
     
    Chris Strug, Nov 9, 2004
    #3
  4. Chris Strug

    Khaled M.Abd El-Alim

    Joined:
    Feb 17, 2015
    Messages:
    1
    Likes Received:
    0
    Chris strug Can you send me that file if you please khaled.alim at hot mail
     
    Khaled M.Abd El-Alim, Feb 17, 2015
    #4
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. trent2275

    designing a database, lots of questions.

    trent2275, Jan 14, 2004, in forum: Access Beginners
    Replies:
    1
    Views:
    100
    Van T. Dinh
    Jan 14, 2004
  2. skline

    how to start designing this database

    skline, Jan 26, 2004, in forum: Access Beginners
    Replies:
    1
    Views:
    97
    Jeff Boyce
    Jan 27, 2004
  3. Rob Jones

    Designing a Simple Database Application

    Rob Jones, Sep 21, 2004, in forum: Access Beginners
    Replies:
    5
    Views:
    102
    Jeff Conrad
    Sep 22, 2004
  4. gls858

    Vacation time database

    gls858, Feb 2, 2005, in forum: Access Beginners
    Replies:
    2
    Views:
    102
    gls858
    Feb 2, 2005
  5. carrickr
    Replies:
    6
    Views:
    137
    PC Datasheet
    Mar 23, 2005
  6. James
    Replies:
    2
    Views:
    98
    James
    Mar 30, 2005
  7. Joker

    Designing new database

    Joker, Jun 16, 2005, in forum: Access Beginners
    Replies:
    2
    Views:
    113
    John Nurick
    Jun 18, 2005
  8. Erick Solms

    Help designing a database

    Erick Solms, Mar 31, 2006, in forum: Access Beginners
    Replies:
    2
    Views:
    109
    Jeff Boyce
    Mar 31, 2006
Loading...