Freelancer

MS-Access Expert needed.  

MS-Access Expert needed. is project number 560090
posted at Freelancer.com. Click here to post your own project.


| More Free Trial For New Buyers
 

Status: Cancelled

Selected Providers: -

Budget: $30-250

Created: 11/28/2009 at 8:28 EST

Bid Count: 18

Average Bid:
$ 84

11/29/2009 at 8:28 EST

Project Creator: alphaetech
Employer Rating: (No Feedback Yet)

Bid On This Project
 

Description

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.



Specifications:



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,


***************************************************************************

thanks

Messages Posted:0 View project clarification board Post message on project clarification board

Bid On This Project
 

If you are the project creator or one of the bidders Log In for more options

 

50

0 days

11-28-2009 12:19 EST

I can finish this within few hours

help

 

100

2 days

11-28-2009 12:10 EST

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.

help

 

40

1 day

11-28-2009 22:56 EST

I can deliver this as per your specifications

help

 

175

0 days

11-28-2009 23:58 EST

Dear sir, Please check INBOX for more details Sincerely Rajendra

help

 

55

0 days

11-28-2009 11:46 EST

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

help

 

50

0 days

11-28-2009 12:10 EST

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

help

 

150

1 day

11-28-2009 12:56 EST

Hi, Please read the PM

help

 

100

1 day

11-28-2009 09:38 EST

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

help

 

75

1 day

11-29-2009 05:15 EST

Please, check your PM box

help

 

100

1 day

11-28-2009 09:08 EST

(No Feedback Yet)

I can provide you the desired result.

help

 

55

1 day

11-28-2009 09:51 EST

(No Feedback Yet)

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

help

 

50

1 day

11-28-2009 12:36 EST

(No Feedback Yet)

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

help

 

200

30 days

11-28-2009 13:05 EST

(No Feedback Yet)

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

help

 

100

0 days

11-28-2009 13:14 EST

(No Feedback Yet)

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

help

 

100

0 days

11-28-2009 13:13 EST

(No Feedback Yet)

Hi, I can do it in 3 hours

help

 

30

1 day

11-28-2009 13:51 EST

(No Feedback Yet)

I can do it in one hour.

help

 

50

1 day

11-28-2009 19:28 EST

(No Feedback Yet)

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.

help

 

30

1 day

11-29-2009 00:11 EST

(No Feedback Yet)

we can make it easily

help


    Bid on this Project