The SQC for Access data base is designed as a
relationship database. Suppose you have a company (Back-End
Data Base) that has three plants
- North Plant
- South Plant
- New E Plant
Each plant has two set of
equipments that produce a Widget, the
production line merges to a packaging equipment
section to produce the final product. Therefore the
equipments are:
- Widget Builder A
- Widget Builder B
- Packaging
In each equipment, a set of measurement is taken for different
properties of the Widgets. These measurements
are:
- Height
- Weight
- Moisture
- Defect (only for the packaging)
For each measurements, a set
of data (sub-groups) are taken and entered into the database.
and the SQC charts can be generated
1- Start the SQC for Access
program
Start 
All ProgramsSQC for
Access SFA_Main_V2002_V150.MDE
Start All ProgramsMicrosoft
Access Open
Program Files
BaRaN Systems LLC
SQC for Access 2002
SFA_Main_2002_V150.MDE
2- Click the [1] Plant button.
Note: The other 2 plants can be access from the navigation buttons.
3- Click the [2] Equipment button.
Note 1: The other equipments
can be access from the navigation button
Note 2: The other plants
can be access from the pull down menu
5- Click the [3] Measurement button.
Note 1: You can select different Equipment from the pull
down menu
Note 2: Double click on the
measurement will get to the correct
Data.
6- Click the Data button.
Note 1: In this example, the Height
and Width measurement
has a sub-group size of 3 and the moisture sub-group size is 1.
Note 2: The Height
measurement has 299 sub-groups of data. Each
sub-group can be access from the navigation bar.
Note 3: The Plant,
Equipment and
Measurement can be selected from
7- Click the Analyze button.
Note 1: The Plant, Equipment and Measurement can be
selected from the pull down menu.
Note 2: The type of SQC charts can be selected from
Note 3: The SQC charts can displayed in the following
format (Please select MS Excel file)
8- Click the Generate Report button.
The program will generate a MS Excel file to be stored in
C:\SQC_for_Acess
Click the SAVE button
9- Review the results.
|
Purchase