Crime Watch Contact List
$30-5000 USD
Pagado a la entrega
Member list to be created in Microsoft Access or Microsoft Excel, with Excel being the preferred format. If Access is used, the ability to export to Excel must be included. A sample file in Excel is provided for a visual.
Sorting capability within the following criteria: ‘First Name’ OR ‘Last Name’ OR ‘Home Address’. After choosing one of the 3 sorting criteria, the entire 7-line individual box should remain intact and move within the pages according to the selected sorting criteria.
Each individual page will consist of 3 lines at top and 3 individual boxes.
The individual box consists of 7-lines including heading line and is outlined with a black rule. Again the ‘First Name’ or ‘Last Name’ or ‘Home Address’ boxes will be the basis for sorting. Not all 3 at once, but a choice that can be made at time of sorting.
If possible, a macro for each one of the sorting criteria.
Report date at the top will reflect current date when file opened.
Need the ability to add additional pages as new members are added.
Footer to reflect total # of pages.
Current file is in Excel and consists of about 60 member names. Will need to export this Excel 2003 file into the newly created file. The old file is different than the new file you will create. There are 2 additional lines of information on the new file: Mailing Address (if different) and Pets: Type / Breed / Name. The information on the current file is personal and cannot be shared so I do not want to send the existing file. Thus instructions on how to export to the new file will be needed.
Files will occasionally be converted to Adobe .pdf files. Thus all information must be printable to a .pdf.
## Deliverables
1) Complete and fully-functional file in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows:
a) Completed file(s) must be compatible with newest version of Microsoft Access (if used) and Microsoft Excel. Files must be backwards compatible to versions of both software programs from 2001 forward.
b) Instructions on how to set sort need to be included, or a macro for each of the 3 sorts to be included with file.
c) Instructions on how to export a current Excel file to the newly created file, or a macro to do so must also be included. Note that the current file is not exactly the same as the new file.
d) File must be able to print to an Adobe .pdf with all information showing in the final .pdf. We will upload the .pdf to a password protected website.
e) 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 XP.
Nº del proyecto: #3388686