Ҳ 23
Access.
˳:
6. .. 㳿: . .- .: , 2005.-302 .
() Access - . Excel Access . Access , .
Access - , , , , , , , . Access ' ( MDB), :
- ' ( () () Excel);
- , , , ;
- ' ( ), , ;
- ' ;
- - ' Web- ;
- - , ;
- - , Visual Basic .
Access , :
1) Excel;
2) Word Excel, ;
3) ;
4) ;
5) , , , ;
6) ;
7) ;
8) , Web ;
9) .
Access . , Excel : ", ", ", Excel" . Word Excel.
|
|
Word ' Office / Microsoft Word" ". Excel /". Excel" ".
, . (.5.1), ( 64 ) : ( 255 ), MEMO ( 65535 ), ( 8 ), / (8 ), (8 ), (4 ), (1 ), ' OLE ( 1 ), ( 2048 ), ( , ).
- ' ( ϳ") , ( ) .
(.5.1), . , Access ' " ˳". ( ' " " " ") . ( ' " ") ( ) .
" ".
' (.5.2) , , . ' ( ) : / "; " ; ( ) ; '" " ".
' , Access, . : , Գ"; ' ; , , .
|
|
, . (.5.1), , ̳ ". . , ³". " ". ̳" "" ( ) ". . , "*". 䳺 .
. , "Գ " . , "" Գ ". ".
' ", " ", ' . .
. , " ()" (.5.3). :
- , "";
- "" "*" (), "";
- "" "";
- " " : Between [ ] And [ ];
- / " " ". (.5.4).
- '.
. ". , , , , . , 쳿 (50% , ") :
: 1:(!*0,5)
, ,,Int()" .
, , . /". " ' .
, /".
/ ". " ' . , " , .
|
|
SQL (Structured Query Language). SQL IBM . Oracle Corporation Oracle. (ANSI) SQL .
SQL SELECT ( ?). : FROM ( ?), WHERE ( ?), ORDER BY ( ?).
SQL ' SELECT FROM. ;".
, ", ϲ" ( ") " ( ") SQL , .
" SQL", . :
SELECT ount([ϲ]) AS [ʳ ]
FROM [ ];
SELECT Sum([3ap]) As [ ]
FROM [ ];
SELECT Avg([]) As [ ]
FROM [ ];
ij , , , , . . (, ) .
. , ( , , ), . .
. ", ", " . . , ", , : , , , , .
(.5.5) , , , . " " (/)". , (/)". " ". - . " .
" ". (, , ) .
|
|
, , , : ( ' ) ( ). , . ' . .
: " ; ; '; (.5.2).
: " ' 19", " ' .
. , " . , " ", " ³". " " :
' ( Dim), . ³ ( ϲ" ) .
, , . ". ( , , ; , , ), 䳿. , 䳿, : , .
. , . . / / ". , , . . . , ( ", ") : ", ", ", ", ". . , . .
. , : , , , , . ", ".
, , , , - . . . , : , , (, ), . ϳ , : , , . , ֳ" , " " ֳ". (, ":"), =Sum([ֳ]).
|
|
, Visual Basic .. , " " . , " ", " ³". " " :
Private Sub Report_Open(Cancel As Integer)
Dim _ As Variant
Me.RecordSource = "select*from[ ]where[̳]= _ And []
> 0 Order by [ϲ]"
End Sub
' ( Dim), . ³ ( ϲ" ) , ( [] > 0) .
. . .
Web , 볺 ". 볺" , , " , . Access - 볺 Web , - . , 㳿 볺-" :
- HTTP (Hyper Text Transfer Protocol) , () . - , . , , , ;
- FTP (File Transfer Protocol) .
Web- HTML (Hyper Text Markup Language).
Web- Access :
1. Web - ;
2. Web- .
Web , , / ". HTML" .
Web- , ", ", , , , . ϳ ' , (, , , ).
Web- Web- ' , ' .
Access .
' , . " ".
" , , ' . . 䳿, , , ' .. " . , ".
Access Visual Basic . , - . 㳿 . , "", 3 , () . "" , "" ", "" "...". Visual Basic ( ):
" " "" 3000(1000 1 ), "" .
Access , , 㳿 (. 5.3).