Database "Calculation of time-based payment"
Option 1. Calculation of time-based payment
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.)
Enter in Table 1 information about 15 employees from three workshops, in Table 2 data for five digits.
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.
Create a request to add the calculated data to the fourth table for one month, the number of which must be entered on demand.
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.
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.
Create a report with totals for two months, showing the distribution of salary amounts in the context of the targets by categories.