Design Database Prefer Access 2003 if capable

In Progress Posted Dec 4, 2011 Paid on delivery
In Progress Paid on delivery

I require a database preference is MS Access 2003 - This database needs to be able to monitor the following: Customer Orders - Current jobs - each employee hours on job/s - Freight (company used, Delivery Location, Dimentions, Quoted Cost, Actual Cost) - Pickups (Who, When) - Parts Used for jobs.

I need to have two jobsheet forms - one for new jobs and one for parts and repairs.

Database must have at least the following tables and fields-

Customer Table - : for both businesses and individuals - Company Name, 2 X Contact Names, 2 X Phone, 2 X Fax, 2 X Mobile, 2 X Email, Billing Address, Delivery Address, Notes.

Supplier Table - : Supplier Name, Type of Supplier, 2 X Contact Names, 2 X Phone 2 X Fax, 2 X Email, Account Number, Notes.

Freight Table -: Company used to deliver, Consignment Number, Date Booked, Date Picked Up, Goods Description, Breakdown of Dimentions - (Length - Width - Height -Weight) auto calculate cubic weight (LxWxHx250devided by4000), Quoted Cost, Actual Cost, Charge Cost To, Destination Address.

Employee Table -: First Name, Last Name, TAREDOWN HOURS, REFERBISH HOURS, REPAIR HOURS, INSTALL HOURS, WELDING HOURS, LABOUR HOURS TOTAL, Address, Phone, Mobile.

STOCK Table -: Supplier, Supplier Item Number, MYOB Item Number, Part Name, Part Description, Units in stock, Units out going, units on order, discontinued, recorder level, date ordered, date received, faulty, date returned.

Standard Product Table:- Board Size (A,B,C) Board Type (Plain, Double,) Board Action (Gas Strut, Power Lift, Lay Flat) Board Voltage (12v or 24v) Power Length, Data Length, Blue(Y/N) Orange(Y/N) Red(Y/N) Others(Y/N)

Additional Accessories - (all Y/N) - PCB Board, PCB Remote, Camera, light sensor, 12v LED, 24v LED, 4414G, 4415G, Beacon Plates, Beacon Kit, 199a, 390r, X's, Batteries, Batteries Kit, Reverse alarm, Ute Kit, S channel, M channel, L Channel, Work Lights, Specify(Detail) Additional Notes.

JOBSHEET/S TABLE - Type of job, quote sent Y/N, quoted to, quote number, date quoted, order confirmed Y/N, method of confirmation, job started Y/N, job number, date started, started by, job completed Y/N, date completed, invoice number, date of invoice, Bill To, Vehicle Description, Rego Number, Plant Number, Stock Number, VIN Number, Board Serial Number, Detail Of work (Standard Product Table & Additional Accessories Table), Delivery -Y/N, Delivery Via, Date Delivered, Pickup Y/N, Pickup By, Date Pickedup,

Database Administration

Project ID: #1325242

About the project

4 proposals Remote project Active Dec 15, 2011

Awarded to:

rmvale

You are looking for a 2003 Access database - I can produce this product quickly, based on over ten years experience designing databases in that software. I have over ten years experience analyzing the architecture o More

$95 AUD in 3 days
(0 Reviews)
0.0

4 freelancers are bidding on average $149 for this job

herykus

Hi, Thanks for posting. I am a programmer with more than 5 years of experience in this field. I have worked in many database software projects like this.

$100 AUD in 3 days
(0 Reviews)
0.0
samirshah2761986

Sir, Please check the PMB for more details...

$200 AUD in 10 days
(0 Reviews)
0.0
cainus

Hi! I am an experienced developer/analyst on different platforms and databases. I have done a similar program of your requirement. We can add more features aside from your basic requirements to make it more flexible on More

$200 AUD in 8 days
(0 Reviews)
0.0