Can you build a database for my business?
- or -
Post a project like this2947
$$$
- Posted:
- Proposals: 20
- Remote
- #1087129
- Awarded
AWS Certified Dev, Web & Software Developer, API Integrations Expert, DevOps Engineer
Edinburgh
Business Consultant, Website Design, Website Development, PHP, WordPress, Web App, Mobile App, Branding, Designer, Business Plans, Business Support, Presentation, Adviser, Analyst, Strategist, Advisor
City of London
Android/iOS Apps & Games. PHP/MySQL. Expert Software Developer. 21 Yrs Experience
Middlesbrough
120268857940911868901135913107920575062372503067539666003465103859709515826
Description
Experience Level: Expert
Here’s what I need. Ideally this would be cloud based but I accept this might not be possible without some very expensive Salesforce or other cloud based system. I do have my own hosting account so maybe MySQL if possible or MSAccess. But you are the expert, so I will be guided on this point.
The starting point is a client. The client has a reference number, these are just numbers. Each client could be married or have a partner so one client number could be two people.
Each client/number, has up to four associate names for a particular category. The category being Executors i.e each client could have four Executors.
Each client/number also has, lets say a maximum of ten associated people, these would be beneficiaries. These could be Executors as well but not necessarily so.
Each client/number also needs names and address of Witnesses who signed the documents. These witnesses could be the same people as the Executors but in most cases are not.
I need all the people on one client number linked. So when viewing for example client number 123456 I can see the executors, the beneficiaries and the witnesses.
We need to send different marketing letters out to different clients, executors, the beneficiaries and the witnesses at different times. So one day we need to write to all of the Executors, another day we might need to write to just 500 of them. Or perhaps we would need to write to all the clients over a certain age, or all the ones living in a certain area. We would need a way to filter out ones we wrote to previously. So the database must merge easily with MS Word.
Each client must also have many fields, some being text fields such as contact details, some being multiple lines of text for notes, some just being tick boxes, some might even be amounts we charged.
Each client must also link to a Company which is a separate table altogether. But I might want to see all the clients assigned to a certain company.
I also need other filters as well.
Can you help create a database of this calibre?
The starting point is a client. The client has a reference number, these are just numbers. Each client could be married or have a partner so one client number could be two people.
Each client/number, has up to four associate names for a particular category. The category being Executors i.e each client could have four Executors.
Each client/number also has, lets say a maximum of ten associated people, these would be beneficiaries. These could be Executors as well but not necessarily so.
Each client/number also needs names and address of Witnesses who signed the documents. These witnesses could be the same people as the Executors but in most cases are not.
I need all the people on one client number linked. So when viewing for example client number 123456 I can see the executors, the beneficiaries and the witnesses.
We need to send different marketing letters out to different clients, executors, the beneficiaries and the witnesses at different times. So one day we need to write to all of the Executors, another day we might need to write to just 500 of them. Or perhaps we would need to write to all the clients over a certain age, or all the ones living in a certain area. We would need a way to filter out ones we wrote to previously. So the database must merge easily with MS Word.
Each client must also have many fields, some being text fields such as contact details, some being multiple lines of text for notes, some just being tick boxes, some might even be amounts we charged.
Each client must also link to a Company which is a separate table altogether. But I might want to see all the clients assigned to a certain company.
I also need other filters as well.
Can you help create a database of this calibre?
Tony C.
98% (117)Projects Completed
70
Freelancers worked with
64
Projects awarded
25%
Last project
17 Nov 2022
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies