Results 1 to 3 of 3
  1. #1
    Joehayner is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Aug 2015
    Posts
    1

    Project Management


    I'm a newby to Access, but am learning in my spare time.

    My end goal is to create a project management system where I can schedule multiple employees to multiple tasks within a project and run a report that tells me when and where by person a task is scheduled.

    I've so far got some of the basic tables down, but am having difficulty with the forms. These could really expedite the process of entering the data, but I'm at a loss right now for where to learn about how to attach drop down boxes with lists to forms and how to create a button that pulls information from an address book in outlook to create an employee list.

    Any help would be greatly 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,726
    Get your tables and relationships designed to meet your requirements. Don't worry about forms at this time.
    Create some test data and some sample outputs (reports/queries) in simple layout view.
    Make sure your data model has the info to produce the output you need (from a data perspective). You can concern yourself with format later.

    Also check out this "stump the model approach".

    This post has some info that could be useful to you.

    Good luck.

  3. #3
    Join Date
    Jun 2015
    Location
    Wales. Land of the sheep.
    Posts
    1,228
    Welcome Joe.

    I'm doing a similar project now and the help here has been great. Hopefully you get the help you need too!

    Post an ERD and a description of your project for us to have a look at

    Andy,

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

Similar Threads

  1. Building an employee project management timeline
    By smckenna in forum Database Design
    Replies: 1
    Last Post: 07-01-2014, 08:35 AM
  2. Replies: 2
    Last Post: 04-11-2014, 11:21 AM
  3. Project management database
    By Alfi83 in forum Database Design
    Replies: 2
    Last Post: 12-16-2013, 07:31 AM
  4. Replies: 2
    Last Post: 07-20-2010, 11:02 AM
  5. Contract Management project
    By TheEngineer in forum Access
    Replies: 4
    Last Post: 07-16-2010, 02:57 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