Client Relationship Online Database

We are a insurance claims office that assist people with social security claims that have been denied by the Social Security Administration. I have an Access database that I need a custom interface built that allows multiple location access to the same information. We are currently using MS Access forms and reports to interact with the database locally but need the same access to the database from additional locations. Our current database includes approximately 2800 client records in a single table but that has limited us to the amount of information we can enter for each customer. There are certain types of information (ie. number of claims for each client, requests for medical records to development their claim) that may vary in number from client to client. We would also like to have the ability to enter notes onto each clients' record as certain events happen. There is main customer data with about 90 fields and there may be optional data related to each customer in other tables that needs to be viewed and modified when present. I would also like to be able to scan documents and attach them to the appropriate clients record so they can be viewed without depending on locating the physical paper file for the client. I would also like to be able to print various forms relating to the client that assist in the paperwork requirements for performing our job when requesting medical records and submitting requests with the Social Security Administration. These forms include basic information already present in each record for the client. There are about seven situations that the new database should notify us when a follow-up is necessary on our part based on when either a claim was requested and no response (approximately 120 days after being filed) has been received or when we have requested medical records or forms signed from the client and have not received (approximately 21 days after being requested) them yet. ## Deliverables 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). ## Platform Windows IIS webserver preferably writtin in PERL or optionally ASP or PHP.