Microsoft Access 2007
 . 



   ,      ,        ,       ,           . ,            .

              Microsoft Access.    ,     .       ,     .

      .





 

Microsoft Access 2007








       Access 2007,      Microsoft Office 2007        (). Access             .               .           .

          :     ,     ,           .        ,    .

           .   ,       ,      ,     .

 ,          Access 2007            .


   

   ,          AlexanderZhadaev@sigmaplus.mcdir.ru     www.sigmaplus.mcdir.ru (http://www.sigmaplus.mcdir.ru/)(       ,         ).

 


 

 ,         dgurski@minsk.piter.com ( ,  ).

     !

   http://www.piter.com (http://www.piter.com/)      .




 1

 



    Microsoft Access

  

    

  

  Access 2007

  

  Access 2007





 Microsoft Access 2007       ().  Access,               . Acess   ,                   .

          :     ,   ,           .        ,    .

           .         ,      ,      ,  .

  ,     ,    ,       ,       .       ,     .




    Microsoft Access



 Access     ( . relation  ).  ,    Access    .     ,      .







          .     (. 1.1),     .


 1.1. 







  


   .     , ,    ,     ,     .         , ,  536      ,  534      ..

 ,  ,      .     . ,   (  )   1000,          1000.

     .     ,    . ,    536   .      ,     . ,   (ID)       .

       . ,   (ID)    ,   ,     .




  


         .    (. 1.2),    .


 1.2.  




        (ID)       .  ,        .  ,       -   .

           .          .  ,         (,   ,           ),     . ,           .

 ,  ,       ,      (  ),     (  ).      ,      .




 


        :     .             ,     .       ,              .

        ,    (,   (ID)   ).  Access        .

     ,      . ,        .  ,        .

,       ,        .




  


   ,      .  ,          ,    .

1.   ,           .       :

     ;

   ;

     ;

           ..

2.     ,         .        ,          .         : ,   .  ,      .

3.      . ,          (  )   ,      .         (.1.1). ,       ,           .

 ,        . ,         ,      ,        ,    .




.1.1.  



,       ,       ,       .   ,        Microsoft Access.




    


,    ,         ,         Access.       Access.   ?      ,     ?

  ,  ,   ,                Access     .  ,      ,        ,       .

,       ,     .

1.       (. .   ).

2. ,       .     . 2.

3.  .          (. . 2),      (. . 3)       (. . 4).

4., ,       ,     .  , ,         (. . 5),       (. . 7).

                 .




  



    ,    Microsoft Access,       .




 Access


   Microsoft Access 2007       Windows .

  ,        ? Microsoft Office ? Microsoft Office Access 2007.

              .





   ,    ?   ? Microsoft Office ? Microsoft Office Access 2007 ,    Ctrl,            .


        .          .

     Access (.1.2),          .




.1.2.   Microsoft Access 2007



  ,       .         ACCDB.       , ,      ,    .




   


     ,    ,             (        Access,    .1.2).

      ,    .      Windows   .           .

 ,    




    ,      ,        Windows.

      Access    ,    ( )     :     .      ,     ,     .      Microsoft Office           .

,  ,      .        ,      .




   


       ,     ,      .     .

1.                   (. .1.2)   




    ,        .

2.        .         .  




  ,       .

3.  .        ,       .

     : ,             .   ,     .




   


        ,     .     .

1.    ,   .  




    ,       .      Windows   .

2.          ,      (.1.3).              .




.1.3.    



                .   ( )     ,       .

      ,          .

         ,            .              ,   .        ,    .

        ,              (  ).             .

3.      Access    ,             .      ,     ,     .      Microsoft Office           .

4.     ,     .    




     ,        .        Access 2007.

     Windows .      ,  ,      ,    .

       :   , ,    .




     


 Access 2007    .           ,      ,   ,       .       ,   .

1.     Access (. .1.2)   .        .        (.1.4).

2.           .         .   




 ,       .

3.       - SharePoint,          Windows SharePoint Services.




.1.4.     







Windows SharePoint Services   Windows Server,        .    Access 2007 (. .   Access 2007)               Windows SharePoint Services.


4.   (  Microsoft Office Online   ). Access             .

5.     Access    ,             .      ,     ,     .      Microsoft Office           .

     :    , , , ,   ..




  


   ,  




    ,         .       Access.





  Access       .    ,          .


                Access.




  Access 2007


Access 2007    ,       .                .

       Access (. .1.2),     .        ,        .

      .1.5.

     ,    (, Access 2007)     Microsoft Access.

 Office    ,   , ,     ,      ,            .        Microsoft Office.

            ,             .

    ,       .    ,         .           .

 , ,           .        ,      . ,    ,       ,    ,     Access  .    Access 2007       :        ,   .




.1.5.   Microsoft Access 2007



       (, , , , )     .     ,           .        




    .

/ .        Access        .

        ,     ,          .

       Access.      ,    .




  



  Access  ,       .            .

      ,   ,  ,       .




   


     ,    .   ,     ;                        .

         .

       (   ) .    ,   .    ,   .

       .        .       ,        .  ,    ,    ,     .




   


      Access         ( ),    .           .       ,    .





  ,     ,            ( ,      ..). ,       ,    .


 ,     .


    

        ,         ,    ,                  .

        ,                      .

         ,   ,    .


    

,           .

1. 




  .         (.1.6).

2.       ,      .      ,    .         ,      .





         ,    .        .










.1.6.     



   23

3.          ,    .      Access (.1.7).




.1.7.   Access      



4.       .    ,     ,    .       ,      :   ,      ,    ,    ,      .

5.   ,     ,  ,   ,         ,       .   .      ,         .

6.     ,              .      ,        .

7.       ,                 ,  











8.      Access   .          .

  ,            .


    

          .                          (     ) , ,        (     ).

      Access    .




   


   (, , ,    .) ,    ,     Access     .

 :          (. .1.5).          .    ,      () .  ,     ,       .

   (.1.8):   ()    .       .           ,        .             .           




       .




.1.8.  





!

        .     ,        .


       ,   .

1. 




     .          Access,       Access.

2.        .

3.             :

  ,     ;

 ,     .       ,     .

4.    ,        .   ,    .   .

,            .




    


       ,   .

1.  Office.          Access.    Access.

2.           .

3.           ,     ,   ,     .

4.   ,        .   ,   .   .





   Access,      ,         Access.


     Access    ,    ,      .



!

   ,     ,      .     ,       .





  Access 2007



          ,       Microsoft Access.          ,    - Office Online      Offline Developer Help.





   Access 2007       . ,  Microsoft Office   ,  ,       .


      F1  




    .     : Access (.1.9).




.1.9.  : Access



        : Access.




    


           .






   ,      .






    .          .    , 




   .






,         Access.      




 ,         .

     ,   .




  


       ,   .

1.  F1,    .




  .


   .

   ,     (https://www.litres.ru/aleksandr-dneprov/microsoft-access-2007/)  .

      Visa, MasterCard, Maestro,    ,   ,     ,  PayPal, WebMoney, ., QIWI ,       .


