Code for downloading the file Reporting Comprehensive g

Ready Access database "Accounting for total annual income"

1.
Create tables:

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

2.
Enter in Table 1 information about 10 employees working in three departments, in Table 3 - information for the year.
3.
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.
4.
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.

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

6.
Create a report "Information on cumulative taxable income by department and month of work" (based on a cross-request).