access database design

Đã Đóng

I need an access database (that I can then trfr to sharepoint after completion) that can:

1. Track client data.

2. Track Contact data and where Contacts can be assigned roles within the claim, for example a contact can be assigned "insured" role in one claim, but a "referral" role in another.

3. Track work order data. based on several data points. It must generate custom file numbers (not necessarily the record ID). the work order list should point to the client it belongs too, the contacts involved, and also track who inspected it and who wrote the estimate. It also needs to track mileage for the assignment and who's mileage that is. Thecost of the workorder should be extracted from a master list, but I should also be ale to overwrite on the live environment.

4. Invoices generate and track. Invoices should be assigned on a 1-1 or 1 - many bassis to work orders. We should also be able to track and invoice submission.

5 A/R functions. At least basic ones for now. when paid, how much paid, what is owed, client credit limit, available credit.

6 Email notification as the project progresses to the client, automatic calendaring to outlook, when database dates are updated. Daily Email diary to parties.

7. This database will eventually be incorporated with a credit card payment basket, I prefer if the developer knows how to do this, so that once we are ready to deploy, we can easily link the two, without having to bring in a new developer. The database will also eventually be expanded to perform full accounting and reporting, but not now.

8. Database should allow for each Client to be able to log in thru web portal or app, and view the open claims assigned to them. For example, we want the client to be able to log in, view our public notes, read letters associated and download/upload attachments.

Please provide a budget and estimated timeframe of completion.

Kỹ năng: Thiết kế, Thiết kế đồ họa, PHP, Thiết kế trang web

Xem thêm: what should i put in freelancer if i want to design an access database, outsource for database access for credit card processing, design asset tracking database access, design database access excel, design library management database access, database design microsoft access, design ecommerce access database, design database travel company access, using access design database medical practice, database design using access, database access design, payment design database, implementation database design ms access, database design ms access, database design develop installation payment proposal, quarterly payment samples database access, simple payment tracking database access, inventory database design sample access, access database template payment tracking, payment tracking database access, web design forms access database, access payment tracking database, design database access

Mã Dự Án: #13451803

23 freelancer đang chào giá trung bình $681 cho công việc này

drupaltonic

Hi,Its just the beginning of our long term professional relationship,so let’s connect now :) I have gone through your requirement and understand that your business is unique and Drupaltonic has always built websites Thêm

$888 USD trong 30 ngày
(102 Đánh Giá)
8.5
Yknox

Hello I'm interesting your project very well I'm a Good C++, Ruby, OpenCV, Math, Jave, Algorithm expert. I m quite well experienced in these jobs. Let's go ahead with me I want to service for you continously. Thêm

$721 USD trong 10 ngày
(302 Đánh Giá)
7.7
p4provider

Hello 1) I do recommend Magento, Woocommerce and Prestashop to my clients because these are the tested platforms and best for eCommerce application - Magento for complex and huge cataloging - Prestashop for medi Thêm

$1000 USD trong 10 ngày
(135 Đánh Giá)
7.8
mituld

Hi I work towards providing reliable, relevant and robust IT solutions at most competitive prices to my customers. I ensure 100% customer satisfaction so lets start Thanks

$515 USD trong 15 ngày
(354 Đánh Giá)
8.1
fortranPRO

Dear Employer, Greetings from fortranPRO. I have worked on similar projects to what you are looking for, and I am confident that I can exceed your expectations. I have attached samples of work very similar to wh Thêm

$600 USD trong 18 ngày
(138 Đánh Giá)
7.3
Shopify

Hello, Greetings from Shopify We have recently completed the similar project and would like to show you a live demo which is similar to your project . I would like to discuss your project in more details so during Thêm

$670 USD trong 12 ngày
(20 Đánh Giá)
7.0
SevenStarInfo

Hello ! We want to discuss about your project as we have experience in it. What Differentiates us from the other freelancers : # Experience of more than 5 years in Unity 3D, Xcode, CoCoa 2d, Phonegap and major Thêm

$1000 USD trong 10 ngày
(67 Đánh Giá)
7.1
phpdeveloper100

I have 6+ years experience and I have done more then 50+ projects in my career.Kindly note I am full feldged developers and work for 17 hours in a day.I am ready to start the project kindly open the private message box Thêm

$586 USD trong 15 ngày
(65 Đánh Giá)
6.9
fullymagento

Hello sir, I have reviewed your requirement and after understanding it well excited to work with you on your awesome concept.I would really love to speak with you further regarding this project, so kindly come in pm Thêm

$1666 USD trong 10 ngày
(53 Đánh Giá)
6.9
prashushinde9

I want to discuss this project with you further, let me know the best suitable time for you to schedule the meeting, Feel free to message me at any time, i used to be online 14 hrs in a day on this website so probably Thêm

$773 USD trong 20 ngày
(59 Đánh Giá)
7.1
mike199

Hi, my name is Mike, I’m based in Oxford, UK. Your project description sounds interesting to me and I do have skills & experience that are required to complete it to a high standard. I can show you some examples of my Thêm

$555 USD trong 10 ngày
(54 Đánh Giá)
7.1
shreeyait

Hello Sir, Hope you are fine there. We are having good experience with CorePHP projects and the reason we came across here to give the best output to your project with supreme quality. We have develope Thêm

$444 USD trong 10 ngày
(68 Đánh Giá)
7.0
hexamilesoft

A proposal has not yet been provided

$400 USD trong 10 ngày
(133 Đánh Giá)
6.7
hiramalik321

Hi there, I've read your project description and I am confident enough that I can handle this project according to your expectations. I have done similar projects before and I want to take over this project as well. If Thêm

$555 USD trong 15 ngày
(34 Đánh Giá)
6.0
CaptainSadaf

I’m experienced in PHP, JavaScript, MySQL, HTML5, CSS, Bootstrap and Ajax. windows, Linux and SugarCRM projects in Php, Html, JavaScript, Jquery CSS, Bootstrap, Ajax, SQL, MySQL, Wamp/Xamp Server. I have a working ex Thêm

$688 USD trong 12 ngày
(5 Đánh Giá)
3.2
cracken

Hi Estimar, I am competitive to this kind of task, can take good care of this project. In fact, I already done related to this job before. Let me know the best of your time so we can discuss further based on your requ Thêm

$749 USD trong 30 ngày
(4 Đánh Giá)
2.7
jawad7ali

Hi, I am interested in your job and ready to start your work. i will design your project as u design your database skype: jawad2gull Thanks, jawad

$260 USD trong 10 ngày
(3 Đánh Giá)
2.3
zdesign77

Hey, how is it going today? My name is Michael, I'm a web designer/developer from Boston. I've had a look at your project description and feel that my skills match your requirements perfectly. In fact, I did a very sim Thêm

$555 USD trong 10 ngày
(1 Đánh Giá)
2.1
$555 USD trong 10 ngày
(16 Đánh Giá)
1.8
appsembly

Hello, Hope you are doing great. I have reviewed your job description deeply and very confident to handle this project perfectly. I'm a professional in website development (PHP, Codeignitor, CRM, Wordpress, Joomla, Thêm

$555 USD trong 10 ngày
(1 Đánh Giá)
1.2