Devam Ediyor

517286 Simple MS Access Relational Database Application with GUI

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:

[url removed, login to view] 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

[url removed, login to view] Design

- Setup 4 database tables with relationships

- Fields and relationships have been decided, but advice from your personal programming experience would be very helpful.

[url removed, login to view]

- 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

[url removed, login to view]

- 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.

Beceriler: Her şey Kabul, Veri Tabanı Yönetimi, Java, Microsoft Access, PHP, Web Güvenliği

Daha fazlasını gör: access gui, windows gui programming, windows batch programming, programming java on mac, programming in access database, programming in access, programming function keys, programming access database, old database, ms access with php, ms access programming, java programming version, java programming on mac, java programming mac, java database programming, gui programming java, function block programming, final specification, design access database, data access interface, customer table, create a search function in php source code, create application with php, application design specification, access database design programming

İşveren Hakkında:
( 7 değerlendirme ) cork, Ireland

Proje NO: #2263219