Closed

Access database

This project received 51 bids from talented freelancers with an average bid price of £161 GBP.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
£20 - £250 GBP
Total Bids
51
Project Description

Menus and forms for access database so it can be used easily.

Stock Items:
Add machine make, models
Add an order - date, select make and model from drop-downs and complete form with serial number and cost. Set Status to 1 (on order)
Amend order: we need to be able to change the Status, as there are 7 different states, on order, available, demo, loan, hire, sale agreed and awaiting payment. A status of 0 means paid / finished.
Amend order: input Location (free type)
Amend order: input supplier invoice number

Customers:
Add customer names

Suppliers:
Add supplier names

Reports:
Machines are bought from 4 main suppliers so we need a report for either each 1 individually or all together. So under the Supplier name it will show:

Order date, invoice number, Make - model, Status, Serial number, Assigned to, Value

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