The database schema is only three tables;
Client – For client related information
SurveyInfo – for survey related metadata
SurveyQuestions – for the actual survey data
See Image 1 (attached.)
The database and the data sits on the server.
An individual can open the application and use one or more of the search criteria to search the database.
Here is the proposed front end search interface wireframe;
See Image 2(attached.)
As an example search, one could find all survey questions made between 5/1 and 5/20 for X client containing Y keyword. Once found, the results display all the survey questions that meet the search criteria, as well as a link to the network drive where the data, Xtabs, and survey script documents are located.
Here is the proposed front end input interface wireframe;
See Image 3(attached)
I would like this project to use SQL server for the database, and have the front end interface written in VB (I'm somewhat open to other technologies.). User opens VB application, picks whether it is a "search" or "adding data" and has the Picture 2&3 interfaces.
Please let me know if you are interested. In your bid response, let me know if you have any suggestions or improvements.
-Application and how to connect it to the SQL server database
-All VB code
-Basic installation troubleshooting
Additional work for successful candidate that can put together the above project.
51 freelancers are bidding on average $373 for this job
I've been working with VB for over a decade and am more than certain that I can help you to bring this project to fruition very quickly. Please see my private message for more pertinent information.
Hi, I have 8.5 years experience in VB.NET, ASP.NET, C# and SQL Server. I have completed many successful projects on freelancer. I have MCTS certification in SQL Server from Microsoft. Thanks, Ajay
Hi This is Piyush Patel I have 8 yrs of Exp in VBA,VB6,VB.net,SQL and MsAccess. I have developed many applications in VB6,VBA,VB.NET. Please Check My PM
For the adding screen, the survey notes need to be a text/memo field (3 lines), also I will put in checking for question number and other fields that needs to be unique