Code for DB wage calculation on piece outfits .mdb

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

Uploaded: 04.05.2014
Content: text (413 symbols)

Description

Code for DB wage calculation on piece outfits .mdb

for the base code data "Calculation of wages on piece outfits" in MS Access.

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

Title: Calculation of wages for piece-naryadam.mdb

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

Additional information

Ready-made database access Calculation of pay for piece-work dresses
Option 7. Calculation of pay for piece-work dresses
1.
Create tables:

Table 1. List of prices

Table structure: Job code, Job title, Price (RUB per unit)

Table 2. Brigade Handbook

Table structure: Brigade code, Personnel number, Surname I.O.

Table 3. Apparel

Table structure: Outfit number, Brigade code, Personnel number, Job code, Executed volume (in units of measure), KTU (the labor participation coefficient can have values ​​from 0 to 1)

2.
Enter information in Table 1 on the five works, in Table 2 - data on 10 workers from the three brigades.
3.
Create the "Order" form to enter data in Table 3, providing for the control of the input data (the volume executed, the brigade code) and the issuing of messages when input errors occur. Enter data for three orders, with one outfit should contain data for one team and each worker can perform only one job. Within a month, several outfits can be issued for one brigade. Entering the personnel number and code of work should be carried out using the list fields based on the reference tables.
4.
Create a form (such as master / slave) to obtain information about the performance of work of a given type by workers´ brigades. The value of the work code field must be selected from the combo box. The main form must contain the following fields: Job code, Job title, Price. The subordinate form should contain the columns: number of the brigade, number of the order, scope of work and cost of work.
5.
Create a request to create a table "Statement of charges of the team", which has the following structure: Personnel number, Surname IO, Scope of work, Pricing, Accrued by the piece, Accrued by the KTU. Calculation Accrued KTU execute according to the formula:

Accrued KTU = Prize for team * KTU worker /  KTU brigade

The brigade number and the size of its bonus must be entered when the query is executed.

6.
Create a report "Statement of Charges for the Brigade ... for the month." Brigade number must be entered on request. The statement must contain columns: No. p / p, Personnel number, Surname, Surname, Extradition, Signature. The statement must contain the final amount for issuance.

Feedback

1
No feedback yet.
Period
1 month 3 months 12 months
0 0 0
0 0 0
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.)