Access, , , , . <Alt>+<E> Access 2003, (Edit) ( ). <S> (Paste Special).
, Access 2007. , Access 2007 ! , Microsoft , Access. - , . <Alt>+<E> Access 2007, (. 5), , Access 2003. <S>, (Paste Special), , . .
, . , . , , , . Access .
. 5. <Alt>+<E>, "" .
, Access 2007 . , . ,
Office
Access 2007 Access. (File), , , Office. Office (. 6).
. 6. Office , .
, () ()
, Office :
■ , . 1;
■ (. 3) (. 19);
■ Access. Access (Access Options) Access Access.
|
|
, . Office . (Print). Office .
( ), c , . 7.
. 7. , , . ( ) ( ). ,
, , Office (. 8). , Access. (Quick Access toolbar QAT Access).
, . , . , - . , .
Microsoft . , , . , - , ,
. ( , , .)
. 8. ,
. Access , . , ,
Access 2007
Access 2007 . . Microsoft Access 2007. , Access 2003. . .
■ (database engine). Access , Jet ( ). Access 2007 Jet, Access .
, Access 2007 100% . , , Access 2003, (, , ) , .
|
|
■ (Attachments).
Access (Attachment), , , . ( , , . . Access 2 .) , . "" 2.
■ . . Access 2007 , . (Layout), .
■ (Complex data). , ( "" ). . , . SharePoint.
■
. , . 5 , , , , , .
SharePoint. SharePoint , , . Windows Server 2003. Access 2007, , SharePoint.
SharePoint, , Access. SharePoint, SharePoint , Access . 21 SharePoint Access.
■ . V, . Access , ,
- (, ). Access . Access 2007 (trust center), , , . Access 2007 (, ), , .
, : Microsoft. Office 2007 . Microsoft - , help- , , . , , , , , , , , , , .
|
|
Access 2007. Access, , () .
, .
■ I. . , , . , , .
■ II. . , , .
■ III. . , "" , , .
■ IV. . , Access.
■ V. Access. , , Access. Visual Basic .
■ VI. Access. ( ), Excel. , Access
Microsoft: SQL Server SharePoint Server.
■ . , , .
→ →
, : " -> -> (Create -> Tables - Table)". , Access. : " . . ". ( . .2 .)
. , . Access , , , . . , , .
|
|
, . , . , (. 9),
. 9. Access , , . , .
, , , . , . , . Access , , . , (. 10).
. 10. , , .
, ( . 10). : " | → → (Table Tools | Datasheet → Fields & Columns → New Fields)". (Table Tools) | (Datasheet).
: . , , , , . 11.
, , , . , : " → → → (Home → Views → View → Design View)". , (m), (Views), (View) ( ) (Design View).
, , . , . , . Access (, ) , .
. 11. Access . , , , -
, . Windows, , Visual Basic (. 16). . " → (File → Open)" , (File). (File) (Open).
Office. : " Office → (Office → Open)". : " Office Office. (Open)".
, , , . , , . , <Ctrl>+<S> Access ( ).
|
|
<Ctrl>+<S>, , <Ctrl> , , <S>, . <Ctrl>+<Alt>+<S> , <Ctrl>, <Alt> , , <S> (, ).
, (track pad). " " - ( ). , , - . , , " " .
, , Access . Access, . Web- www.missingmanuals.com, , Missing CD ( CD) , , zip- , .