The code to the database Accounting for the needs of

Affiliates: 0,1 $how to earn
Pay with:
i agree with "Terms for Customers"
Buy this item cheaper:
Sold: 13 last one 15.09.2017
Refunds: 0

Uploaded: 04.05.2014
Content: text 428 symbols

Product description

The code to the database Accounting for the needs of

for the base code data "Consideration needs to release the details of the plan" in MS Access.

Download the report on the database screen forms free http://access.avorut.ru/080413/160_otchjot_uchet_potrebnosti_v_detaljakh.doc

Title: Accounting requirements in detail on the plan vypuska.mdb

Link: http://access.avorut.ru/load/0-0-0-160-20

Additional information

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.

Feedback

0
No feedback yet.
In order to counter copyright infringement and property rights, we ask you to immediately inform us at support@plati.market the fact of such violations and to provide us with reliable information confirming your copyrights or rights of ownership. Email must contain your contact information (name, phone number, etc.)