Reliability & Maintenance Analyst - Database Connection

Techniques

Cumulative Distribution Function

Cumulative Hazard Function

Weibull Distribution

Normal Distribution

Lognormal Distribution

Exponential Distribution

Exam

Engineered Software Home Page

To connect to a Microsoft Access database, select "File" then "Connect to Database" from the menu, and select the database from the file dialog box.   This will produce the following screen if the demo.mdb database is selected.

All the tables included in the database will be listed in the "Select Table" box.  In the example above, there is only one table in the database.  It is titled "Sample Table".  Click the desired table, and all fields in the table will be listed in the boxes

• Select Time to Fail Field - this field contains the time to fail or the time accumulated without failure
• Select Quantity Field - this field contains the quantity of units; usually 1 for failures, or more than one for censored items
• Select Censoring Field - the character placed in this field will be used to determine if an item failed or was censored.  In the example above, any items with a   "0" in this field will be treated as failed, all others will be treated as censored.  Note: Any null records are treated as failures.