- Cell Phones 1585
- Desktop 759
- Editors 430
- Education, Science & Engineering 1094
- Games 2253
- Internet 4712
- Multimedia & Graphics 994
- Office software 759
- PC 457
- Programming 1897
- 1C 145
- ActiveX 3
- Assembler 30
- C# 88
- C/С++ 281
- Data Bases 418
- Delphi/Pascal 494
- Disassemblers 6
- OpenGL/DirectX 5
- PHP 157
- Setup Software 22
- Visual Basic 25
- Others 223
- Security 991
- SEO 302
- Software for Pocket PC 187
- Utilities 3879
Code for accounting depreciation of vehicles for person
Refunds: 0
Uploaded: 22.09.2014
Content: text 480 symbols
Product description
The code for the database, "Accounting for depreciation of vehicles on the material responsible persons" in MS Access
Download the report on the database screen forms for free
http://access.avorut.ru/1/182_uchet_amortizacii_avtotransporta_po_materialno.doc
Title: Accounting vehicle depreciation materially responsible litsam.mdb
Link: http://access.avorut.ru/load/0-0-0-182-20
Additional information
Ready-made Access database "Accounting for Vehicle Depreciation for Material Responsible Persons (MOL)"
1. Create tables:
Table 1. Group of cars
Table structure: Group code, Group name, Depreciation rate (the depreciation rate is set in% of the original cost per 100 km run and can have values from 0.01% to 0.05%).
Table 2. Financially Responsible Persons (MOL)
Table structure: Personnel number, Name
Table 3. Automobiles
Structure of the table: State number, Vehicle type, Group code, Initial value, Commissioning date, Beginning of the year, Personnel number
Table 4. Monthly runs
Table structure: State number, Mileage, Name of month
2.
Enter in table 1 information on five groups of vehicles (for example, dump trucks, cars, buses, etc.), in table 2 - information on five MOL, in Table 3 - enter information about 15 cars belonging to five groups and three MOL. Use the combo boxes to enter the MOL number and the car group code.
3.
Create a form (type master / slave) "Runs per month" to fill in the data in Table 4. To provide output to the main form of complete information about the given car. The choice of the state number of the car should be carried out from the combo box. The subordinate form must have a tabular form and contain two fields: the name of the month and the mileage for the month. Enter the name of the month by choosing a value from the list.
4.
Create a form (such as the master / slave) "Information on depreciation charges for the financially responsible person for the month" for viewing the database for each MOL and containing in the table the list of cars assigned to MOL, their mileage, initial cost and depreciation amounts for the given month . Choose the month from the list.
5.
Create a report "Summary statement of depreciation charges for MOL from the beginning of the year" with the calculation of the amount of depreciation, mileage and residual value at the beginning of the year and at the end of the month for each vehicle, MOL and everything.