Results 1 to 2 of 2

Thread: access database help

  1. #1
    Join Date
    Dec 2004
    0 times in 0 posts

    access database help

    Please Help!
    Ive been asked by HR woman at work to produce a database which will be able to print out a report of employees who have been off work for the previous month.

    She would like to be able to input a persons staff code and the dates from the start and end of their sickness she also needs to be able to tell if they have had a full or half day, once inputted she wants print out who has been off.

    Ive started what i think should work-but im not great on access can someone pls help-pls msg me if you would kindly have a look at the db.
    Ive got an employee table, a reason table-this contains reasons for being off sick, and also an absense table which should record employees adsenses.


  2. #2
    cat /dev/null streetster's Avatar
    Join Date
    Jul 2003
    100 times in 82 posts
    • streetster's system
      • Motherboard:
      • Asus P7P55D-E
      • CPU:
      • Intel i5 750 2.67 @ 4.0Ghz
      • Memory:
      • 4GB Corsair XMS DDR3
      • Storage:
      • 2x1TB Drives [RAID0]
      • Graphics card(s):
      • 2xSapphire HD 4870 512MB CrossFireX
      • PSU:
      • Corsair HX520W
      • Case:
      • Coolermaster Black Widow
      • Operating System:
      • Windows 7 x64
      • Monitor(s):
      • DELL U2311
      • Internet:
      • Virgin 50Mb

    Re: access database help

    Person Table:

    Person ID (Primary Key)
    Person Name (text, 30chars)

    Absences Table:

    Person ID (Composite Key with Date)
    Date (Composite Key with Person ID)
    Absence Type (Combo Box: Halfday / Fullday / Other)
    Notes (text, 200 chars)

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. urgent help with c++ function access
    By haelly in forum Welcome to HEXUS!
    Replies: 1
    Last Post: 17-12-2007, 05:11 PM
  2. Replies: 3
    Last Post: 17-10-2005, 02:31 PM
  3. Ms Access Database Proggy
    By GBDarkAngel in forum Software
    Replies: 0
    Last Post: 10-10-2005, 10:22 PM
  4. Belkin F5D6130 802.11b Wireless Access Point
    By Howard in forum Reader Reviews
    Replies: 4
    Last Post: 10-12-2004, 11:20 PM
  5. abnormal access database traffic?
    By Stoo in forum Networking and Broadband
    Replies: 8
    Last Post: 06-10-2004, 04:43 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