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.
|
