- Cell Phones 2172
- Desktop 778
- Editors 282
- Education, Science & Engineering 1131
- Games 1780
- Internet 5050
- Multimedia & Graphics 918
- Office software 780
- PC 390
- Programming 1809
- 1C 112
- ActiveX 3
- Assembler 32
- C# 70
- C/С++ 275
- Data Bases 367
- Delphi/Pascal 489
- Disassemblers 5
- OpenGL/DirectX 5
- PHP 156
- Setup Software 37
- Visual Basic 27
- Others 231
- Security 785
- SEO 318
- Software for Pocket PC 208
- Utilities 972
Code for depreciation on vehicles gruppam.mdb
Refunds: 0
Uploaded: 22.09.2014
Content: text (425 symbols)
Description
Code for database "Accounting for depreciation of vehicles by groups" in MS Access.
Download the report on the database screen forms for free
access.avorut.ru/1/181_uchet_amortizacii_avtotransporta_po_gruppam_av.doc
Title: Accounting for depreciation on vehicles gruppam.mdb
Link: http://access.avorut.ru/load/0-0-0-181-20
Additional information
Ready-made Access database "Accounting for motor vehicle depreciation by vehicle groups"
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
Structure of the table: State number, Mileage for the month, Name of the month
2.
Enter in Table 1 information on 5 groups of cars (for example, dump trucks, cars, buses, etc.), in Table 2 - information on 5 MOL, in Table 3 - information about 15 cars belonging to 5 groups and 3 MOL. When entering data in Table 3, 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 (type master / subordinate) "Information on depreciation charges for a group of vehicles per month" to view the database for each group and containing in the table a list of group cars, their mileage, initial cost and depreciation amounts for a given month for each of them . The name of the month is to be entered upon request.
5.
Create a report "Summary statement of depreciation deductions from the beginning of the year" with the calculation of the amounts of depreciation, mileage and residual value at the beginning and end of the year for each car, by group and total. Information about each car to display in full.