In Progress

Advanced Microsoft Access Database programmer wanted

I am looking for someone to program a customer management database in Microsoft Access 2010.

The concept of what I need is as follows:

I have a database of customers (Personal data, Email address, Telephone number etc.)

I also have a database of products (These are genetic tests where I have fields that contain the results of a genetic test. Different fields for different tests.) These fields should only have 3 different options of what information to contain. So maybe something like 3 Checkboxes with only one to be active at any given time would be needed?)

I also have a database of distribution channels

I also have a database of distribution channel acquirers that get a certain percentage of what they acquire

I also have a database of countries and the respective VAT ercentages to be used in invoicing.

This is what I have, but I now need this system to be linked and automated.

I need:

Customer Database:

The option to link a customer to a distribution channel (Choose from a drop down menu maybe? I do not want to use numbers because of risk of mixups)

The option to open a customer window and choose which products he ordered. Maybe on a check-box basis?

Depending on the products ordered, the specific product fields should appear in this customer view to be filled out

When all fields are filled out, the software should mark it as "completed"

Distribution Channel Database:

The option to assign a certain price for each product to each distribution channel

The option to assign which acquirer acquired the distribution channel and what percentage he gets from the revenue

Functions required:

Create invoice, save as PDF and send it via Email

Send a certein Email when a certain checkmark is checked

List all customers that have the same information in one field of one specific product

List all customers that still have no information in one field of one product

Alert me when certein deadlines are crossed

This might sound a bit confusing as I do not understand access very well and hence do not know all of its capabilities, but I would want to progressively build and extend this database as we go along and go step by step.

I would want to also see this as a training-session of how to use access for me, not just a Job for programming the database.

This means the job would be on an hourly basis and be time consuming at first but progressively less work as I will only need help for more advanced questions and support.

Skills: Microsoft Access

See more: microsoft access programmer wanted, access programmer wanted, access database wanted, access database programmer, access programmer needed, microsoft access programmer, access database programmer needed, access database programming pdf, access database programming wanted, microsoft access programming wanted, access programming pdf, need microsoft access programmer, advanced access database questions, access software wanted, access wanted, advanced access questions, wanted microsoft access programmer, access database help wanted, access help wanted, advanced access 2010 programming, access database programmer wanted, where to get a job on programmer, where do i get a programmer, what support will i need from management, what is database programming

About the Employer:
( 307 reviews ) Salzburg, Austria

Project ID: #1326138

Awarded to:

djucuti

Hi, please check PMB

€8 EUR / hour
(16 Reviews)
4.5

10 freelancers are bidding on average €10/hour for this job

winghei

Hi, I see your needs and I want to help. Please see attach file for my sample work. Regards

€10 EUR / hour
(28 Reviews)
5.3
Krusche

We are a German IT company with headquarters in Munich. One of our specialties is providing complex solutions with Access/Excel + VBA. German speaking. Working onsite is also possible.

€30 EUR / hour
(7 Reviews)
4.8
TCar

Hi, I can develop this for you. I have over 5 years of experience developing MS Office apps and am available to start immediately. Please have a look at my profile for further information regarding my qualifications More

€17 EUR / hour
(6 Reviews)
4.2
braghunath

I have been developing applications in MS Access since the year 2003. I can take up this project immediately. Thanks [url removed, login to view]

€9 EUR / hour
(3 Reviews)
4.1
guevanjr

Please consider my bid. High quality work and timely delivery is assured (it'll be delivered in less than a week). Thanks, SG

€5 EUR / hour
(5 Reviews)
3.1
ioanaprof

Hello, Extensive experience in MS Access and VBA. At your service! John

€7 EUR / hour
(11 Reviews)
3.2
rose82

Hello, I'm ready to start work on it, Please check your PMB for detail. Thanks.

€3 EUR / hour
(0 Reviews)
0.0
kaddusgfl01

I am an expart in database programming with MS Access and SQL. Please consider me for your project.

€5 EUR / hour
(0 Reviews)
0.0
Tkg2010

I am interested in your project.

€10 EUR / hour
(0 Reviews)
0.0