Results 1 to 7 of 7
  1. #1
    Tammy is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Nov 2014
    Posts
    29

    Data Model for Tracking Monthly Cashflow

    I'm struggling with this a bit. The Project Managers like to be able to input into a form that would look similar to this.
    Project # Nov 14 Dec 14 Jan 15 Feb 15 Mar 15
    100101 $60000 $50000 $40000
    100102 $20000 $20000 $10000
    100103 $16000 $18000 $20000
    100104 $15000 $18000 $20000


    I'm struggling with the data model. I currently have it set up like this but I don't know if its correct.

    PK Project ID
    Project Code


    Project Title
    Client
    Original Budget
    Start Date
    Duration


    PK Budget
    Budget Month
    Budget Year
    Amount

    I'm just not sure how else to do this.

    Has anyone ever had to do this? These two tables are linked.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Your data structure looks okay - a normalized approach.

    That data entry form - non-normalized approach - could not be used for the normalized structure unless you use an unbound form and lots of code to save data and lots of code to pull existing data into the unbound form.
    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
    Tammy is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Nov 2014
    Posts
    29
    Yes, I think I'd like to avoid the backend coding. I'm not a programmer. Hmmm... not sure how I'm going to accomplish this. I showed them a tidy little drop down option that I thought they would be happy with but they didn't go for it.

    Back to the drawing board.

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Options:

    1. normalized db and form and project managers adapt to the data entry (or have interns do data entry)

    2. normalized db and you learn to program the unbound form

    3. non-normalized db and form - managers are happy and you go crazy

    Actually, any approach has it's own set of issues and complications. It is a balancing act between normalization and ease of data entry/output. You just have to decide which you are most comfortable with.
    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.

  5. #5
    Tammy is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Nov 2014
    Posts
    29
    Is programming an unbound form difficult?

    I've also got a situation where they would like to load resources against the project. (All this development work is temporary until we go to P6) They want to be able to see at a glace who is working on which projects and ensure that all the engineers are fully loaded against projects. Again, I'm having a hard time modeling this.

    So far:

    Ive got the Project Info Table which is linked to a Team table and then to the resources table. Looks something like this:

    PK Project ID
    Project Code
    Project Title
    Client
    Original Budget
    Start Date
    Duration

    Team
    PK Team ID
    FK Project ID
    FK Resources ID
    Percent Time
    Start
    Duration

    PK Resources ID
    Resources Name
    Resources Title
    Specialization
    Department

    I would build the project team from the resources. I'm just need come clarity to my thinking.

    Thanks

    Tammy

  6. #6
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Depends on your definition of difficult. Definitely a lot of code. Some developers use unbound forms exclusively. I prefer to let Access do as much heavy lifting as possible.

    The structure still looks reasonable and normalized.

    Need another table to show who is on each team?

    Advise no spaces or special characters/punctuation (underscore is exception) in naming convention.

    What is P6?
    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.

  7. #7
    Tammy is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Nov 2014
    Posts
    29
    Primavera 6 is a project management software. What I'm developing is interim until we get P6 up and running and able to handle resource loaded schedules/budgets. I really think I'm doing way too much development for an interim solution.

    Yes, I can see what you mean. I'll add a table for the in between. Good catch.

    T

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

Similar Threads

  1. Custom form - complex model of data
    By josnow in forum Forms
    Replies: 1
    Last Post: 11-28-2012, 01:25 PM
  2. Replies: 6
    Last Post: 11-10-2012, 09:49 PM
  3. Transform data model from Access to X
    By snoopy in forum Database Design
    Replies: 2
    Last Post: 05-29-2012, 12:37 AM
  4. New to ACCESS...need to add up monthly data
    By napsoni in forum Queries
    Replies: 1
    Last Post: 01-27-2012, 01:33 PM
  5. Monthly Data
    By tsorange in forum Database Design
    Replies: 1
    Last Post: 11-09-2011, 02:19 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