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.
So I guess there will be a few tables like so:
Nature of Project
Scope of Work
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
as you can probably see, the location, control_area and lead_engineer fields are linked or
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 its not that difficult for someone
with the correct knowledge Unfortunately Im useless at access. I've tried and tried and
it has come to this. Please can someone assist in ANY way?
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: