Database design

已完成 已发布的 Jul 27, 2015 货到付款
已完成 货到付款

I run a Uber driver, income processing service.

I accept people's payments from Uber

I take the drivers on as employees and pay them as such.

I issue them with a fuel card for petrol purchases and an e-tag for toll road usage.

Each week from their Uber income, I deduct

- those two amounts (tolls and fuel)

- Workcover insurance (1.1%)

- Superannuation 9.5%

- my Fee GROSS < $500 (per week) CHARGE $5

GROSS BETWEEN $501 - $1000, we charge $8

GROSS EARNINGS GREATER THAN $1001 $15

I have attempted to create an excel spreadsheet that will allow me to import data from the fuel card usage and from tolls, allow me to input driver's income and then produce a report showing:

- Name

- Employee Code

- Gross income

- fee breakdown

- Income history graph

- Toll usage for past 7 days

- Fuel card usage with average mileage (based on odometer reading) (graph)

I was advised due to the volume of data being imported each week, a database would be a better way to go. (see access database attached)

The excel sheet worked, but I couldn't get the report to generate the way I wanted. So I attempted to convert this to an Access DB.

Project crtieria:

Import CSV files from fuel & toll data (sample files provided when assigned)

Have a GUI interface to request reports

Ability to produce individual reports in batch and export (either as PDF or email (individually)

Ability to request reports for specific employee

Perform the deduction calculation

This database can either be web based or desktop based (access? or other)

I engage with most bidders, those placing low bids only to jack up the price later will not be considered.

数据库开发 微软Access

项目ID: #8152264

关于项目

24个方案 远程项目 活跃的Jul 30, 2015

授予:

fuentro

Good day, my name is Rodrigo. I have been developing MS Access solutions and applications for my workplace for the past 6 years, during this time I have been in charge of: designing, planning, implementing and maintain 更多

$277 AUD 在3天内
(28条评论)
6.0

有24名威客正在参与此工作的竞标,均价$335/小时

fabest

Dear, I am Access/VBA expert since 11 years. I checked your project description, and I confirm I can develop your Access DB. -I can generate all your reports / graphics ... I will focus on user friendly interface. 更多

$247 AUD 在5天内
(82条评论)
7.3
shikhamehta

Hey, What is the volume of data being imported each week? Even If it is more than a thousand records a week, you would still be better-off in using Excel itself. I reviewed the spreadsheet and have an understandin 更多

$333 AUD 在10天内
(49条评论)
5.8
zu02

Hi Yes, your are completely right, this problem will have to solve via Access app. Please see my profile and portfolio with screens of my Access app-s . Maybe you will find here that I'll solve your project success 更多

$155 AUD 在3天内
(59条评论)
6.2
florinserban

Hi, My name is Florin and I am a database applications developer. I am from Romania, my time zone is GMT+2, Bucharest. You were advised correctly, it is better to have a database driven application, instead one t 更多

$200 AUD 在10天内
(16条评论)
4.9
CodeAmbassador

Thanks for your time on the chat. I have updated my bid in line with that. Within 5 days I will design, implement and help you go live with a sql-backed desktop app that allows you to import the data easily automating 更多

$789 AUD 在5天内
(5条评论)
4.4
rashmisingh2990

I am database expert having experience of 2 years.I will definitely complete your work and deliver it to you on time

$85 AUD 在4天内
(27条评论)
4.0
dpune

Hi, I have more than 14 years of foxpro exp and I am expert in this kind of work. I have completed more than 240 projects. Please look at the feedback left by my employers to know more about my work. Waitin 更多

$250 AUD 在20天内
(4条评论)
3.4
pegasus9529

Proposal belum diberikan

$277 AUD 在5天内
(1条评论)
3.2
rainbow

A proposal has not yet been provided

$277 AUD 在3天内
(2条评论)
2.6
dicksonkaranja

I have been writing academic papers, academic reports, essays, creative writing, technical writing and many others such as programming, databases and graphical user interface design for the last six years. I assure you 更多

$55AUD 在1天里
(0条评论)
0.0
ahmedmohsen2008

Hello Sir, This is Ahmed Mohsen from Egypt. I have excellent experience in excel, excel programming and linking between excel and MS Access. I can use my experience to support you with the required program, and if 更多

$333 AUD 在3天内
(0条评论)
0.0
jde55b6067aadee0

I've created many DB applications over the years, and have specialised in converting Access DB projects to fully fledged applications when businesses grow. This makes me very good at designing access DBs in a way that 更多

$155 AUD 在3天内
(0条评论)
0.0
helarilaurent

Day to day basis I work on big database projects ( millions of rows of data ) and I can understand exactly what you need from this project. I will create a WEB based database system for you that is fully automated. ( y 更多

$1055 AUD 在3天内
(0条评论)
0.0
aclark6996

Hello, I'm able to design your Access database for your Uber driver income processing servier. I have over 3 year experience designing Access databases and would be able to customize the database per your request. Wh 更多

$230 AUD 在10天内
(0条评论)
0.0
romytiu

Hello, I would like to offer my expertise in MS Access database programming for your Uber Drivers' Payroll Database Processing requirements. I've been an MS Access developer with expertise in VBA for 15 years and s 更多

$250 AUD 在5天内
(0条评论)
0.0
cecolor

Hello, My name is Carlos, I have my own startup company developing databases and programming. I am confident that me and my team are able to meet your requirements. We can have a meeting, if you like to go over 更多

$250 AUD 在5天内
(0条评论)
0.0
naveedaqu

I have complete such project for a client in oil and gas sector, I have good working knowledge of Microsoft .NET plate form. for data base I can use Access, SQL server. I prefer to make a web application so that can 更多

$300 AUD 在25天内
(0条评论)
0.0
dhruvahuja316

I am a J2EE developer and can make your project with ms access DB so comforting that you can access all the details of Your every Employee very Easily.

$222 AUD 在5天内
(0条评论)
0.0
mrb2020

I have strong database development and administration skill which can benefit you get this job done quickly. Also have front end(web) experience which will be used for GUI display of reports. You can provide me with t 更多

$861 AUD 在7天内
(0条评论)
0.0
ssriramiyer29

hi, I would suggest a mysql database setup on your desktop. The milestones for the project will be : 1. set up the database, 2. data model , 3. module for loading csv files, 4. GUI to get reports.

$333 AUD 在20天内
(0条评论)
0.0