En cours

Microsoft Access 2010 SIMPLE CRM SETUP

We have a small company. We require an office CRM made using Microsoft Access 2010.

In the company we have a Managing Director, 2 sales people, an administrator and a designer.

We require there to be one database for each of the employees for the manager to view.

We have enclosed some spreadsheets with an idea of the fields required. We have also enclosed the mailmerge documents that the sales, administrator and managing director will need to generate.

The databases and spreadsheets will be linked so that the employees will complete their clients details which can then be seen by themselves, the administrator and also the managing director.

Each employee will be able to input their own informaiton and their commission will be generated each month as 3% of the commission received from each of their clients.

Each employee will only have access to their own informaiton. The Managing Director will have access to everything and be able to generate reports and also payslips, contracts, invoices etc.

The invoice spreadsheet enclosed shows an idea of the the fields we require. Please use your own ideas to set this out the best way possible. Just to explain some of our clients pay monthly others pay in two or three stages. We need the total to be shown easily and also the slaes persons generated commission which is 3% of the amount received.

The clients detailed spreadsheet is enclosed. Some of these fields are required for a mail merge. We require a well designed form for our sales people to be able to enter and view the clients easily. An easy search function also. There should be tabs for basic details, invoice details etc within the form.

The employee should be able to generate invoices, proposals and also see their commission generated. I have enclosed the invoice and proposal forms. Please set up the mail merge.

Each employee should have their own spreadsheet on their own computer. We have a network set up in the office.

They should only be able to see their own fields and clients etc.

However the managing director would like to be able to view each employees clients, their status and also the commission generated for each client/by each employee and total commission generated by each. The managing director will also need to be able to generate salary payslips. Please see July salary excel sheet enclosed. The payslips will be a basic monthly salary + 3% or earned commission.

The salary runs from the 1st of the month until the end of the month. The payment date is on the 16th of the following month. Therefore we require a part month salary to be a percentage of the total monthly salary.

There should be a sharing function obviously therefore for the managing director to be able to see and change everything as required. The designer and the administrator should have limited access. The designer should only be able to see clients details to which he is invited or has shared with him.

The amdministrator should be able to see everything however not be able to make changes only ue the information to generate forms etc.

As well as the functionalities we would like the forms to look good and be easy to navigate.

As discussed we have an office network on a windows 2003 server. We have a shared drive and also we have our own individual folders that only each employee themselves and the managing director can access.

We would like these databases and tables to be shared between us on either the shared folders or the limited access folders or both. Please organize and advise.

We look forward to hearing from you.

Kind regards

Compétences : CRM, Administration de Bases de données, Microsoft Access, Serveur Windows

Voir plus : crm access 2010, access 2010 crm, access 2010 crm database, crm database access 2010, use access 2010 crm, simple crm database access, crm using access 2010, microsoft access 2010 crm, crm access, simple access database crm, simple crm microsoft access, crm microsoft access, office 2010 access crm, using microsoft access crm, simple crm access database, crm microsoft access 2010, database crm access 2010, basic crm access, setup access crm 2010, company need employee easily, spreadsheet designer, slaes, salary search, payment enclosed, part payment invoice

Concernant l'employeur :
( 14 commentaires ) Shanghai, China

N° du projet : #2396629

10 freelance ont fait une offre moyenne de 213 $ pour ce travail

sandeep25101982

Hi Please check private message for details. Thanks

250 $ USD en 10 jours
(15 Commentaires)
5.3
winnet21

Hi, I have experience with this project Please check PM

200 $ USD en 20 jours
(14 Commentaires)
5.0
Nhcuong

hi, i can do it. I'm programmer for years and very familiar with MS access. We can use encrypted MS Access in shared folder of LAN. The db will ask user to login when open it and assign their privileges accordingly (s Plus

300 $ USD en 30 jours
(3 Commentaires)
3.0
mzahid32

Hi, I am willing to help you out in this project.

140 $ USD en 5 jours
(2 Commentaires)
1.9
X8n43bOYC

Custom software development (<b><i>Removed by Admin</i></b>)

250 $ USD en 1 jour
(0 Commentaires)
0.0
youngtiger

sir, Please check PM

150 $ USD en 3 jours
(0 Commentaires)
0.0
DataAppGuru

I have 10 years experience in Access databases. I can do this project. More details in the PMB. Thanks.

99 $ USD en 5 jours
(0 Commentaires)
0.9
DaddyWarbucksEsq

My name is George Panko, dba The Immaculate Cohhection*. I am relatively new to this freelancer site, but am well-established on Guru.com. Since 2001, I have specialized in designing, developing, and maintaining M Plus

150 $ USD en 2 jours
(0 Commentaires)
0.0
danghungit

it will be done

200 $ USD en 7 jours
(0 Commentaires)
0.0
mslien

we can help you

340 $ USD en 35 jours
(0 Commentaires)
0.0
optimosys

We can do this for you, we have dedicated and we experienced team working on PHP application development.we can do this with PHP and MYSQL.We can install it single system we can access from any web based browser

200 $ USD en 15 jours
(0 Commentaires)
0.0