Database of projects
$250-750 CAD
Paid on delivery
Here's a general description. Details will be shared later.
I need a database that can house projects. These projects have many fields associated with them. A lot of them are typical, some textbox fields like Project Title, Contact Name; some listbox fields, like Project Status, Project Type.
Some fields can contain multiple values.
Also there's an extra database of what's called Commitments. These are categories organized in four layers (First category is broken down into second, and those broken down into third etc). I already have this heirarchy imported in the database. The lowest level of categories are tied to each project, where each project can address a specific Commitment. It addresses one primary commitment, and, optionally, several secondary.
Each commitment also has a lead agency, supporting agency or none.
Each project also has several financial metrics tied to it, each metric is broken down in five years.
Also, each project has a status field (complete, underway, etc) . This information is then aggregated based on commitments and higher categories.
I already have a general UI already made. Your work has to be tied into it. It's a straightforward navigigation form.
I have several parts already done - tables created for most of the fields above, except the financial information. Most relationships defined.
I need:
- Ability to create/edit/delete new projects
- Ability to search for projects based on any metric etc. (A lot of this part is done already)
- Report of financial information combined for each Agency.
- Report of Project statuses combined for Commitments and higher categories
- Export of several projects at once as an Excel spreadsheet
The above has to be done exactly, and we will discuss details over chat/phone.
The biggest objective is that this has to be done urgently - within the next two-three days. There needs more to be done with this project, so potential for a lot more follow-on work!
Project ID: #7379100
About the project
28 freelancers are bidding on average $454 for this job
Hey, I am assuming that the existing database is in Access and you are looking for either Excel or Access based forms to manage the project metrics. Is this understanding correct? I can create such forms which will More
Hi! there, My name is Dipak Moliya. I’ve read your project description and can see that you need a database that can house projects. I have been done many MS access database application. I can do your More
Hello Sir, I guarantee you 100% satisfaction. Would you like to discuss with me.....we negotiate about price and time.....My expertise lies in quality service and delivery on Time. Kindly if you want high quality work More
Hi, first of all - many thanks for taking the time to write down accurate requirements; it automatically lets me visualise this database. I am able to start straight away and I would be happy to see the database today. More
Dear sir, Would you provide me some information: which database to use (I think may be MS Access). I can implement your requirement in MS Access or Excel or SQL Server. Thank you for your attention. HuyPQ.