This is a project that will allow users to log onto a website and look up information.
Every month we generate about 300,000 records in the Dbase format with fifty fields and the following must happen:
After we FTP the dbase file in a zipped format to our server, we need to remove the prior months' database.
NO UPDATING OF THE CORE DATA WILL BE HAPPENING ON THE SERVER, WE UPDATE LOCALLY AND LOAD A NEW DATABASE.
1) Tool for removing old database
2) Tool for importing the new database in SQL (Linux server )
3) Tool for testing the database
4) Search screen for users with up to 12 search fields
5) Upon search, users will be able to browse the results;
5a) Print one record
5b) Print all results
5c) Download results in an excel format, mailing label or mail merge for MS Word.
5d) Limit of 500 results per search
6) Users will need a user ID and Password to use data
7) We need an admin screen for user id and password generation
This is a starting point we will want ongoing support, so please bid the project and you support prices separately in your email. Must have references!