Hi There,
I have been asked to design and develope a nww access database to enter all the nw projects the company receives so we can report on it and tract the costs and fees. The information they require is client information with their address details and site details and also the county the site is under, etc..
Can anyone please help or guide me in how i can achieve this??
Currently i have just setup an excel spreadsheet which has the following information i log on an excel spreadsheet:
Date, Project No, Project Ref, Project status, Surveyor Name, Client Name, Address, Contact H, Contact M, Email, Recommended Contact, Site Address, Project Description, Fees, Site Engineer fee, other cost, Final fees, BC fee, Site Eng Name, 1st Payment, 1st Payment date, 2nd Payment, 2nd Payment date, 3rd Payment, 3rd Payment date, comments, Thames Water,
I think i'lll need the follwoing tables but I'm not to sure now and wondered if anyone would be kind to assist me in setting this up so we can tract this information and are able to report on the projects we gave completed in progress, and cost occured.
Tables:
Clients: Id, name, address, contact, email, authorised county, site (if different to client address)
Projects:id, ref, date, name, project status
Engineers: if, name, address, county
Cost: Eng Cost, Final Cost, VAT, Project Fees
Much appreciate any help, thanking you in advance.
I have been asked to design and develope a nww access database to enter all the nw projects the company receives so we can report on it and tract the costs and fees. The information they require is client information with their address details and site details and also the county the site is under, etc..
Can anyone please help or guide me in how i can achieve this??
Currently i have just setup an excel spreadsheet which has the following information i log on an excel spreadsheet:
Date, Project No, Project Ref, Project status, Surveyor Name, Client Name, Address, Contact H, Contact M, Email, Recommended Contact, Site Address, Project Description, Fees, Site Engineer fee, other cost, Final fees, BC fee, Site Eng Name, 1st Payment, 1st Payment date, 2nd Payment, 2nd Payment date, 3rd Payment, 3rd Payment date, comments, Thames Water,
I think i'lll need the follwoing tables but I'm not to sure now and wondered if anyone would be kind to assist me in setting this up so we can tract this information and are able to report on the projects we gave completed in progress, and cost occured.
Tables:
Clients: Id, name, address, contact, email, authorised county, site (if different to client address)
Projects:id, ref, date, name, project status
Engineers: if, name, address, county
Cost: Eng Cost, Final Cost, VAT, Project Fees
Much appreciate any help, thanking you in advance.
Last edited by a moderator: