'
1.
1.1. '
' Access (, , .) DAO (' ), ' VBA , .
'.
DataBase - . CurrentDB. DataBases ' DataBase.
TableDef - , . TableDefs , ' DataBase.
Recordset - ' DataBase. Recordsets ' Recordset ' DataBase.
Field - . ' Field . Fields .
QueryDef - ' DataBase. QueryDefs ' DataBase.
Index - ' DataBase. Indexs ' Index, QueryDef.
' ( , .), ' ( , .), '.
:
'.
:
'. =
:
' = '.
:
'.
,
'. (1, 2 )
1.2. ϳ
ϳ VBA :
- ', ;
- ;
- ' Recordset , .
1.3.
ϳ ' Recordset.
:
- - . ij ;
- - , . . , , ;
- - , , . , .
|
|
|
1.4. ' Recordset
Rs.BOF - True, .
Rs.Bookmark - Variant, .
Rs.EOF - True, .
Rs.RecordCount .
Rs.Sort - .
Rs.Fields.Count .
Rs.Fields.Name .
1.5. ' Recordset
Rs.AddNew - .
Rs.Close - .
Rs.Delete - .
Rs.Update - .
Rs.Edit - .
Rs.Move - .
Rs.MoveFirst, Rs.MoveLast, Rs.MoveNext, Rs.MovePrevious - , , .
2.
1) , ( ).
2) , .
3.
1. ?
2. ' Recordset?
3. ' Recordset?
12.1- 12
| . | |
| ³ : 50 ., . 60 . | |
| ³ , 4 5. | |
| ³ , 5 . | |
| ³ , . | |
| ³ , . | |
| ³ . | |
| ³ , . | |
| ³ , 10 300 .. | |
| ³ . | |
| ³ : , 10 , 20 %.. | |
| , 1000 . | |
| . | |
| , . | |
| , . | |
| ³ , . |
|
|
|
1 -
| ֳ | ||||||
| " " | 100 | 2,61 | ͳ | |||
| "Nescafe Classic" | 100 | 6,26 | ͳ | |||
| "" | 100 | 2,40 | ͳ | |||
| "" | 50 | 2,44 | ͳ | |||
| "" | 10 | 3,78 | ͳ | |||
| Maxima | 250 | 4,80 | ||||
| "³ " | 100 | 1,94 | ͳ | |||
| 200 | 4,66 | ͳ | ||||
| Dilmah | 125 . | 2,95 | ||||
| "" | 5 10 | 1,00 | ͳ | |||
| Dilmah Gold | 100 | 2,39 | ͳ | |||
| Lipton | 2 25 | 3,57 | ||||
| Lipton | 200 | 15,6 | ͳ | |||
| Ahmad | 2 25 | 3,17 | ͳ | |||
| Ahmad | . | 3,23 | ͳ | |||
| " " | 500 | 8,56 | ͳ | |||
| "" | 260 | 4,73 | ͳ | |||
| " " | 500 | 3,96 | ͳ | |||
| "" | 500 | 8,80 | ͳ | |||
| "" | 250 | 2,65 | ͳ |
2 -
| Գ | ̳ | ||||||
| "" | .. | 245-223 | 234-340 | 12.08.03 | |||
| Pulkala | .. | Գ | 456-76-22 | 456-76-20 | 02.09.03 | ||
| . . | .. | 295-46-78 | 205-45-30 | 05.09.03 | |||
| 뺺 .. | 295-45-67 | 295-45-50 | 04.09.03 | ||||
| "" | .. | 245-700 | 245-756 | 10.08.03 | |||
| Dilmah | .. | ͳ | 567-80-30 | 567-80-21 | 30.08.03 | ||
| Nestle | . | ͳ | 4-757-320 | 4-757-320 | 11.09.03 | ||
| "" | .. | 256-901 | 256-978 | 23.09.03 |
3 -
| "" | .. | , 8 | 413-18-10 | ||
| .. | . | , 31 | 225-54-12 | ||
| .. | , 51 | 228-57-30 | |||
| .. | , 6 | 224-15-12 | |||
| ³ | .. | , 34 | 228-28-50 | ||
| .. | , 7 | 295-74-13 | |||
| .. | . | , 24 | 441-64-56 | ||
| "" | .. | , 30 | 553-56-30 | ||
| "" | .. | . 137 | 226-13-64 | ||
| .. | . 137 | 226-23-54 |
4 -
| "" | , 8 | 04.09.03 | |||
| , 31 | 06.09.03 | ||||
| , 51 | 04.09.03 | ||||
| , 6 | 10.09.03 | ||||
| ³ | , 34 | 04.09.03 | |||
| , 7 | 20.09.03 | ||||
| , 24 | 06.09.03 | ||||
| "" | , 30 | 16.10.03 | |||
| "" | . 137 | 21.09.03 | |||
| "" | . 19 | 29.09.03 |
5- 泔
|
|
|
| ֳ | ʳ | (%) | ||||||
| 2,61 | 10.09.03 | |||||||
| "Nescafe Classic" | 6,26 | 12.09.03 | ||||||
| "" | 2,40. | 21.09.03 | ||||||
| "" | 2,44. | 06.09.03 | ||||||
| "" | 3,78. | 06.09.03 | ||||||
| Maxima | 4,80. | 08.09.03 | ||||||
| "³ " | 1,94. | 21.09.03 | ||||||
| 4,66. | 6.09.03 | |||||||
| Dilmah | 2,95. | 13.09.03 | ||||||
| "" | 1,00. | 06.09.03 | ||||||
| Dilmah Gold | 2,39. | 06.09.03 | ||||||
| Lipton | 3,57. | 12.09.03 | ||||||
| Lipton | 15,68 | 12.09.03 | ||||||
| Ahmad | 3,17 | 08.09.03 | ||||||
| Ahmad | 3,23 | 08.09.03 | ||||||
| " " | 8,56 | 20.09.03 | ||||||
| "Nescafe Classic" | 6,26 | 12.09.03 | ||||||
| Lipton | 15,68 | 12.09.03 | ||||||
| "" | 4,73 | 08.09.03 | ||||||
| " " | 3,96 | 08.09.03 | ||||||
| "" | 8,80 | 10.09.03 | ||||||
| "" | 2,65 | 10.09.03 | ||||||
| "³ " | 1,94 | 21.09.03 | ||||||
| 2,85 | 10.09.03 |
6- 泔
| 10.05.03 | 3 220,00. | |
| 10.05.03 | 4 300,00. | |
| 10.05.03 | 1 100,00. | |
| 15.06.03 | 7 400,00. | |
| 15.06.03 | 8 500,00. | |
| 15.06.03 | 6 600,00. |
|
|
|
7-
| / | ' | |
| Գ | ||
8-³
| / | ' | |
9-³
| / | ' | |
| Գ |
10-
| / | ' | |
| г | ||
| ʳ_ | ||
| ʳ____ |
11-
| 1 11 | |
| 1 5, 11 15 | |
| 2 7, 17 20 | |
| 5 10, 17 20 | |
| 11 20 | |
| 4 9, 13 16 | |
| 3 6, 10 15 | |
| 6 12, 15 16 | |
| 7 10, 12 17 | |
| 8 17 | |
| 9 18 | |
| 3 9, 18 20 | |
| 4 8, 12 16 | |
| 5 14 | |
| 7 16 |
1. .
2. . .
3. , , .
4. 泔 .
5. , .
6. , .
˲
1. . Microsoft Access 7.0 Windows.- -.:, 1997.
2. ., .. Microsoft Office 97.- -.:, 1997.
3. Visual Basic ( 5) : . .- :BHV - -, 1998.
4. . Microsoft Office 97. : . .-.: "", 1998.
5. . , . . Microsoft Office. VBA: . .-.: BHV, 1999.
6. , . Microsoft Access 2000 24 .: . .-.:"". 2000.
7. .. Visual Basic 6.0, Visual Basic for Application 6.0. . .-.: -, 2000.
1. .3
2. 1..3
3. 2..7
4. 3.12
5. 4.14
6. 5.17
7. 6.18
8. 7.20
9. 8.22
10. 9.................................... 24
11. 10....................................25
12. 11................................... 27
13. 12................................... 29
14. ꅅ....32
15. 腅..39
