Results 1 to 3 of 3
  1. #1
    mansoor is offline Novice
    Windows 8 Access 2013
    Join Date
    Oct 2014
    Posts
    1

    Database Design for Employee Leave Record Management System

    I am new to database designing. Please if anyone can guide me for designing and relationships for access database? I am just confused for creating tables and their fields and what will be the primary and foreign keys. I can work further. I am attaching excel sheet which is currently in used. I am using Access 2013.



    Thanks.leave.zip

  2. #2
    burrina's Avatar
    burrina is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383
    Take a look at this site for a Schema Design. http://www.databaseanswers.org/data_...ping/index.htm

    HTH

  3. #3
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664

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

Similar Threads

  1. Replies: 3
    Last Post: 03-13-2014, 11:21 PM
  2. Simple database bridge management system
    By tsvetkovdimitar in forum Database Design
    Replies: 4
    Last Post: 11-14-2013, 05:47 PM
  3. Employees Database Management System
    By salsai in forum Database Design
    Replies: 3
    Last Post: 01-22-2012, 12:45 AM
  4. Database Design for employee
    By Ramya in forum Database Design
    Replies: 1
    Last Post: 07-29-2011, 11:57 AM
  5. Time and Leave Management System
    By P5C768 in forum Database Design
    Replies: 0
    Last Post: 03-10-2011, 11:20 PM

Tags for this Thread

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