Results 1 to 3 of 3
  1. #1
    DuWayne is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2011
    Posts
    8

    Help designing a Scheduling database

    What would be the best design for a database that is used for scheduling work. We manufacture buildings and need to schedule 3 or 4 employee's in each building.

    Employee
    also keep up with absences, sick, vacation, or employee is in training

    Date
    Time
    spent in each building.

    Also have (16) different work stations:
    Framing
    conduit
    electrical
    painting,
    carpentry, etc....



    Need:
    model
    serial no.
    job no.
    of building,

    I can build it but would like input on best layout.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    So you need something like a construction or project management type application?

    Google: Access template database construction management

    Check this recent thread https://www.accessforums.net/access/...eds-20309.html

    or this https://www.accessforums.net/databas...ses-18459.html
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    dblife's Avatar
    dblife is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Nov 2011
    Location
    South Shields, UK
    Posts
    95
    If you are sure you want to go ahead with building your own set-up, for all the functions you want, it might pay to start with simple basics, normalised so further 'add-ons' happen with minimal disruption to the original tables etc.

    Start with the simple stuff you might expect to see.

    Table tEmployee
    eID
    eNameF
    eNameL
    eDateStart
    eDateLeave

    Table tCraft
    cID
    cDescription

    Table tEmployeeCraft
    ecID [autonumber]
    ecEmployeeId [fk]
    ecCraftId [fk]
    ecQualifyLevel
    ecQualifyDate

    Table tProject
    pID
    pCustomerId [fk]
    pDesignId [fk]

    Table tCustomer
    cstID
    cstName
    cstAddressLine1
    etc...

    You get the idea. Start right and future expansion will happen easily. Get it wrong and it will be difficult to expand.

    Let me know if you need a hand.

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

Similar Threads

  1. Tutor Scheduling Database
    By prawer in forum Database Design
    Replies: 5
    Last Post: 12-16-2011, 10:18 AM
  2. Designing a database for a log
    By neo651 in forum Database Design
    Replies: 3
    Last Post: 10-31-2011, 11:45 AM
  3. Help with designing database
    By nimalp in forum Access
    Replies: 6
    Last Post: 09-15-2010, 10:34 AM
  4. Scheduling database in Access
    By ACS Newbie in forum Access
    Replies: 4
    Last Post: 01-21-2010, 10:32 PM
  5. questions on designing database
    By schultzy in forum Access
    Replies: 1
    Last Post: 07-18-2009, 03:44 PM

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