1. .
2. . , . .
3. . Access 1, . , .
4. , , Access.
. . (Excel), . :
, , , .
' . .
. , , ' .
Access Windows. Windows.
Access , . , Paradox dBase. Microsoft Office, Access
(Word), (Excel), (PowerPoint). Internet World Wide Web HTML, Internet Explorer Netscape Navigator.
Access , . Access .
, : ' (, ), ' (, , , ).
Access (.MDE) , , VBA-.
, Access ,
.
, .. . , . , .
|
|
- ( ), ( ), , , .
, . , . :
1. .
Table.
New .
Microsoft Access New Table.
TableWizards ( ).
.
2. .
Table ( Tables View).
New .
Microsoft Access New Table.
New Table.
Microsoft Access . :
, ( ) , .. . Access .
, , , , . Data Type, .
Access :
Text , 255 . Field Size ( ).
Memo Memo- 32000 . .
Number . Field Size ( ).
Date/Time / 100 9999 .
Currency 15 .
Counter , Access 1, .
Yes/No . .
OLE Object OLE - , , , Excel- Microsoft Draw - , OLE - . 128 . .
(). , . . , .
Field Size Number.
|
|
Format . .
Decimal Places .
Caption , . , .
Default Value , .
Validation Rule - , .
Validation Text - , , Validation Rule.
Indexed .
. , , . , .. , .
:
, , , .
.
Microsoft Access .
.
.
, .( Shift+Spacebar).
Edit Delete Row ( Delete Row ).
Microsoft Access .
.
, , .
Edit Insert Row ( Insert Row ).
Microsoft Access .
Microsoft Access , . , . .. :
icrosoft Access . .
, Microsoft Access .
, Access . , .
.
, . , Ctrl .
Edit Set Primary Key ( Set Primary Key ).
.
Access- OLE .
Access . , - . . , Access. , , Access, , Paintbrush- Access-.
|
|
, , Access- , , , , . Access , . ( ) , Access- , Access. , , Excel Access-. Excel- . , Access-, .
.
Edit Insert Object ( , OLE Object.)
Object Type , OLE .
, File, Insert Object from File.
OK.
.
Edit Past Link. ( , , .. Clipboard.)
OK.
Access . . Access , , .
.
Edit Relationships, Relationships . Relationships, Add Table.
Add Table , Relationships.
Table/Query . , Ctrl . , Shift , Add. .
. Microsoft Access Relationships.
, . , , : One ( ) Many ( ).
Create.
, , :
, , , Access, Access-, , . , .
|
|
/.
File Import|Export Setup
Specification Name, .
, Save as , OK.
OK.
.
File Import Import .
Data Source . :
-
- -
-
Microsoft Excel