Đã hoàn thành

Access Database for Transport Routes

We are a business that requires a MS Access Database for our transport department.

At present we are use excel to print off route sheets. We have over 200 customers and about 30 routes 7 days a week. Excel is very impractical, a few examples are below:

-to query what route a customer is on and what days they are getting a delivery its very time consuming as each spread sheet has to be searched

-to change a customer to a different route or delivery day

-to run a report using zip codes/days/route number to make sure route drops are in order

-list all customers to make sure all inactive ones are not on the route sheets.

-to add a new customer is time consuming

We would like a MS Access data base to do the following:

[url removed, login to view] a entry form for new/existing customers with all their details, with this form we can select the delivery days of the week (Mon-Sun) and the route number it is to go on each day (route may change daily)

[url removed, login to view] this has been entered this information should then be able to create route sheets similar to the ones they are using now so we can print them off daily.(we require the drivers to write in information on route sheets)

[url removed, login to view] that we may require are a list of customers that are getting certain amount of deliveries per week. what route and days a customer is allocated on.

We can go into more details when we start - Thanks

Please see the attached excel run sheet. I am hoping this is the format that will be printed from MS Access when the project is completed.

Kĩ năng: Microsoft Access

Xem nhiều hơn: access transport, transport database excel, what is a data entry form in a database, what business to start using excel, we transport, ms access form data entry, ms access data entry form examples, ms access data entry form, microsoft excel spread sheet, microsoft access data entry form, make a spread sheet, excel sheet for customer details, excel data entry form examples, drivers select, delivery drivers, daily access, create excel form for data entry, create data entry form access, access database data entry form, what is ms access, customer database in excel, transport business, MS Access Database, ms access 2013, microsoft access for business

Về Bên Thuê:
( 28 nhận xét ) Darra, Australia

ID dự án: #4549460

Được trao cho:


Hi - I can do this for you. I can talk you through my proposal. regards Prem

$155 AUD trong 3 ngày
(145 Đánh Giá)

15 freelancer đang chào giá trung bình $212 cho công việc này


[url removed, login to view] I have gone through your project requirements. I will develop the transport routes and related system in access. I have already done such a project partially for an oil / tanker company Please see PMB for Thêm

$333 AUD trong 3 ngày
(477 Nhận xét)

Hi, I have 12 years experience developing MS Access applications and could do this project for you within a short time frame. Please view my portfolio for some examples of my work.

$300 AUD trong 5 ngày
(23 Nhận xét)

Hi. I'm Emmanuel Ovabor and I'm vast and highly proficient in MS Access. I read your project description and understand that you need an Access Database program to manage transport route which you presently manage in Thêm

$155 AUD trong 7 ngày
(36 Nhận xét)

Let me help you in [url removed, login to view] start.

$188 AUD trong 5 ngày
(11 Nhận xét)

Placing bid for the requirements mentioned in the description. As we go into details, the budget may increase.

$236 AUD trong 7 ngày
(15 Nhận xét)

Hi I am interested and I can help you in building the access database. I will create more reports what ever you required. Thanks

$231 AUD trong 7 ngày
(17 Nhận xét)

I have more than nine years experience in database development and administration. Let me know details. thanks.

$277 AUD trong 15 ngày
(1 Nhận xét)

Hi. I am database developer with significant experience in MS Access. Appreciate very detailed description you provided for the project. Please, feel free to take a look at my previous projects and reviews regarding MS Thêm

$144 AUD trong 7 ngày
(2 Nhận xét)

Hello, please see PM

$133 AUD trong 5 ngày
(1 Nhận xét)

Dear dgeorge010, SQL,Oracle,DB2 MS access professional here. Thank you.

$189 AUD trong 5 ngày
(0 Nhận xét)

Hi, I have 3 yrs exp in SQL, Java, access, Datawarehousing. I can help you out. Please check your PM

$122 AUD trong 3 ngày
(0 Nhận xét)

Please check pm for details.

$277 AUD trong 5 ngày
(0 Nhận xét)

Hi, Expert in Microsoft Excel & Report Generation. See Private Message for more details. Regards, Ashish

$330 AUD trong 7 ngày
(0 Nhận xét)

I can start this work immediately

$111 AUD trong 3 ngày
(0 Nhận xét)