( 6, )
ACCESS 2010
: MS ACCESS.
: .
: MS Access 2010.
Microsoft Access (.. , ..), . Access , , , , , . , Access , , .
, () (). .
, , , ( ). , .
, , , .
, , .
, .
, , . , , , ..
() : . , (). , ; .
:
1. .
2. .
3. .
4. .
5. .
6. .
7. .
8. .
1-6 . 7-8 .
, , -, .. . .
|
|
|
, ( ), . () , :
;
;
;
;
.
1 Microsoft Office Access 2010 , , . , Office Access 2010 2 .
1
MS Access
| , , , . | 255 | |
| MEMO | , 255 , , RTF- . MEMO , . | 1024 1024 1024 , 2 (2 ). 65 535 . |
| ( ), ( ). | 1, 2, 4, 8 12 (16 , ). | |
| / | . | 8 |
| . . | 8 | |
| , . . "" , . | 4 (16 , ) | |
| : /, / /. | 1 (0,125 ) | |
| OLE | OLE Microsoft Windows. | 1 |
| (, ), ( ) , Microsoft Office. "", . | 2 . 700 , . | |
| ( Access, ). | 1024 1024 1024 , 2 (2 ). 65 535 . | |
| , , , ( ). , , ( ). | , (. . ), , . |
|
|
|
, Microsoft Access Mirosoft Access 2007, . Microsoft Office Access 2010 , , , .
, , Access --.
, , , :
, ( );
Access SharePoint, , Windows SharePoint Services;
SharePoint, .
, , , , , Microsoft SQL Server. , , Office Access 2010 SQL Server MEMO (ntext), . SQL Server , --, .
2 .
2
MS Access
| . | |
| . | |
| , . | |
| , ( ) "" . | |
| , . | |
| , , . | |
| , . | |
| , . | |
| , , , . | |
| , . | |
| ( ) ("") MEMO. | |
| . | |
| , , 4096 ( ). 4096 , . | |
| IME | Windows. |
| IME | Windows. |
| - | -, . |
| , . | |
| HTML- RTF- RTF. , . | |
| . | |
| , Access ( ""), . |
( ). , . , . , .
|
|
|
. , .
, . :
(), . Null . . . , (. . , ) . , , . , . - , . , , ;
(), . .
: .
, . .
, . , , , , . ( ) ( ). .
, . ; , , , .
|
|
|
Microsoft Access 2010 , . . , , .
. , , . . .
, , :
, , - . : , .
, , . - , .
, , .
: , .
, , ().
.
Microsoft Access . Access , , . (, ):
;
;
, .
, Microsoft Access , . , :
( ).
( ) . : , (FieldSize) .
Microsoft Access. , , .
, :
, .
, .
, , .
, Microsoft Office Access
. , , , , .
, , . , . , .
|
|
|
, . , .
Microsoft Access , :
, , , .
, , .
1. Microsoft Access . Access.
2. (Blank Database) (.1).
.1
3. (Blank Database) (File Name) (_) , .
4. (Create).
. , , - Microsoft Office Online.
() (), .
. , , Microsoft Office Excel, .
: , , , __ (. 1).
1. (Create), (Tables) - (Table Design).
2. (Field Name) .
3. (Data ) .
4. (Description) , .
(Field Properties) :
(FieldSize);
(Validation Rule);
(Format);
(Input Mask);
(Required).
(Input Mask) . 2.
.
6.1. (Input Mask) (Field Properties) (Input Mask Wizard) ( ).
.
6.2. (Input Mask Wizard) ( ).
6.3. , . (. 2).
.2
6.4. ; (. 2); ( ); ( ) . .
6.5. - . (Try It) - (Next) - (Next) - (Finish).
6.6. .
7.
7.1. (Design) , .
7.2. (Primary Key) , (.3).
.3
7.3. , , (, Ctrl), (. 7.2).
8. (Default Value)
8.1. (Field Properties) (Default Value).
8.2. (...) (Expression Builder) ( (Function) - (Built-In Function) - aa/Bpe (Date/Time)) Date(). .
9.
:
9.1. (Save) .
9.2. (Save As).
9.3. ( Backstage), (Save As). , , .
