| 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.
|
|
| |
|
|
|
![[ BSL BaRaN Systems LLC Home Page ]](../../../../../images/bsl_home.gif){kind=small}
