Ready database Access "Accounting of fixed assets by equipment groups"
1. Create tables:
Table 1. Group of fixed assets
Table structure: Group code, Group name, Annual depreciation rate (depreciation rate is set in% of the original cost)
Table 2. Subdivision
Table structure: Unit code, Unit name, name of materially responsible person (abbreviated as MOL)
Table 3. Property, plant and equipment
Table structure: Inventory number, Name, Group code, Initial value, Commissioning date, Unit code
Enter in Table 1 information about the five groups (machines, instruments, electrical equipment, copying machinery, computer equipment), in Table 2 - on three divisions.
Create the "Accounting Card" form to enter data into table 3. Use the combo boxes to enter the department code and group code. Enter 15 units of accounting.
Create a form (type master / subordinate) "Information on depreciation charges for the group of fixed assets for the month" to view information for each group. The main form should contain the group code, the group name, the month number and the total amount of depreciation for the month, the subordinated form - in the table form the list of fixed assets included in the group and the depreciation amounts for the month for each accounting unit. Provide input of the group code and the month number on request. If the depreciation period has not expired (the expiration date of the depreciation exceeds the end date of the month), the amount of depreciation for the month is calculated by the formula: A = S * N / (12 * 100), where S is the initial cost, N-year depreciation rate in% . Otherwise, the amount of depreciation for the month is 0. The end of depreciation is calculated using the formula:
Commissioning date + 365 * 100 / N
Create a form for transferring equipment from one unit to another. Select the units using the combo boxes.
Create a query to search for fixed assets with a zero residual value.
Create a report "Summary statement of depreciation charges for the current month for the group of fixed assets" with an indication of the initial cost and the calculation of depreciation from the beginning of operation and for the current month, as well as the residual value for each denomination, MOL and everything. Information on each accounting unit should be output in full.