517286 Simple MS Access Relational Database Application with GUI
N/A
Σε Εξέλιξη
Αναρτήθηκε περίπου 13 χρόνια πριν
N/A
Πληρωμή κατά την παράδοση
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:
[login to view URL] 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
[login to view URL] Design
- Setup 4 database tables with relationships
- Fields and relationships have been decided, but advice from your personal programming experience would be very helpful.
[login to view URL]
- 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
[login to view URL]
- 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.