I have a large direct mailing list of prospects and need a simple application to record and display ‘Sales’ or ‘unsold returns’ of samples. I have detailed the following plan to get this done:
1.Copy old data into new table
– copy customer records from old access database table (around 100,000 records)
– check for duplicate entries
– insert fields to my specification
– Insert 16 digit unique key numbers for each customer record
2.Database Design
– Setup 4 database tables with relationships
– Fields and relationships have been decided, but advice from your personal programming experience would be very helpful.
3.GUI
– create gui to specifications (Java preferable as viewing on Mac but will be implemented on a windows system eventually)
– Simple button Graphics will be supplied.
– Security Feature: block to stop the use of certain aspects of the GUI without a password (not on the database itself, just on the GUI features).
– Create data filter interface with drop down menu and checkboxes of filter options to display customer records and their related data
4.Routines
– Routine to create .csv etc from data query for mail merge into MS Word
– Routine to add records to certain tables in a batch process using groups of unique keys typed in by the user.
– Print Button to print data from queries.
– Form to add customer records individually.
– Search function to search for customer records and their related data using unique key typed in by user.
– Routine to add new records to customer table by preconfigured .csv file (including checking for duplicate entries).
Several variations of the above routines will also be needed. e.g. a dedicated button to append data to any record unchanged in the last x years.
We will also need:
final version of precompiled source code
Must be available on Skype
To be completed as soon as possible preferably within 1 week.
