Tip 3- How Set Database User Interface

 Description

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 1: Set the name of the company to ABC Company.

Objective 2: Set the database layers to the following convention.

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.