5
:
: , ACCESS, .
.
1. .
. . , . . , . , , . , , . ( , ) .
, , , (, , , , ).
.
, .
, : , , . () . , .. ( 64 ), , , ( ) ( , ).
, Access
255 | , . , . | |
65 535 | , 255 . | |
1, 2, 4, 8 16 | , . , . | |
/ | 8 | . 100 9999 . |
, 1 4 . 15 . | ||
4 | , , . . | |
, " / ". "" 1, "" 0. | ||
OLE | . | OLE |
, : , " . , , . .
|
|
Access
. | |
, . | |
. | |
, . | |
( , , , , .) | |
. | |
, . | |
, , . | |
. | |
, , , " ". | |
, . | |
, UNICODE . | |
. |
, . , .. , . , , , , . .
Student
. , . .
2. :
Student
NStudent | = = | . | |
CName | = 25 = = | .. | |
NDepartment | = = | , | |
NIQ | = = | , . | |
NTeacher | = = | , . | |
OPhoto | OLE | = |
Department
|
|
NDepartment | = = | . | |
CName | = 25 = |
Post
NPost | = = | . | |
CName | = 25 = |
Teacher
NTeacher | = = | . | |
CName | = 25 = | . | |
NDepartment | = = | , . | |
NPost | = = | , . |
Subject
NSubject | = = | . | |
CName | = 25 = | . | |
NHour | = = | (). | |
NTeacher | = = | , . |
, , , , , . , , .
, . .
3. Student, , .
Remark | MEMO | = | . |
. , . , , , , , .
, . PrimaryKey.
, , .
. , , . . , , , . . , PrimaryKey.
|
|
, , , , .
, , , . , . , : , .
.
, . , " " " ( )" " ( )".
4. Student CName.
5. Subject CName, NHour.
, . , , , . . , ( ) , ( ). , () , ().
. Access . , , . , , .
, , , .
, , , . : , , , , .
. , ( ) ( ).
Access , .
, . .
|
|
, Access .
1. " " , :
, .
, .
, .
2. " " .
3. " " .
- , .
Student Department NDepartment. NDepartment Student NDepartment Department. " ". NDepartment Student , Department. Department NDepartment , Student .
Student Department
Department Student, . Department Student, .
6. , .
7. :
). , ;
). , ;
). ;
). , ;
). .