( , , ), , , , , . , , . , . , , , . , , , . ? - , ? , ().
(relational) . , . , , . , . , , . , , () .
:
q (Data definition) , , (, ), , . ;
q (Data manipulation) . ;
q (Data control) , , . .
Microsoft Access .
Microsoft Access.
, Microsoft Access :
1. .
2. .
3. Microsoft Access.
1. .
|
|
Access , () (). (, , , ).
, .
2.1 MS Access
Access : (by entering data) (in Design view), .
, . , :
1. .
2. Access . . . .
3. (Field Name) .
4. (Data Type) , .
5. (Description) ( ).
6. (General) (Lookup) , .
7. ( ).
8. < >? (Do you want to save changes to the design of table < >?), (Yes).
9. (Save As) (Table Name) .
10. (There is no primary key defined) ?(Do you want to create a primary key now?) (Yes) , (No) .
11. . , .
Microsoft Access :
o (Text) , . (FieldSize), , .
o MEMO (MEMO) MEMO , 255 . (Text) , , , . (, . .).
o (Number) , .
o / (Date/Time) .
o (Currency) , , 1 4 .
|
|
o (AutoNumber) 4- , Microsoft Access , 1. .
o (Yes/No) , , /, /, /.
o OLE (OLE object) OLE- ( Microsoft Excel, Microsoft Word, , . .). OLE , . , , .
o (Hyperlink) , Web- , .
- (Caption). , ( , , ..). , (Required), .
(Format) . . . : / (Yes/No), / (True/False), / (On/Off).
(Input Mask) , . , , . . .
(Indexed) , , , . : (Duplicates OK) (No duplicates). , .
, , , :
q (Validation Rule) (), . .
q (Validation Text) , , , (Validation Rule).
. , . , . (Lookup Wizard).
. , . , Microsoft Access . , .
:
1. .
2. Access.
3. .
4. , :
();
(, 20 );
|
|
(, );
(, 8 , 99-99-99);
(, 20 ).
5. , :
();
(, 20 );
(, ).
6. , :
();
(, 10 ).
7. , :
();
(20 );
(10 );
(, 20 );
();
();
( );
(1 );
();
();
().
8. .
9. , .
10. :
q ;
q - : , , , ;
q 0..6;
q - : ;
q 1000..100000.
, , , . , . : (.2.2). - , -, .. . , .. .
2.2
(, , ), .
. . , . , .
. , , .
. --, / , / . --, . , , .
.
, , . .
|
|
:
3 : , , , .
, + + , .
, , : , .
, 5 , 3 , .
10- .