Results 1 to 2 of 2
  1. #1
    TrackPad is offline Novice
    Windows Vista Access 2000
    Join Date
    Jul 2012
    Posts
    1

    Career Progression ID

    Hello
    I am a novice user of Access but have the most knowledge of my workplace so I am building a database for them.

    I am currently using Access 1997. The systems I am using I don't have an option for upgrading.



    I am trying to create a database which will map career progression. There are a number of courses that you have to take to advance. What I want to do is create an "Employee Information Form" that can have a section with "Last Career Course Taken" and the course name, then a section with "Next Career Course". The twist is that there are 2 different career progression paths Management, and General Employee.

    I have been looking over options to do this for the last few days but am unsure how to proceed.

    Any help would be appreciated.

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Here's one list of steps for designing a database.
    http://www.databaseanswers.org/approach2db_design.htm

    I would not start with a Form. I recommend you create a data model.
    If you are unfamiliar with database concepts such as Normalization and Entity Relationship Diagramming then see
    http://www.rogersaccesslibrary.com/T...malization.zip and
    http://www.rogersaccesslibrary.com/T...lationship.zip

    You may wish to read this article first
    http://forums.aspfree.com/attachment...achmentid=4712

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

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