MS Access
Microsoft Access 2016.
. (, , , ), , . .
() , , , , .
, , .
, .
, , , (-), .
, () . , .
: (, , ), (, , ) .
, , , . , , , , .
, .
. , , , .
, , (, ), .
, , .
|
|
() , . , . (, ). , .
.
.
.
(, ), .
, .
. (relation), . , , , , , .
. (E. Codd).
, , (, , ) . , , .
, - . -, . , . .
, ( , ) . , . . .
.
MS Access | |
Cache | |
IDS | |
FoxPro | |
IMS | |
Oracle |
(, MS Access), .
-. :
;
, . . (, . .);
|
|
;
;
.
( ), , . () ().
, , . ( ), , .
.
. , .
, : , .
MS Access . , .
, : , , , .. , .
.
, . .
:
, . .
, ( ) . .
() . : () .
, . , , .
. . . , . , , , ICQ, , .
( ).
, , . . . - , .
, , . . . , , .
, ( ). .
|
|
. ( ) . .
, , .
() (). , , .
. , .
() -, -61, .
() (AND), (OR), (NOT). , -61 -62, :
- 61 - 62.
. -63, 5. , .
. , .
. , , .
. , , .
( ), : Like():
, . . , (, , ) . , (. ). .
, , . ( , , ).
|
|
, : . 3.1 3.2.
3.1.
3.2.
(.3.3).
1, 2, 3 23 .
2433 .
3.3
1, 2, 3, 4, 7, 9, 13, 17, 21, 23, 24, 28, 32, 34, 36 | |
1, 2, 3, 5, 8, 10, 14, 18, 22, 23, 25, 29, 33, 35, 37 | |
1, 2, 3, 6, 7, 11, 15, 19, 21, 23, 26, 30, 32, 34, 36 | |
1, 2, 3, 4, 8, 12, 16, 20, 22, 23, 27, 31, 33, 35, 37 | |
1, 2, 3, 5, 7, 9, 13, 17, 21, 23, 24, 28, 32, 34, 36 | |
1, 2, 3, 6, 8, 10, 14, 18, 22, 23, 25, 29, 33, 35, 37 | |
1, 2, 3, 4, 7, 11, 15, 19, 21, 23, 26, 30, 32, 34, 36 | |
1, 2, 3, 5, 8, 12, 16, 20, 22, 23, 27, 31, 33, 35, 37 | |
1, 2, 3, 6, 7, 9, 13, 17, 21, 23, 24, 28, 32, 34, 36 | |
1, 2, 3, 4, 8, 10, 14, 18, 22, 23, 25, 29, 33, 35, 37 | |
1, 2, 3, 5, 7, 11, 15, 19, 21, 23, 26, 30, 32, 34, 36 | |
1, 2, 3, 6, 8, 12, 16, 20, 22, 23, 27, 31, 33, 35, 37 | |
1, 2, 3, 4, 7, 9, 13, 17, 21, 23, 24, 28, 32, 34, 36 | |
1, 2, 3, 5, 8, 10, 14, 18, 22, 23, 25, 29, 33, 35, 37 | |
1, 2, 3, 6, 7, 8, 14, 18, 22, 23, 25, 29, 33, 34, 36 | |
1, 2, 3, 6, 8, 13, 17, 21, 23, 24, 28, 31, 33, 34, 37 |
3.1. 1. 1--1
, , 1--1. .
3.2. 2.
, , . .
3.3. 3. 1--2
, , () 1--2.
3.4. 4. 1--1
, , , , 1--1 ( ).
3.5. 5. 1--2
, , , , 1--2.
3.6. 6. 1--3
, , , , 1--3.
3.7. 7. 1--1
, , , , () 1--1.
3.8. 8. 1--2
, , , , () 1--2.
3.9. 9.
, , , , , (4) .
3.10. 10.
, , , , , (3) .
3.11. 11.
, , , , , (5) .
3.12. 12.
, , , , , (2) .
|
|
3.13. 13.
, , , , , (3) : .
3.14. 14.
, , , , , (4) : .
3.15. 15.
, , , , , (5) : .
3.16. 16.
, , , , , (4) : , .
3.17. 17.
, , , , , (2) : .
3.18. 18.
, , , , , (2) : .
3.19. 19.
, , , , , (2) : .
3.20. 20.
, , , , , (2) : .
3.21. 21.
, , , , , (5) .
3.22. 22.
, , , , , (4) .
3.23. 23.
, . , .
3.24. 24. 4
, , , , , , , 4.
3.25. 25. 3,25
, , , , , , , 3,25.
3.26. 26. 3,5
, , , , , , , 3,5.
3.27. 27. 2,75
, , , , , , , 2,75.
3.28. 28.
, , , : , .
3.29. 29.
, , , , .
3.30. 30.
, , , , .
3.31. 31.
, , , , .
3.32. 32. 4
, , , , , 4.
3.33. 33. 3,75
, , , , , 3,75.
3.34. 34.
, , , .
3.35. 35.
, , , .
3.36. 36. 987660
, 987660.
3.37. 37.
.