Code Accounting for depreciation of vehicles for MOT an

Affiliates: 0,1 $how to earn
Pay with:
i agree with "Terms for Customers"
Buy this item cheaper:
Sold: 3 last one 30.03.2016
Refunds: 0

Uploaded: 22.09.2014
Content: text 474 symbols

Product description

Code Accounting for depreciation of vehicles for MOT an

The code for the database, "Accounting for depreciation of vehicles and groups of vehicles MOL" in MS Access

Download the report on the database screen forms for free

Title: Accounting depreciation of vehicles for MOT and groups avtotransporta.mdb


Additional information

Ready-made Access database "Accounting for motor vehicle depreciation by MOL and 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

Table structure: State number, Vehicle type, Group code, Initial value, Commissioning date, Beginning of the year, Personnel number (15 cars total)

Table 4. Monthly runs

Table structure: State number, Mileage, Name of month

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 - information on 15 cars belonging to five groups and three MOL. When entering data in Table 3, use the combo boxes to enter the MOL number and the car group code.
Create a compound form "Runs for the month", type main / subordinate to fill in the data in Table 4. To provide output to the main form of complete information about the assigned vehicle. 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.
Create a form for transferring the car from one materially responsible person to another. To select the materially responsible persons use the fields with a list.
Create a query to search for cars with zero residual value.
Create a report "Information on depreciation charges for the month by vehicle groups and MOT per month" on the basis of a cross request. The report lines must correspond to MOL, and the columns to the groups of cars. The name of the month is to be entered upon request.


No feedback yet.
In order to counter copyright infringement and property rights, we ask you to immediately inform us at 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.)