MS Access Relational Database Required

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.