Design of Database for tracking Projects?

cjharley

New member
Local time
Today, 13:38
Joined
Dec 11, 2015
Messages
4
Hi I'm Clive, an I am completly lost, It's been approx 20 years since my las confession "wrong Place " lol. Last Time I made a database it was Office 95 I think. The company is still using it. "I made it in 1995" I am getting tooooo old. :eek:... Its wonderful how history repeats its self.

I from Northern Ireland, worked for myself on and off for the last 20+ years. I am a Civil Engineer by Trade. So here is what I am trying to Make. I will need all the Help I Can Get so please be nice.

I am creating a Database that is tailored to my Business. I provide civil engineering for building projects and I want to create a data base that tracks the projects, where they are, ie planning, water service, at who I talked to last etc. I also want to be able to create letters and emails from the database.
I also what to be able to scan documents and attach them to my projects.
Each Project might have various phases IE Phase 1 2 3 etc.., upon which different contacts can be used.
The database will also produce invoices and catelog purchases accounts purposes.
I want to be able to set calender dates for activities ie Phone water Service or put in random items that will be linked to access. I also would like to transfer an email to the progress of the phace of the project.

All help would be greatly appreciated.
 
Last edited by a moderator:
►Create Tables
1. CustomerTable (Fields: CustomerID, CustomerName, Address, ContactNos, ContactPerson, EmailAddress...etc.)
2. ProjectTable (Fields: ProjectID, ProjectType, ProjectDescription... etc.)
3. ProjectEntryTable (Fields: EntryID, ProjectDate, ProjectID, CustomerID, PhaseNo, etc..)
... and other necessary tables.

►Establish Table Relationships
►Apply database normalization
►Create Forms to add, edit and delete data.
►Create Queries
►Create Reports based on your Queries
 

Users who are viewing this thread

Back
Top Bottom