- Cell Phones 1589
- Desktop 760
- Editors 441
- Education, Science & Engineering 1107
- Games 2667
- Internet 4619
- Multimedia & Graphics 1018
- Office software 761
- PC 478
- Programming 1898
- 1C 145
- ActiveX 3
- Assembler 30
- C# 88
- C/С++ 281
- Data Bases 424
- Delphi/Pascal 493
- Disassemblers 6
- OpenGL/DirectX 5
- PHP 154
- Setup Software 22
- Visual Basic 25
- Others 222
- Security 962
- SEO 306
- Software for Pocket PC 187
- Utilities 3932
Code for downloading the file Reporting Comprehensive g
Refunds: 0
Uploaded: 18.09.2014
Content: text 401 symbols
Product description
Code for database "Accounting aggregate annual income" in MS Access.
Download the report on the database screen forms free http://access.avorut.ru/1/174_uchjot_sovokupnogo_godovogo_dokhoda.doc
Title: Accounting for the total annual dohoda.mdb
Link: http://access.avorut.ru/load/0-0-0-174-20
Additional information
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).