Accounting for fixed assets by groups Access Equipment

Affiliates: 0,6 $how to earn
Pay with:
i agree with "Terms for Customers"
Sold: 2 last one 22.05.2018
Refunds: 0

Uploaded: 07.06.2014
Content: 162,41 kB

Delivery Guaranteed

If you are unhappy with a product you purchased, the seller will return your money within 7 days from the moment of purchase.


Accounting for fixed assets by groups Access Equipment

The program is designed for this task:
Create a table:
Table 1. Asset Group
Code group Name of the group, the annual rate of depreciation (depreciation rate specified in% of the original value)
Table 2. Division
Structure of the table: code division, division name, name of the person in charge of the material (abbreviated MOT)
Table 3. Fixed Assets
Table Structure: Part Number, Name, Code group, cost, date of commissioning, code division
2. Enter in the table 1 data on five groups
3. Create a form of "scorecard" to enter the data in Table 3. Use the combo box to enter the department code and group code. Enter 15 units of account.
4. Create a form (such as main / sub) "Information about the depreciation charge for the group of fixed assets in the past month" to view information for each group. The main form must contain the code of the group, group name, number of the month and the total amount of depreciation for the month subform - tabular list of fixed assets within the group and the amount of depreciation in the past month for each unit of accounting.
5. Provide input code and group number of the month on request. If the depreciation period has not expired (expiration date exceeds the depreciation of the months), the amount of depreciation for the month is calculated by the formula: A = S * N / (12 * 100), where S-initial cost, N-annual depreciation rate in% . Otherwise, the amount of depreciation for the month equal to 0. Deadline depreciation calculated by the formula:
Date of commissioning + 365 * 100 / N
6. Create a request to search for assets with zero residual value.

Additional information

The database in Access 2007. Converted to any other.
Computer science, management, information technology, management, economics.


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