Find Jobs
Hire Freelancers

Design Database Prefer Access 2003 if capable

$30-250 AUD

En curso
Publicado hace más de 12 años

$30-250 AUD

Pagado a la entrega
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,
ID del proyecto: 1325242

Información sobre el proyecto

4 propuestas
Proyecto remoto
Activo hace 12 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 of data sets - the output can be in spreadsheets as requested. My software of choice is Excel but I can adapt to others. I can also design it so that it can be imported into a database (MS Access) with ease, to take advantage of the improved error control in that mode. I have completed more than ten projects of this type for satisfied customers, some more complex than others. Data in these projects were customer lists, ordering systems, document inventory with authority sign-off tracking and project gating compliance tracking. I can produce full function forms as well as printable reports based on your specifications.
$95 AUD en 3 días
0,0 (0 comentarios)
0,0
0,0
4 freelancers están ofertando un promedio de $149 AUD por este trabajo
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Sir, Please check the PMB for more details...
$200 AUD en 10 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 your part. Let me know if you're interested so we could start it as soon as possible. Thanks
$200 AUD en 8 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de AUSTRALIA
Brendale, Australia
0,0
0
Miembro desde dic 5, 2011

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.