Closed

database design -- 2

We have a retail spare parts business operating in country Australia with 8 employees. A few years ago I designed a database (in Access)to handle our customer orders. The sales staff take orders from the phone or counter and input into Access. From there the data is converted to manually written orders to be sent to our suppliers. When the order arrives another clerk interrogates the information and allocates the parts to the customers. I am looking for software that will basically perform the same role as our current system and additionally allow us to create supplier orders from the customer order data. One customer could place an order which has to come from multiple suppliers. We have no need for any stock control, invoicing or cost control for any items. We require an easy toggle or buttons to show closed and open orders. Need to be able to easily add additional suppliers, customers and part numbers on the fly. Quite a few more requirements, but that is the basis of what we would like. I have attached a couple of screenshots of our current system which works quite well but is a little limited. Not bothered about software base used. I look forward to responses. Craig Scott

Skills: Microsoft Access, Database Programming, MySQL, PHP, SQL

See more: database design template small business, database design country state, country state city zip database design, country statecity database design, country state city database design, retail management database design, database design retail store, retail database design, database design retail management store, database design project retail, business search site database design, design logo for a shop with deals with the sales of pepper, database design for accounting and business applications, database design for accounting and business application, database design for retail

About the Employer:
( 0 reviews ) charleville, Australia

Project ID: #30924192

81 freelancers are bidding on average $35/hour for this job

(218 Reviews)
9.4
(217 Reviews)
9.1
(842 Reviews)
9.2
(293 Reviews)
9.3
(492 Reviews)
8.8
toseef3

Respected Employer ! I am a full stack developer with expertise in both backend and frontend, I would like to start this work asap. As I'm focused and committed to provide excellent clean backend code with excellent f More

$38 AUD / hour
(69 Reviews)
8.0
(269 Reviews)
7.7
(360 Reviews)
7.9
tangramua

Hello Craig S.,   We have 20 years of strong experience in PHP, SQL, Microsoft Access, MySQL, Database Programming, as a result, we can successfully complete this project.   Please, review our profile here: https://www More

$25 AUD / hour
(162 Reviews)
8.2
(202 Reviews)
7.5
(201 Reviews)
7.6
(176 Reviews)
7.5
(75 Reviews)
7.5
(45 Reviews)
7.5
(209 Reviews)
7.6
(81 Reviews)
7.2
(129 Reviews)
7.3
(126 Reviews)
7.2
(42 Reviews)
6.9
(31 Reviews)
7.0