Ready Access database "Accounting for total annual income"
Table 1. Directory of workers
Table structure: Personnel number, Surname, Address, Passport series, Passport number, Salary, Number of children, Department
Table 2. Journal of Payroll
Structure of the table: Name of the month, Personnel number, Time worked (in days), Accrued, Withdrawn P / N (income tax)
Table 3. Working days reference book
Table structure: Name of month, Planned number of working days
Enter in Table 1 information about 10 employees working in three departments, in Table 3 - information for the year.
Create the "Time worked" form for entering in Table 2. Use the combo box to enter the personnel number and the month name. You must control the input of the field value Time worked (in days) in accordance with the number of days of the month being processed. Enter information about the time worked by all employees for the first three months of the year.
Create a request for changing the records of the table 2. The value of the field is calculated according to the formula:
Accrued = (Salary / Planned number of working days) * Working time
The value of the field is kept P / H counted by the formula:
Withheld MON = (Total accrued - Standard deduction for employee - Standard deduction for 1 child * Number of children) * 0.13
The number of the calculation month and the value of the standard deductions are entered when the query is executed.
Create the form "Reference on the total annual income of the worker from the beginning of the year" (type main / subordinate) to view information about the employee whose surname should be selected from the list box. The main form should contain all the fields of table 1. The subordinate form must contain the columns: the name of the month, the monthly income (the accrued amount in the corresponding month). In the lower part of the main form, the total amount for three months, subject to tax:
(Accrued - Standard deduction for employee - Standard deduction for 1 child * Number of children).
Create a report "Information on cumulative taxable income by department and month of work" (based on a cross-request).
In order to counter copyright infringement and property rights, we ask you to immediately inform us at firstname.lastname@example.org 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.)