Case D - How Set Database
Levels
|
|
Step |
Description |
|
Introduction |
The SQC for Access utilizes the
layered (relational) database as defined
previously. The database is divided into 4
layers. Plant, Equipment, Measurement
and Data. These are generic names and
can be re-assigned by the user to a more
logical name. |
|
Objective |
The
objective of this section is to provide step
by step instruction of how to set following
objectives in the database with
Administer Privileges.
Objective: Suppose that you
have 4 factories, lets call them FA, FB, FC
and FD. Each has 3 product lines P1, P2, P3.
The all produce products that we can measure
length and width but not all
products are made in all of the factories.
The number of defects, length
and width are measured every 2
minutes.
|
Factory |
Product |
Measurement |
|
FA |
P1 |
Length, Width, number of defects |
|
FA |
P2 |
Length, number of defects |
|
FB |
P1 |
Length, number of defects |
|
FB |
P2 |
Length, Width |
|
FC |
P1 |
Length, Width, number of defects |
|
FD |
P1 |
Length |
|
FD |
P3 |
Length |
|
|
Steps to do |
Do
the following to set the SQC for Access™
with Administer privilege.
|
Step |
Description |
|
1 |
|
Start SQC
for Access™ program with
Admin Privileges.
Note that all
of the buttons are
accessible and you are
connected to the TEST
back-end database.
|
|
|
2 |
Click the
Factory button enter the
correct data
Click the
next button to add the next record. |
|
3 |
Once you enter
all records, please review them in
the table format.
A- Click the
right mouse on the header and select
the Datasheet View
C- Once
finished review, click the right
mouse on the header and select the
Form View option.
D- Click the Home button.
|
|
4
|
A- Click
the Production Button, Make
sure you select all records and then
check information for all production
lines.
|
| 5 |
In the
Factory page, add the following
Make sure you do not select the
Status. |
| 6 |
In the
Production page, if you select the
Factory pull down menu, this option
is not shown.
|
|
| |
|
|
|
|
