- Arts & Culture 5932
- Business & Economics 680
- Computers 310
- Dictionaries & Encyclopedias 81
- Education & Science 75718
- Abstracts 252
- Astrology 4
- Astronomy 1
- Biology 8
- Chemistry 2221
- Coursework 15444
- Culture 9
- Diplomas 411
- Drawings 574
- Ecology 5
- Economy 83
- English 75
- Ethics, Aesthetics 3
- For Education Students 17597
- Foreign Languages 11
- Geography 2
- Geology 1
- History 89
- Maps & Atlases 5
- Mathematics 13850
- Musical Literature 2
- Pedagogics 19
- Philosophy 23
- Physics 14821
- Political Science 5
- Practical Work 101
- Psychology 60
- Religion 4
- Russian and culture of speech 8
- School Textbooks 7
- Sexology 42
- Sociology 9
- Summaries, Cribs 87
- Test Answers 150
- Tests 9243
- Textbooks for Colleges and Universities 32
- Theses 24
- To Help Graduate Students 14
- To Help the Entrant 37
- Vetting 362
- Works 13
- Информатика 10
- Engineering 3059
- Fiction 696
- House, Family & Entertainment 107
- Law 132
- Website Promotion 71
Accounting for fixed assets by groups Access Equipment
Refunds: 0
Uploaded: 07.06.2014
Content: uch_os_grup.zip 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.Product description
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.
Feedback
1Period | |||
1 month | 3 months | 12 months | |
0 | 0 | 0 | |
0 | 0 | 0 |