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. :
). , ;
). , ;
). ;
). , ;
). .
