Completado

Database design

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.

Habilidades: Desarrollo de base de datos, Microsoft Access

Ver más: web design and development pdf, web design 2015 pdf, wanted employees, excel, database development, database programming, microsoft access, visual basic for apps, service database access, sample graph data, report card design, graph sample data, design of road, design access database, db import export, database development service, database design web, batch processing of excel data, 1001 design web, design database inventory chemicals

Información del empleador:
( 13 comentarios ) Newcomb, Australia

Nº del proyecto: #8152264

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
(10 comentarios)
4.3

25 freelancers están ofertando el promedio de $327 para 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
(25 comentarios)
5.7
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
(62 comentarios)
5.7
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
(14 comentarios)
4.3
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
lavizsolutions

Hi, Please share me the excel files, i will suggest to have web based database plus few web pages to import the data and get reports. The work is really bigger one , so sorry for going for high amount.. Please Más

$750 AUD en 25 días
(1 comentario)
4.1
AlexandrK1

Предложение еще не подано

$250 AUD en 10 días
(7 comentarios)
4.3
fazeelatmazhar

Sir/Madam, Greetings. This is an IT person , an experienced database developer , an experienced designer and an experienced technical writer. I have developed university management system , advanced timer, file t Más

$200 AUD en 7 días
(6 comentarios)
3.3
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)
2.2
aleator

Desktop based (access) I will help quickly and efficiently. The first result within 24 hours! Ready to do this job. So far I have only some closed projects in Access. Maybe your project will be the next? From the A Más

$100 AUD en 3 días
(4 comentarios)
2.2
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
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
pegasus9529

Proposal belum diberikan

$277 AUD en 5 días
(1 comentario)
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
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
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
(0 comentarios)
0.0
fazeelraza

Hello, sir. I am a SOFTWARE ENGINEER and I have worked on Access databases before. I have done CRM systems before for other businesses. I understand your requirement and I can make this for you. PM me ASAP to have furt Más

$150 AUD en 3 días
(6 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
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
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
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