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,