In Progress

Order system

Dear freelancers,

We would need an order system made in Microsoft Access to put in orders from clients.

Here's the information about our order system:

A client makes an order for a certain date and gets a order number.

The order numbers have to start from 1 every day. So for example when a client comes and orders for the 2nd of December he gets OrderID 1, when a next client comes and orders for the 4th of December he gets OrderID 1 too. We know that this might be not possible but maybe there is a way to do so, for example by letting the first two numbers be the day that the order will be picked up.

The client can order a couple of products.

Each product has a article number, category name, price and some have a couple of specifications (for example: fresh, cooked, opened).

The most important thing is the order form. We need to input all of these order details on a very efficient way.

The client needs to get the total price per product and the total price of the order.

Tricky thing is that for some products the calculation happens the normal way: price x quantity. Some products work with weight and have a price per kilograms. So there not the quanity but the weight has to be calculated in the total price of the product.

After an order has been placed a receipt needs to be printed for the client.

In the database we also need a report of what needs to be prepared for all orders on a certain day. So we need to be able to select the day and print all orders for that day. (OrderID, ClientName, ProductName, Quantity, ProductSpecification)

We also need a list per product category what needs to be prepared. (CategoryName, OrderId, ClientName, ProductName, OrderID).

We do require easy access to the tables so we could always add a product to the list.

We can deliver the full list of products, we also have a database already made, but only with the tables.

Skills: Microsoft Access

See more: freelancers by the day, access freelancers, work order system, access order, access 2013 form print, microsoft price list, access 2013 print report form, print form access 2013, product information article example, access information system, print 2013 access form, can report system database, receipt form access, need category system, access receipt database, microsoft access order database, total order, print receipt example, access database order system, access order system, access calculation, print order, order system access, client order database, access database print report

About the Employer:
( 5 reviews ) Oostende, Belgium

Project ID: #5070550

Awarded to:

florinserban

Hi, My name is Florin and i am a database applications developer. I've read the project description several times and came up with a simple and user friendly solution for your application that will do the following More

€130 EUR in 5 days
(12 Reviews)
4.2

31 freelancers are bidding on average €166 for this job

illuminesoft

We are amongst top 1% global outsourcing providers. We have successfully finished over 430 projects in last 13 years. PS : We have Diwali Festival Holidays between 02 Nov to 05 Nov 2013, staff will be back on 06 Nov More

€275 EUR in 7 days
(238 Reviews)
7.4
Prashantskin

Re.Buyer I have gone through your project requirements regarding the ordering system. I will develop the application in Microsoft Access. I will do it in time Please send existing tables for further discussion T More

€200 EUR in 3 days
(461 Reviews)
6.9
rhomeu

Hi, I am a MS Access expert and there's no doubt I can build the MS Access program that you wanted. I have done a lot MS Access projects as you can see it on my profile. I can definitely help you with your requ More

€222 EUR in 3 days
(49 Reviews)
6.7
branislavm

Hello, I am giving you a bid estimated by amount of work. I am interested in workflow at the moment - how your clients puts an orders? This part is missing - do they enter data into Microsoft Access database? Or More

€200 EUR in 3 days
(219 Reviews)
6.3
torajiv

It should be a simple task to design the db as you have described. Please download a sample file that assigns order numbers as you want in the dropboz link below: https://www.dropbox.com/sh/fgifj77mgkudmxy/xG5wz5uP More

€111 EUR in 5 days
(63 Reviews)
5.7
MarlinSoftware

Hi, I am a developer with over 23 years experience building complex database systems, specialising in the development of applications in MS Access using VBA and WinAPI. I could do this project to your specification wit More

€250 EUR in 5 days
(15 Reviews)
5.1
piyushdpatel

I have 8 yrs of Exp in VBA,VB6,VB.net and MsAccess. I have developed many applications in VB6,VBA,VB.NET. Ready to start Can You send me your Sample file / Project details if you want i will also send demo More

€150 EUR in 7 days
(8 Reviews)
4.7
winnet21

Hi, I have experience with this project, I send you a small example that I had programmed for customer you please download example here : https://hotfile.com/dl/243889748/ba45780/POS_NEW1212.zip.html you More

€200 EUR in 13 days
(11 Reviews)
4.8
expertcoder1vw

Hi, I'm an expert Access and database designer and developer and can develop a very user friendly, professional and robust software for your orders management and reporting. I will work with you to deliver this app More

€400 EUR in 7 days
(13 Reviews)
4.5
sinfulm3

Hello Sir, I'm a freelance MS Access developer and have developed several databases for small firms. I could develop this order database of yours. For the order number we could use incrementation for every date. For More

€160 EUR in 10 days
(12 Reviews)
4.0
farr4u

HI, Access VBA expert here, I can offer you very user friendly user forms to perform data operations like add/edit/delete etc, you can very well use the forms to generate order and print order receipt by selecting the More

€98 EUR in 6 days
(8 Reviews)
3.6
elboukharimu

Hi, I'm very interested helping you building your Oreder systemn with MS Access database, I have years of experience in SQL and database administration, modeling, and manipulating, please do not hesitate to check my po More

€189 EUR in 10 days
(3 Reviews)
3.4
ziafar

hello i am expert in MS ACCESS and VBA. I can help you with very good quality of work. Can you give me a liste of your tables and the format of your reports and forms ? Regards.

€250 EUR in 10 days
(2 Reviews)
3.2
SajjadHussain14

Hi, I can share a working demo based on your specific needs. If you get convinced with demo, we could move forward. Let me know if you are interested. Regards,

€166 EUR in 5 days
(2 Reviews)
3.2
web2printexpert

we have done similar task before. The proposal is preliminary. The final period and sum will be calculated after discussion. 1. We have big experience (since 2004) in MS Access, Visual Basic, VBA, Excel, Word, Visua More

€250 EUR in 5 days
(1 Review)
2.8
mail2vimalarora

Hi.. I have gone through your requirements of the project to create order system for your existing database. I have an experience of working on MS Access and created forms and reports as per requirement of client. S More

€166 EUR in 7 days
(4 Reviews)
2.6
expertatwork

Hey kimsidea, we are confident of doing this. Are you using WINDOWS ? If so, we can implement very good UI using Visual Studio in which the application will interact with underlying access databsse. Please reply and we More

€155 EUR in 8 days
(2 Reviews)
2.2
jawadaman

Hi there, I can develop this application for you. If interested in hiring me then please let me know so that I can send my queries to finalize requirements. Thanks. Regards, jawad

€100 EUR in 3 days
(2 Reviews)
1.6
alekseymihalych

Hallo I'd glad to help. I think we can do something to realize your idea with order id's. Some additional descriptions will be required. Regards,

€222 EUR in 15 days
(1 Review)
0.8
akins4lyfe

A proposal has not yet been provided

€34 EUR in 3 days
(0 Reviews)
0.0