Searchable database or subcontractors, clients and participants
- or -
Post a project like this- Posted:
- Proposals: 11
- Remote
- #1547740
- Awarded
Description
Description of requirements/functionality: We need a user friendly, intuitive database that will help us to sort out our subcontractors and study participants.
THE DBMS YOU USE TO DESIGN THE DATABASE IS NOT THAT IMPORTANT TO US as long as it is a format that can easily be accessed from and supported by Windows 10 and file sharing platforms such as Dropbox or MS 365 sharing platform.
*The database needs to be able to grow with our business.
This database will have around 500-700 entries to start with but we expect it to grow to 2000-3500 entries.
We must be able to add OURSELVES new options as and when needed to the drop down lists and data entry and search fields.
*It must be easy to add new entries/data to the dabase
We need a user friendly form to populate the database with new data.
The form must have tickable boxes for the user to choose the type of data being entered (e.g. subcontractor, client, respondent), dropped down lists for predetermined choice options (e.g. in the "subcontractor type" field it could be "translator", "interpreter", "recruiter", "interviewer", "other", etc.) and memo fields.
Where the information being entered is not in the dropdown list, it should be possible to add a new option (e.g. in subcontractor type when the user chooses "other" they should be able to type "translator/interpreter" in a pop up window or something similar) to the list of predetermined options. This new data would then be available as a new option in the dropdown list next time we add a new entry to the database.
*The database must be easily and extensively searchable
We want to use a form to search the database via a query with the use of key words and a selection of fields to choose from (e.g. first name, last name, company name, subcontractor type, study participant type, language, country, town/city, speciality, job title, participation to previous studies, date, price per word, price per hour, etc.).
It should be possible to search the database across up to 5 search criteria (e.g. subcontractor type + country + price per hour + speciality + organisation)
The search and results should be based on close matches (and NOT exact matches only) and should not take accents into account.
The search results must be able to be sorted by up to 4 criteria (e.g. alphabetical order, least to most expensive, most to least expensive, most recently worked with)
*Number of fields in the data entry and search forms.
We expect to have between 20-36 fields in the data entry form.
We expect to have up to 12 fields in the data search form
*Number of tables for fields, prefilled fields/dropdown lists
We expect to have up to 45 tables
CMS and Admin requirements: This database will be a desktop application, although we would like to be able to share it via Dropbox and Microsoft 365 file sharing platform.
Extra notes: The database should, ideally, not take too much space.
Data retrieval should be quick.
We do not have a budget yet. We are not necessarily looking for the cheapest quote but rather the quote that will most closely match our requirements and that will deliver a database that is truly easy to add data to and retrieve data from in a very intuitive way.
When quoting, please be as detailed as possible and explain clearly how you can design a database that meets our needs. Any examples of other databases that you have designed would be a plus.
Plus remember to specify how long (in days or hours) it would take you to design the database to our satisfaction and how many revisions will be included.
Please only quote in Pounds Sterling.
Please note that quotes in any other currency or with insufficient details will NOT be considered, however attractive the price quoted may be.
==========
Edit 08/03/2017
Please note that the entry form should look as simple/plain as possible. We do not need anything fancy.
Something like the attached image is perfectly acceptable.
PLEASE NOTE: We need to be able to use the database even when no internet connection is available.
Sophie M.
100% (16)New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Morning Sophie
I've reviewed your description, and there are a couple of options available to meet your requirements.
You mention using Dropbox and 365 share options. Are you wanting to share files, or to host the system on them?
I recently wrote a system in Microsoft Access that used Sharepoint as the backend. That is an option for you. But you might be better with a hosted Web based system.
The requirements you have mentioned in your description, aren't an issue with either system, but it would be good to discuss your options in more detail.
Kind Regards
Phil -
Hi Sophie,
Are you expecting for different users to be able to edit/update the database independently of each other? -
Hi Sohpie,
There is no attachment of the Form as mentioned by you. Can you please share the image of the form.
regards,
Dharmesh