We require a simple Windows form application to input/edit/review data held in a single database table.
The application has been built in Microsoft Access, but we require it to be migrated to a Microsoft Sql Server 2000 database, with a Windows application (in Visual Basic).
The Microsoft Access application does not meet requirements for multi-user access and data entry.
The Microsoft Access application is attached as a guide to development. This does not contain ALL functionality required, so it is intended as a guide only.
The application will reside on a single server. Multiple users (as many as 10) will access this server via Remote Access.
The Application will communicate with the Database via ODBC. The database server is on a remote machine. The database consists of a single data entry table, plus a small group of (static) reference tables.
The coder will provide source code for the application that is compatible with Visual Studio 2003. The coder will provide the buyer with documentation that explains how to set server and database names for the application.
Additional functionality beyond what is contained in the MS Access application:
1 - The ability to enter multiple records for a single Member. (See Word doc for additional info).
2 - The ability to review all data, and to search for individual members using last name or MemberID.
This application is required in a VERY short time frame (as soon as possible).
Further enhancement work is likely, but is outside the scope of this bid request.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
Operating System: Windows XP Professional
Database: MS Sql Server 2000
Development environment: MS Visual Studio 2003
Programming language: Visual Basic