Objective: Design an Access database program (MS Access 2000 or greater) to manage telecommunication carrier rates and dial codes received from various carriers. Each Carrier file will contain unique Dial Code(s) and Rate(s). The program will match newly added carrier files by destination code then load a rate under the respective carrier column. The program will work from 3 different files 1) Main Table 2) Carrier File 3) Result Table
The Main Table shall include two columns 1) Dial Codes 2) Destination Name This should be replaceable or amendable thru a simple file upload in a .TXT or .CSV format. The main table should not be limited in number of rows for unique dial codes.
Carrier File will include only Dial Codes and Rates in a .TXT or .CSV format <<>>>
Result Table should contain 1) Dial Codes 2) Destination Name 3) Carrier (ABC name)_Rate. If 5 different carriers are to be loaded the result table would show all five separate columns of rates by carrier.
If a carrier file does not contain a Dial Code that matches the Main Table the Carrier Result field should be left blank in the Rate column.
This is in concept only, we are open for suggestions.
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).
Windows XP/MS Access 2000 or higher