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