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.
31 freelancers are bidding on average €166 for this job
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.
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,
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