Case B - How Set Database User Interface

Step  Description Introduction The SQC for Access utilizes the MS Access as its engine. A generic relational database have been developed as a Quality Database. A relational database is a collection of data items organized as a set of formally-described tables from which data can be accessed or reassembled in many different ways without having to reorganize the database tables. In addition to being relatively easy to create and access, a relational database has the important advantage of being easy to extend. After the original database creation, a new data category can be added without requiring that all existing applications be modified. A relational database is a set of tables containing data fitted into predefined categories. Each table contains one or more data categories in columns. Each row contains a unique instance of data for the categories defined by the columns.  The tables can be connected together in a relation to reduce the amount of data entered. The SQC for Access 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 1: Set the name of the company to ABC Company. Objective 2: Set the database layers to the following convention. Level Default Name New Name  A  Plant  Factory  B  Equipment  Product  C  Measurement  Measurement    Batch ID  Production Order           Objective 3: 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.   2 Click the Setup button change the Back-End database to the Test Database. 3 Set the data base with all  Administer Privileges (Shown in Advanced Tip 2) 4    Click Setup and then Setup again. Change the Company field to ABC Company in the 2nd record. Click .   5 Click the Home button and click Refresh button.   Click the Data button and select the Factory: FB Production: P2 Measurement: W review the data.