.., ..
2
-2011
681.324(075)
. ., . ., . . " " ( 2), 2011, 156 ., .
:
., , , .
. , , , " " 쳿 .
" ". ( 2) 4 , . , .
Ͳ . . 9 .
.
: MS Access, , , MS Word MS Excel. MS Outlook, MS Office, ' .
1. MS Access.
MS Access , MS Word MS Excel. ' MS ACCESS. , MS Access :
MS Access. . .
. . . . . .
. ' . '.
. , . , , . г - , , , , . , . г . . "" .
|
|
. . " ", . , . . .
г : , , , , , . .
ϳ . . ' . , , ', .
. . " ", . , . . .
MS Access 볺 . , . . - 볺. (CRM - customer relationship management). - 볺 , , , 볺, , , 볺 . , -, .
, -, . . , , ..
ϳ , , :
.
' .
( ).
.
1.1. ͳ 1- 2 (4 )
, . - MS Access MS Access. - .
1.1.1. ϳ . Ͳ .
, 5 6.
, , . - ().
|
|
() - , .
- ( , , VBA, SQL ) , , .
, .
. " " ' , , (related) ' ( 볺 볺 ). , ' , ' .
. ' . .
. :
' - ', .
, 볺 ' :
- ' - 볺,
- '- .
' ' .
() - '. () . , , ', - () ' 볺.
' ( ) - , ' '.
'. ' ' .
. :
'.
', . , 볺 , , '.
' .
' - :
"--" (" --") (1:1),
"--) (" --") (1:),
("--") (" --") (:).
' "--" (1:1)
' ( ') . ' , , ' , . , .
' "--"(1:)
' () ' () . . '. . " " , - "" .
, 볺 (, ..). , ( ) , 볺. 볺 - ', .
|
|
г ( ). 볺 . (). ' 볺, . 볺 . ', , 볺 ( 볺). "" ( 볺) . - ( ).
' "--"(:)
' ' . '. ' ' "--". . ³, : "" "". ' . ' .
' :
,
' .
³, , ' .
MS Access
MS Access - , Windows (98, 2000, XP). MS Access , ' . MS Access , - . Access, - Windows, Windows (DDE OLE), . Access ', ' .
' MS Access :
, ', , , , .
, , .
䳿.
.
, .
' Access mdb, , 볺.mdb. ' .
MS Access
ϳ MS Access ' MS Access, , . , 䳿 . ( , .)
. 1. MS Access.
, . " " : " " - ( ) - (, ). ( )
|
|
ϳ Access ' , . ' , . ' (, ' ). , MS Access ' , , (, , MS Word MS Excel). . , , ( MS Access , ). , ( , ).
ϳ , Access , . ֳ ': , , , , , . . ϳ .
, , ' .
ϳ Access Mirosoft Access ' . ϳ ' (.2), ': , , , , , .
' .
' , .
.2. ³ " "
ϳ Access (. 3), , .
. 3. ³
' 64 : -!, , - [ ] - ',
, .
̲: ' , , , , " " ' : . ' , Visual Basic for Applications (VBA), ' .
, Access ( 1). , . Access - . Access . !
, , , . . .
- Memo -; . 50
, , /. .
- .
- . , ( " - " " / "
|
|
- , ( ' , ).
- , . , ̳ , , , () . , .
- , . . , 볺 15000 ., : <=15000.
- , ' .
- , , ' . , ( " " ). ( " ").
- , , (" ").
- .
/ ' .
1. MS Access.
- ( 255 ) | |
Mm | - , ( 64 000 ) |
г ( : , , | |
/ | Access |
, 8 . . | |
, Access | |
, | |
OLE | , ' OLE Windows |
, , Internet Intranet. |
̲. , . ( )
" "
, . , , . . , .
, , ' .
- ' .
, Access , . . . .
, - , ' - / . ϳ ' ' .
. Ctrl " ". ' , , .
'
" -- " " -- " , ' .
' : ' , ' .
! . ҳ , ', . , , " ", , MS Access . , ', . , ', , - .
' " -- " (1:) (" " ). ' ( !) " ", ( !), , .
ϳ Access , '.
' . ϳ Access . , , . ϳ .