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.