The code to the database Accounting for the needs of

Database "Accounting for the need for detail on the release plan"

Option 8. Accounting for the need for detail on the release plan
1.
Create tables:

Table 1. Reference book

Table structure: Product code, Product name, Cost of assembly

Table 2. Reference book

Table structure: Part number, Part name, Price

Table 3. Production plan

Table structure: Product code, Number of products

Table 4. Structure of the product

Table structure: Product code, Part number, Number of parts in the product

2.
Enter in Table 1 information about five products, in Table 2 - data on the 10 parts used in the assembly of products, in Table 3 - data on the plan for the release of five products (the product code should be selected from the list box).
3.
Create a form "Structure of the product", type main / subordinate for viewing and entering data in table 4. Each product must contain at least three parts. The main form must contain the following fields: Product code, Product name. The subform must be tabular and contain lines with fields: Part number, Number of parts in the product. The value of the Part code field must be selected from the combo box.
4.
Create a form "The need for details on the production plan." The part code must be selected from the list. The form should have a tabular form and contain graphs: Product code, Product name, Number of products, The need for parts for the product release plan. In the form, the total need for the part must be calculated for the entire production plan.
5.
Create a final report "Release plan in value terms". The report should contain the following fields: Product code, Product name, Number of products, Cost of parts, Cost of assembly, Total cost. The report should contain the final cost of parts, assembly and all for the entire output plan.