Completed

Order system

This project was successfully completed by florinserban for €130 EUR in 5 days.

Get free quotes for a project like this
Employer working
Completed by:
Skills Required
Project Budget
€30 - €250 EUR
Completed In
5 days
Total Bids
32
Project Description

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.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online