Code to download file Calculation of time-based payment

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

Uploaded: 31.03.2014
Content: text 397 symbols

Description

Code to download file Calculation of time-based payment

for the base code data "Calculating time payment" in MS Access.

Download the report on the database screen forms free http://access.avorut.ru/080413/raschet_1/151_otchjot_raschet_povremennoj_oplaty.doc

Title: Calculation of time-based oplaty.mdb

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

Additional information

Database "Calculation of time-based payment"

Option 1. Calculation of time-based payment
1.
Create tables:

Table 1. Directory of workers

Structure of the table: Personnel number, Surname IO, Rank, Workshop

Table 2. Directory of tariffs

Table structure: Rank, Tariff (rub / hour)

Table 3. Time sheet

Table structure: Personnel number, Time worked in hours, Month number

Table 4. Statement of Payroll

Structure of the table: Month, Workshop, Personnel number. Surname IO, Time worked, Rate, Accrued (rub.)

2.
Enter in Table 1 information about 15 employees from three workshops, in Table 2 data for five digits.
3.
Create a form "Table" for entering data in Table 3, providing for the control of input data (time worked) and issuing messages when input errors occur. To enter the personnel number, use the combo box containing the personnel numbers and surnames corresponding to Table 1. Enter the data for 15 workers for one month.
4.
Create a request to add the calculated data to the fourth table for one month, the number of which must be entered on demand.
5.
Create a form (type master / slave) only to view information about one worker. The main form should contain: Personnel number, Surname IO, Rank, Workshop, Tariff. The subordinate form must have three columns (the number of the month, the worked time, the accrued amount) and the number of lines corresponding to the worked-out months.
6.
Create a report "Payment statement for shop N ... per month ..." with the total of the field accrued. The workshop and month number must be entered on request. The payroll should contain the following columns: Number in order, Personnel number, Surname of the Acting Name, Amount to be issued, Signature.
7.
Create a report with totals for two months, showing the distribution of salary amounts in the context of the targets by categories.

Feedback

0
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.)