MS-Access Expert needed.

Very simple project but you must have experience with Expressions, Query, Forms & Report design.

I will pay you through GAF. Payment will be made after successful completion of project.

I already created table you just need to write expressions for validations and reports.

Note:---> I needed to finish it within 2-3 hours.


As mentioned before, this Access 2007 database is for a mock same-day courier company.

I have included a rough guide db so far with some customer/courier details included (all mock details) to save you some time.


Table for customers – Name, contact numbers, full address, notes, email address and a yes/no if they are a “volume” customer (in which case they get a fixed % discount. Should have a form for inputting/editing data entries

Table for couriers (employees) – Name, mobile number, the range they can travel (i.e. they can do a job which is 10km), the vehicle they have and if they are available (again, simple yes/no). Should have a form for inputting/editing data entries

A table for globals (pricing?) – The % discount volume users get on pricing, the min charge per delivery, the price per KG (up to a maximum price eg £5) and the price per KM)

A Table for creating jobs – Customer name (linked from customer table), pick up address, delivery address, approx distance of delivery, weight of package, manual selection of courier (should list available couriers, show couriers who’s range is within the approx distance and choose courier, price of the job (calculated from globals table taking into account the price per kg (up to the max price), volume discount if applicable, price per km (on top of price per kg) and it should be time/date stamped once put into database. There should also be a simple yes/no to state if the delivery has been completed. This also needs a form for inputting/editing data entries.

Then there should be reports generated for:

All outstanding deliveries (including job details)

All completed deliveries (including job details)

All completed deliveries by courier (so a certain courier can be selected, and a report shown for all their deliveries only (including total km travelled)

I think that is the complete specification,



Skills: Accounting, Expression Engine, Microsoft Access, Microsoft Expression, Visual Basic

See more: visual design jobs, visual c# jobs, top query, thanks you notes, table top range, state of s.c. jobs, state of n.c. jobs, state jobs, same day pay jobs, range query, range maximum query, pay expert, package design pricing, no editing needed, ms project jobs, ms project expert, ms access jobs, ms access database jobs, mock data, mobile specification database, min range, maximum max, max delivery, list of accounting entries, linked in jobs

About the Employer:
( 0 reviews ) New Delhi, India

Project ID: #560090

18 freelancers are bidding on average $84 for this job


I can finish this within few hours

$50 USD in 0 days
(58 Reviews)

I can deliver this as per your specifications

$40 USD in 1 day
(29 Reviews)

Hi This is Piyush Patel I have 5 yrs of Exp in VB6,,SQL and MsAccess. I have developed many applications in VB6,VB.NET. Please Check My PM

$100 USD in 1 day
(16 Reviews)

Hello Ready to start right now. Please see your PMB for details. Thanks

$55 USD in 0 days
(33 Reviews)

I am an IT professional with 10 yrs experience. I have very good experience with Ms-Access 2007. I have completed many projects on GAF in Ms-Access 2007. I will provide quick & professional serivce.

$100 USD in 2 days
(23 Reviews)

Exceptional quality & Quick work. Please refer to Profile & PMB for details. Thanks FAZ

$50 USD in 0 days
(14 Reviews)

Hi, Please read the PM

$150 USD in 1 day
(6 Reviews)

Please, check your PM box

$75 USD in 1 day
(1 Review)

I have been developing MS Access databases for over 10 years and can turn your project over in the timeframe that you have requested. I look forward to hearing from you. -Nikki W.

$50 USD in 1 day
(1 Review)

we can make it easily

$30 USD in 1 day
(0 Reviews)

Dear sir, Please check INBOX for more details Sincerely Rajendra

$175 USD in 0 days
(0 Reviews)

I can provide you the desired result.

$100 USD in 1 day
(0 Reviews)

I can do it in one hour.

$30 USD in 1 day
(0 Reviews)

Hi, I can do it in 3 hours

$100 USD in 0 days
(0 Reviews)

I am interested in the project. I have already worked on the access related project. Please select me as the provider for the project. Thanks

$100 USD in 0 days
(0 Reviews)

Hi Sir. I can do it in a very easy and short way... 2 hours should be good for me to do this works. Check your PM for more information

$50 USD in 1 day
(0 Reviews)

The same type of project we have already done in the past. So please consider our candidature.

$55 USD in 1 day
(0 Reviews)

I CAN COMPLETE your project in 30 working days and if u need a sample send me ur data i will made a sample for u

$200 USD in 30 days
(0 Reviews)