Find Jobs
Hire Freelancers

MS Access Relational Database Required

$30-5000 USD

Cancelado
Publicado há aproximadamente 15 anos

$30-5000 USD

Pago na entrega
We need a database application designed in MS Access to record and track jobs that come in for repair and calibration. **Please read this entire bid request before placing a bid** and answer the questions included if you want us to take your bid seriously. Currently we are using 2 different Excel spreadsheets to record this information but we need a single relational database that is simple to use with a front-end for data-entry by our staff. **We can supply a copy of the main spreadsheet to help you develop the application.** Below is a sample of the tables and fields that MAY be needed. However, it is up to you to work out the best number of tables and fields required and the relationship between each. We are open to suggestions for improvements to this project and welcome your input. ## Deliverables This is a repeat of the full project description, because we could not fit the full description in the fields above: We need a database application designed in MS Access to record and track jobs that come in for repair and calibration. **Please read this entire bid request before placing a bid** and answer the questions included if you want us to take your bid seriously. Currently we are using 2 different Excel spreadsheets to record this information but we need a single relational database that is simple to use with a front-end for data-entry by our staff. **We can supply a copy of the main spreadsheet to help you develop the application.** Below is a sample of the tables and fields that MAY be needed. However, it is up to you to work out the best number of tables and fields required and the relationship between each. We are open to suggestions for improvements to this project and welcome your input. **The application should be able to track or record the following: **1.? Job Tracking / Receipt and Despatch information 2.? Customer Contact Details 3.? Calibration Details and Results 4.? Instrument Details (Model, Description, manufacturer) 5.? Type of certificate issued Below is a list of the fields we are currently using in our 2 Excel Spreadsheets (we have broken them up into groups for your convenience). Naming of fields and tables will be up to you. **Sample of fields needed to record Job Tracking** * Date the Job arrives to our premises * Allocate a job number to each job as it arrives (one job may have several items) * Customer Name (From Customer table) * Date Sent Out * Courier name (Own table) * Consignment Note number * Consignment note color * Invoice Number **Sample of fields needed to record Calibration Details** * Issue Date of Calibration * Date of Calibration (can be different to “Issue date of Calibration??, but usually the same) * Certificate Number * Job number (from Job Tracking Table) * Owner Name (from Customer table) * Invoiced to: (may be different to “Owner Name?? but usually the same) * Manufacturer Name * Model Number * Serial Number of Instrument * Description of Instrument (automatically pulled when “model number?? is entered) * Due Date (Usually 12 month or 24 months after Issue Date) * dB reading (may at time have 2 readings e.g. 94.09 & 113.83) (Field not always used) * Hz reading (e.g 1001.5) (Field not always used) * Ambient Pressure ( e.g. 1013) * Humidity (e.g. 49) * Microphone Type (e.g. 40AN) (Field not always used) * Microphone Serial Number (e.g. DCE070001) (Field not always used) * Filter Type (e.g. 1/1 Octave)? (Field not always used) * Filter Serial Number: (e.g. 2505903) (Field not always used) * Type: (Usually “1?? or “2??) **Sample of fields needed to record Customer Details** * Street Address of Owner (for sending reminders) * Suburb * State * Post Code * (Contact Name) * (Telephone Number) * (email address) **Sample of Fields needed to record Instrument Details** * Model Number * Manufacturer Name * Model Number * Description **PRINTOUTS/REPORTS** The application should be able to produce a number of printouts including but not limited to the following: 1.? We need to be able to print monthly reminders letters for clients to notify them that their instruments are soon due for recalibration. These will be sent by mail and or email. These reminders will be sent out at the beginning of each month and should include some basic reminder text along with a list of the instruments due for calibration, including the manufacturer, Model, serial number and due date. We can provide a sample document to the successful coder. 2.? Certificates of Calibration for each instrument that has been calibrated. There are approximately 15 different certificates to choose from. Each certificate only has minor variations from the next certificate. We can supply sample WORD documents for each certificate to the successful coder. 3.? Print a summary sheet of instruments calibrated within a certain period. 4.? Print a summary sheet of instruments calibrated from x certificate number to x certificate number. **SEARCH FEATURES** The application should be able to do a variety of searches for records that meet certain criteria. This can be worked out later. But will include search by model number, search by serial number, search by owner, search by certificate number, search by date, search by job number, search by due date etc. The above specifications not set in concrete but are open to adjustments and improvements as the project progresses. We (our administrator) must be able to access the back end of the database and make adjustments and changes as needed. In other words the front-end should be locked to prevent accidental changes to key data by unauthorised staff. Users should preferably be able to add/modify fields when necessary. **BONUS** A Bonus will be provided to the successful coder, if he/she can export some of these records/details (easily) into our “Quickbooks?? accounting System. Details can be worked out later. But **please indicate if you are able to accomplish this extra feature in your bid**. We will let you know the Quickbooks version we are using (it is an older version) at a later stage. In your bid please give examples of similar database projects you have completed in the past.
ID do Projeto: 3522452

Sobre o projeto

59 propostas
Projeto remoto
Ativo há 15 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
59 freelancers estão ofertando em média $605 USD for esse trabalho
Avatar do Usuário
See private message.
$667,25 USD em 21 dias
4,9 (361 avaliações)
7,7
7,7
Avatar do Usuário
See private message.
$467,50 USD em 21 dias
5,0 (731 avaliações)
7,5
7,5
Avatar do Usuário
See private message.
$255 USD em 21 dias
5,0 (522 avaliações)
7,1
7,1
Avatar do Usuário
See private message.
$552,50 USD em 21 dias
5,0 (91 avaliações)
5,9
5,9
Avatar do Usuário
See private message.
$340 USD em 21 dias
5,0 (16 avaliações)
5,9
5,9
Avatar do Usuário
See private message.
$170 USD em 21 dias
4,7 (111 avaliações)
5,9
5,9
Avatar do Usuário
See private message.
$425 USD em 21 dias
5,0 (23 avaliações)
5,8
5,8
Avatar do Usuário
See private message.
$170 USD em 21 dias
5,0 (38 avaliações)
5,8
5,8
Avatar do Usuário
See private message.
$425 USD em 21 dias
4,8 (117 avaliações)
5,6
5,6
Avatar do Usuário
See private message.
$97,75 USD em 21 dias
5,0 (94 avaliações)
5,6
5,6
Avatar do Usuário
See private message.
$680 USD em 21 dias
5,0 (6 avaliações)
5,4
5,4
Avatar do Usuário
See private message.
$212,50 USD em 21 dias
3,7 (28 avaliações)
5,4
5,4
Avatar do Usuário
See private message.
$595 USD em 21 dias
4,3 (26 avaliações)
5,3
5,3
Avatar do Usuário
See private message.
$476 USD em 21 dias
4,7 (19 avaliações)
5,0
5,0
Avatar do Usuário
See private message.
$25,50 USD em 21 dias
5,0 (16 avaliações)
4,4
4,4
Avatar do Usuário
See private message.
$106,25 USD em 21 dias
4,9 (19 avaliações)
4,2
4,2
Avatar do Usuário
See private message.
$212,50 USD em 21 dias
4,3 (8 avaliações)
4,2
4,2
Avatar do Usuário
See private message.
$3.825 USD em 21 dias
5,0 (20 avaliações)
3,9
3,9
Avatar do Usuário
See private message.
$2.125 USD em 21 dias
5,0 (8 avaliações)
3,7
3,7
Avatar do Usuário
See private message.
$301,75 USD em 21 dias
5,0 (1 avaliação)
3,6
3,6

Sobre o cliente

Bandeira do(a) AUSTRALIA
Drummoyne, Australia
5,0
29
Membro desde abr. 20, 2004

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos 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)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.