Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2007
    Posts
    10

    Unanswered: Project Database

    Hi,

    I feel I have a fairly good understand of database design. However I guess I lack when it

    comes to implementation and such.

    So I hope someone here would be able to assist.

    Basically I want a nice simple to navigate database (minimum bells and whistles)

    To give a nice background the database is to hold information on projects.

    Construction
    ============

    So I guess there will be a few tables like so:

    tbl_projects

    project_ID (AutoNumber)
    REF *
    control_area
    location
    Nature of Project
    Scope of Work
    Date Advised
    Priority
    Reviewed By
    lead_engineer
    Start Date
    End Date
    % Complete
    Records
    Request Reference
    Project Rating
    Risk
    Class Code
    Contract Area
    project complete (only visable under admin section)

    * The REF field will be how I want to identify each individual project, i.e. P107 or P258
    So I guess ID would be hidden from the user


    tbl_control_area

    control_area_ID
    control_area


    tbl_location

    location_id
    location

    tbl_engineer
    engineer_id
    engineer


    as you can probably see, the location, control_area and lead_engineer fields are linked or

    key fields


    I would like the following reports to be able to be produced

    - Pick a control area or location and display all those records

    - Pick a date and show all records which start date is after the date picked

    - Pick a Lead Engineer and show the records they are on.



    Forms I guess:


    So I want the user to be able to view or edit an existing project but not view projects

    were the completed field is true.

    Also I would like and admin area (simply password protected or something) were projects can

    be created, deleted or put in a complete state (nothing to do with % complete field)

    Under the admin section I would like the option to be able to add to the tbl_location,

    tbl_control_area and tbl_engineer



    Is this making any sense? I know its long but I beleive it’s not that difficult for someone

    with the correct knowledge Unfortunately I’m useless at access. I've tried and tried and

    it has come to this. Please can someone assist in ANY way?

    Thanks in advance

    jmcall10

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Pick a control area or location and display all those records
    Code:
    SELECT *
    FROM tbl_projects
    WHERE control_area = [Enter Control Area]
    George
    Home | Blog

  3. #3
    Join Date
    Aug 2007
    Posts
    10
    Thank you for your response

    can I not have it so that the user can pick from the control_area table?

    like a drop down box or something?

  4. #4
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004

    Talking

    Quote Originally Posted by jmcall10
    Thank you for your response

    can I not have it so that the user can pick from the control_area table?

    like a drop down box or something?
    HI jmcall10 and Welcome to the Forum.
    Have you actually designed all of the Tables and made some of the Forms or Reports? I did see this statement:
    as you can probably see, the location, control_area and lead_engineer fields are linked or key fields
    What are you meaning when you say Linked? Are they linked to each other? Just looking at it you don't seem to have the ForeignKeys set in any of the Tables. Do you have any Relationships established? One other thing, are you asking for someone to design it for you? If so, check out this section of this site for something of that nature:

    http://www.dbforums.com/forumdisplay.php?f=246

    Other than that give out a little more info so that someone can better assist you if you are in a sticking point.

    have a nice one,
    Bud

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •