Cancelled

Write some Software

Our database design needs to capture and analyze emerging and startup technologies in the broader sciences field.

The database will be proprietary, used specifically 'in house' by our own external consultants for the filtering and identification of case specific technologies and not for public viewing.

We are seeking a developer to create a simple, effective online multi-user database based primarily on the existing pre-development, mock MS Access database. (attached) We developed this database to better understand our own needs, it is not and has never been used in a functional way.

Please use this database to form your submission. We have included a small volume of test data to help with the overall understanding of what is required.

What we need:

Define a database format / language

Ideally needs to be manageable by the users (us)

In a common, well known format, e.g. MS Access App, SQL, Caspio, MS Apps etc

Please suggest your database format

Outline the reasons / advantages relative to what we are trying to achieve

Set up a multi-user online environment.

Log user edits, date stamp submissions etc.

Capture existing data from Excel spreadsheets

Create import Queries from MS Excel spreadsheets (An example included)

We understand that there are likely referential integrity issues that will be faced with the conversions.

Conversion will involve splitting of multi-value fields into useful data

(e.g.) researcher fields which contain Multiple names comma separated which will need to be split into First, Last name, etc. and associated with the primary record.

Create forms for rapid data entry flow

Create forms for easy visual understanding and data viewing of existing data

Create search forms consisting of nested queries with ‘and/or’ options.

Filtering on form tables

An outline of the queries we would like to perform is below below

Create reports for screen and print to convey the results of searches

Ideally, educate us on how to create our own extraction reports

Facilitate the hosting and move to an online based environment

Direct us to cost effective but secure online hosting which we can ultimately manage ourselves

The developer will have an ongoing support role for the database.

Search Queries

In terms of searching, we want to be able to search by the following fields with ‘And/Or’ options so that we have the option to search multiple fields for the same word:

This will involve full string searches for partial and full matches in multiple fields.

Project title

Project description

Sector

Indication/application

Clinical stage

IP status

Keywords

Contacts

City

Organisation type

Sorting 

We’d probably also want to be able to sort the results in the results table by each column.

We would like to be able to search the results for alternative terms

Reporting

Results reports from queries

Reports from base database (reports from filtered data)

What we expect from your submission.

Outline the database you recommend and the reasons for this format.

A methodology you will use to liaise and create what we want.

A rough estimate of the time it would take you to create the database as outlined

A cost for the development

What debugging support you will offer

Where you are operating from

How many members in your team (those with relevant skill sets)

Examples of your database work

References from clients

Skills: Database Programming, Microsoft Access

See more: write an article for publication in a national newspaper on the issues of youth unemployment and suggest how this can be solved, software write mq4, software write chip epson, useful software write book, software write web specs, free software write user guide, software write edid, free software write company profile, software write websites idea, software write book images, software write books, software write protection, free software write book, software write book, java direct print, client direct print using web application vbnet, direct print client vbnet, java direct print web site, direct print client site aspnet, direct print client side aspnet, software write protect software, software write technical manual

About the Employer:
( 0 reviews ) Spain

Project ID: #14311189

23 freelancers are bidding on average $2243 for this job

fuentro

A proposal has not yet been provided

$2222 USD in 15 days
(21 Reviews)
5.7
zu02

p.s. pls, look at my portfolio screens here and if you'll interested in my profile I can share my Ms Access softwares via Skype (my ID zura_e) Also I'm a single coder - not a team. In general for me all is clear wit More

$2500 USD in 30 days
(32 Reviews)
5.8
jawadaman

I am an experienced MS Access applications developer. I can do this job for you. If interested in hiring me then please let me know so that we can finalize the scope, timelines and budget. Relevant Skills and Experie More

$2500 USD in 30 days
(60 Reviews)
5.5
$2500 USD in 30 days
(1 Review)
5.2
fanninson45

I have done a similar project like this recently for a Canadian Sporting Organisation here [url removed, login to view] Relevant Skills and Experience RECENTLY COMPLETED PROJECTS • Cas More

$1500 USD in 30 days
(13 Reviews)
5.4
workerbee1974

My passion is building Custom Access Databases. I have built well over 250 custom databases in the past 16 years. I have taken all classes from beginner to expert 97 to 2013. I have screen shot samples and more reviews More

$2200 USD in 30 days
(17 Reviews)
4.9
$1500 USD in 30 days
(23 Reviews)
4.7
crypthne

MySQL. It's quite relevant for multiuser environment and can cope with large amounts of data Relevant Skills and Experience Database administration and programming, Web and cloud programming Proposed Milestones $1500 More

$1500 USD in 35 days
(27 Reviews)
4.4
schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex More

$2500 USD in 30 days
(4 Reviews)
3.9
riki888vw

Hi, I can do your project as C# ASP .NET WEB or Desktop application. Database will be MSAccess. Regards, Slavi. Relevant Skills and Experience Database design MSAccess database Software development WEB development II More

$2500 USD in 30 days
(1 Review)
3.8
masterlancer999

Hi dear I noticed your project description, and i am very interested in your project I read your project description carefully, and checked all the features i have to implement, And checked attached files As you can More

$2500 USD in 30 days
(2 Reviews)
3.4
frankoke16

I am a full time programmer. I just wanted to have another job to gain more skills, learn from others and help others to solve their problems. In my full time job, i use .Net framework integrated with SQL, SSRS, MySql, More

$3000 USD in 30 days
(5 Reviews)
3.1
$1500 USD in 30 days
(8 Reviews)
2.9
augurstech

Dear Employer we will develop your simple, effective online multi-user database based primarily on the existing pre-development, mock MS Access database Relevant Skills and Experience Ms access database software devel More

$2500 USD in 45 days
(2 Reviews)
2.9
bmartynvw

Hi, My name is Benjamin. I'm an expert with over 14 years of experience. Based on what I see in your database design and requirement list, I feel I can provide you the right solution Relevant Skills and Experience I More

$2500 USD in 30 days
(1 Review)
2.5
papon13

Greeting! My Name is Noor All Safaet and expert in Software and Web Development. I would love to have the opportunity to discuss about your project with you. 4+ years of experience as Web, Software and Database Dev More

$2500 USD in 30 days
(4 Reviews)
2.3
langlangFan

Hi, I don't usually look for new clients but I happened to see your serious job post and I wanted to tell you about the biggest mistake I see other clients make when they hire freelancers. The most freelancers who bid More

$2500 USD in 30 days
(0 Reviews)
0.0
AleenaIlyas

Hello, I have read what you exactly need, however I would like to ask you a few questions. I do work smart and do not rest until I get the job done. Relevant Skills and Experience Hello, I have read what you exactly n More

$2500 USD in 30 days
(0 Reviews)
0.0
Weebside

Hello, Sir Weebside Inc. is a professional freelancer service provided to worthy clients like you. We can provide our best developers to provide you High-Quality Product with 100% Delivery Rate, 100% Satisfaction. More

$1500 USD in 1 day
(0 Reviews)
0.0
leadconcept

Dear Sir, After analyzing whole requirements, I am afraid that it is not possible for us to do it in US $3,000, as this is very low budget & no doubt you can get lot of bids within this budget range, as every bidder More

$2500 USD in 30 days
(0 Reviews)
6.3