Database design

Completado Publicado Jul 27, 2015 Pagado a la entrega
Completado Pagado a la entrega

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.

Desarrollo de base de datos Microsoft Access

Nº del proyecto: #8152264

Sobre el proyecto

24 propuestas Proyecto remoto Activo Jul 30, 2015

Adjudicado a:

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 Más

$277 AUD en 3 días
(28 comentarios)
6.0

24 freelancers están ofertando un promedio de $335 por este trabajo

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. Más

$247 AUD en 5 días
(82 comentarios)
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 Más

$333 AUD en 10 días
(49 comentarios)
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 Más

$155 AUD en 3 días
(59 comentarios)
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 Más

$200 AUD en 10 días
(16 comentarios)
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 Más

$789 AUD en 5 días
(5 comentarios)
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 en 4 días
(27 comentarios)
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 Más

$250 AUD en 20 días
(4 comentarios)
3.4
pegasus9529

Proposal belum diberikan

$277 AUD en 5 días
(1 comentario)
3.2
rainbow

A proposal has not yet been provided

$277 AUD en 3 días
(2 comentarios)
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 Más

$55 AUD en 1 día
(0 comentarios)
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 Más

$333 AUD en 3 días
(0 comentarios)
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 Más

$155 AUD en 3 días
(0 comentarios)
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 Más

$1055 AUD en 3 días
(0 comentarios)
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 Más

$230 AUD en 10 días
(0 comentarios)
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 Más

$250 AUD en 5 días
(0 comentarios)
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 Más

$250 AUD en 5 días
(0 comentarios)
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 Más

$300 AUD en 25 días
(0 comentarios)
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 en 5 días
(0 comentarios)
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 Más

$861 AUD en 7 días
(0 comentarios)
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 en 20 días
(0 comentarios)
0.0