Access Database merge automation and user interface
$100-500 USD
Закрито
Опублікований over 17 years ago
$100-500 USD
Оплачується при отриманні
We have a very basic access database that is used to track claim applications and automate the sending of letters. We have queries set up to show when letters are due to be printed but are using a mailmerge process each day
What we require is
Simple user interface for steamlining data entry and modifications with a fast search routine that allows easy searching by typing the first few keys and a list of possible matches are immediately shown
single point of click and letters should be automatically generated, printed then status and date is marked in the db
ability to attach scanned document in pdf or image format to each record so they can be printed with the merge letters 1 docs max per record. Can be a field for data file location on server but must have abilitilty to print with the automated letters. Ideally if we could have a separate app that scanned the document and attached to database automatically. A4 b&w only
Modify a spreadsheet with a button to populate 2 data fields in the DB with data and to auto save as variable made up as 3 cells in the sheet. Withn the ability to auto attach a copy of the .xls file or .pdf so it can be printed with the letter merge
On data entry interface we need a drop down selection to select 1 of 10 companies. On the mail merges we will need the address at the top of the letter to be defind by this selection. Mailmerge 1&2 wl use a different address to mailmerge 3&4 and emailmerge 1`&2 will also used a different address. To summaries threre will be 3 addresses for each selection
Simple Web form to populate a new record in db
## 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 _Uk_. 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 XP
In all versions of IE, Netscape, mozilla and other browsers