,   .



                                
                                     :
                            



                                                              

                                                                    :
                                                              ..
                                                        :
                                                                 .



                                  1998
                                 



                                  
                                       3
                                                4
                                   
                                        4
                                   
                                        6
                                    
                                       10
                                   
                                       10
                                   
                                      11
                                                             13
                                 
                                     15
                                                   16



   .

                     
      .            
   .       
  .     Access 7 .
               
       .      
          ,
                 
  .
        .      
   Microsoft Access 7.  .     
  .
                
       .
         Access  7.    ,  
  :
1.  :  ;
                     ;
                         ;

1.  :   ;
                                         ;
                               ;
                                          ;
                               ;
                               ;
                                SQL ;
3.  
4.   
5.   



    1.  
                  /
  .               .
  OK        .  Access  
    MDB        ,    
 .     ,            
,              .

                                     2.
           .      
      (        
 ).
          DB1.MDB          
  :
       ---       ;
       ---         ;

          SQL      :

        
        
       
        
        
         

               ,  

|    |  |     |   |       |         |
|              |        |              |              |    |    |
|1             |   | λ |100           |1234567       |        |
|              |1            |              |              |              |              |
|2             |   | λ |200           |1234567       |        |
|              |2            |              |              |              |              |
|3             |   | λ |300           |1234567       |        |
|              |3            |              |              |              |              |
|4             |   | λ |400           |1234567       |        |
|              |4            |              |              |              |              |
|5             |   | λ |500           |1234567       |        |
|              |5            |              |              |              |              |
|6             |   | λ |600           |1234567       |        |
|              |6            |              |              |              |              |
|7             |   | λ |700           |1234567       |        |
|              |7            |              |              |              |              |
|8             |   | λ |800           |1234567       |        |
|              |8            |              |              |              |              |
|9             |   | λ |900           |1234567       |        |
|              |9            |              |              |              |              |
|10            | ʻ | |370           |7654321       |      |
|11            |         | |350           |7654321       |      |
|              |˨߻ |              |              |              |              |
|12            |         | ˨ |120           |4442708       |    |
|              |߻   |              |              |              |              |
|13            | λ   | DJ 17   |90            |3458217       |          |
|14            | ͻ| DJ 17   |90            |3458217       |          |


         .  ..  ..
            .
          ,   
 .           .    
     ,      
  :   ,        .  
               
 ,             
   .           
 ,      ,          ,
      .      ,
    .     ,        
 :
*       64 ;
*      ,  ,      
 ,   ,   ,    ;
*       ;
*           ;
              ,      
  :
1.  :       MS Access    
      ,  50.     
 ,     .   - 255  ;
2.   :
-               
 .          MS  Access
         ;
-        ;
-         ,      
     ;
3.    :       .     
       15       
4     ;
                                                    3. 
                .
  ,                
      .
             ,  
  ,                
         ,  
    .
           DB1.MDB    :
       ---    


                       
  .     ,     
  ,       .
|    |  |     |   |       |
|              |        |              |              |    |
|1             |   | λ |100           |1234567       |
|              |1            |              |              |              |
|2             |   | λ |200           |1234567       |
|              |2            |              |              |              |
|3             |   | λ |300           |1234567       |
|              |3            |              |              |              |
|4             |   | λ |400           |1234567       |
|              |4            |              |              |              |
|5             |   | λ |500           |1234567       |
|              |5            |              |              |              |
|6             |   | λ |600           |1234567       |
|              |6            |              |              |              |
|7             |   | λ |700           |1234567       |
|              |7            |              |              |              |
|8             |   | λ |800           |1234567       |
|              |8            |              |              |              |
|9             |   | λ |900           |1234567       |
|              |9            |              |              |              |
|10            | ʻ | |370           |7654321       |
|11            |         | |350           |7654321       |
|              |˨߻ |              |              |              |
|12            |         | ˨ |120           |4442708       |
|              |߻   |              |              |              |
|13            | λ   | DJ 17   |90            |3458217       |
|14            | ͻ| DJ 17   |90            |3458217       |

            /   .    
       .
|    |  |     |   |       |
|              |        |              |              |    |
|1             |   | λ |100           |1234567       |
|              |1            |              |              |              |
|2             |   | λ |200           |1234567       |
|              |2            |              |              |              |
|3             |   | λ |300           |1234567       |
|              |3            |              |              |              |
|4             |   | λ |400           |1234567       |
|              |4            |              |              |              |
|5             |   | λ |500           |1234567       |
|              |5            |              |              |              |
|6             |   | λ |600           |1234567       |
|              |6            |              |              |              |
|7             |   | λ |700           |1234567       |
|              |7            |              |              |              |
|8             |   | λ |800           |1234567       |
|              |8            |              |              |              |
|9             |   | λ |900           |1234567       |
|              |9            |              |              |              |
|10            | ʻ | |370           |7654321       |
|11            |         | |350           |7654321       |
|              |˨߻ |              |              |              |
|12            |         | ˨ |120           |4442708       |
|              |߻   |              |              |              |
|13            | λ   | DJ 17   |90            |3458217       |
|14            | ͻ| DJ 17   |90            |3458217       |

       ---   
        :     14
             .      
   /  .            
  14.     .

|    |||   | |   |
|  |    |       |  |||
|        |  |        |        |      |      |
|1       |    |     |100     |1234567 |  |
|        | ||        |        |        |
|        |1      |       |        |        |        |
|2       |    |     |200     |1234567 |  |
|        | ||        |        |        |
|        |2      |       |        |        |        |
|3       |    |     |300     |1234567 |  |
|        | ||        |        |        |
|        |3      |       |        |        |        |
|4       |    |     |400     |1234567 |  |
|        | ||        |        |        |
|        |4      |       |        |        |        |
|5       |    |     |500     |1234567 |  |
|        | ||        |        |        |
|        |5      |       |        |        |        |
|6       |    |     |600     |1234567 |  |
|        | ||        |        |        |
|        |6      |       |        |        |        |
|7       |    |     |700     |1234567 |  |
|        | ||        |        |        |
|        |7      |       |        |        |        |
|8       |    |     |800     |1234567 |  |
|        | ||        |        |        |
|        |8      |       |        |        |        |
|9       |    |     |900     |1234567 |  |
|        | ||        |        |        |
|        |9      |       |        |        |        |
|10      |   |   |370     |7654321 ||
|        |ʻ ||        |        |        |
|11      |   |   |350     |7654321 ||
|        |˨||        |        |        |
|        |߻   |        |        |        |        |
|12      |   |   |120     |4442708 ||
|        ||˨ |        |        |      |
|        |߻     |        |        |        |        |
|13      |     | DJ |90      |3458217 |    |
|        |λ |17     |        |        |        |


       ---  
        :         
                       .  
    QBE         
.          ,      
 .              
  .                
            /  
   .        OK .
|    |||   | |   |
|  |    |       |  |||
|        |  |        |        |      |      |
|1       |    |     |100     |1234567 |  |
|        | ||        |        |        |
|        |1      |       |        |        |        |
|2       |    |     |200     |1234567 |  |
|        | ||        |        |        |
|        |2      |       |        |        |        |
|3       |    |     |300     |1234567 |  |
|        | ||        |        |        |
|        |3      |       |        |        |        |
|4       |    |     |400     |1234567 |  |
|        | ||        |        |        |
|        |4      |       |        |        |        |
|5       |    |     |500     |1234567 |  |
|        | ||        |        |        |
|        |5      |       |        |        |        |

       ---  
        :              ,  
   ,     ;
               ʔ.  
              /
                
 .
                 
  .           .
        First  .       
        ,             /
   .           
    ,          .
       

|1           |  1      | ""        |100          |1234567            |            |
|2           |  2      | ""        |200          |1234567            |            |
|3           |  3      | ""        |300          |1234567            |            |
|4           |  4      | ""        |400          |1234567            |            |
|5           |  5      | ""        |500          |1234567            |            |
|6           |  6      | ""        |600          |1234567            |            |
|7           |  7      | ""        |700          |1234567            |            |
|8           |  8      | ""        |800          |1234567            |            |
|9           |  9      | ""        |900          |1234567            |            |
|10          | ""        | ""      |370          |7654321            |          |
|11          | "˨"  | ""      |350          |7654321            |          |
|12          | ""    | "˨"      |120          |4442708            |        |
|13          | ""          | "DJ 17"          |90           |3458217            |              |
|14          | ""       | "DJ 17"          |90           |3458217            |              |
|15          | ""          | "DJ 17"          |90           |3458217            |              |
|16          |   | "40     |560          |2042424            |          |
|            |                     |"              |             |                   |                  |
|17          |      | "40     |650          |2042424            |          |
|            |                     |"              |             |                   |                  |
|18          | ""        | ""          |270          |3102902            |        |
|19          | ""   | ""          |270          |3102902            |        |
|20          | ""         | ""          |270          |3102902            |        |
|21          | "" | ""     |70           |4484476            |            |
|22          | ""   | ""     |78           |4484476            |            |
|23          | ""          | ""          |56           |2564132            |             |
|24          | ""          | ""          |34           |2564132            |             |
|25          | ""      | ""        |399          |5678493            |           |
|26          | ""         | ""          |456          |8769021            |              |
|27          | ""      | " "  |234          |5555555            |               |
|28          |               | ""         |190          |3333333            |            |
|29          |           | ""         |1000         |6379210            |            |
|30          |             | ""     |2000         |3892010            |       |
|31          |               | ""           |2500         |9854731            |           |

                            
|      |   |    |           | |    |
|1               |  1      |70               | ""          |9876543           |              |
|2               |  2      |120              | ""          |9876543           |              |
|3               |  3      |290              | ""          |9873456           |              |
|4               |  4      |387              | ""         |4567389           |             |
|5               |  5      |429              | ""          |4876432           |             |
|6               |  6      |555              | ""           |4446329           |             |
|7               |  7      |691              | ""           |4446329           |             |
|8               |  8      |789              | "-2"        |5919276           |           |
|9               |  9      |899              | "-2"        |5919176           |           |
|10              | ""        |366              | "" |1238700           |              |
|11              | "˨"  |350              | ""         |7865644           |        |
|12              | ""    |110              | ""         |8746523           |              |
|13              | ""          |79               | ""         |5654838           |             |
|14              | ""       |90               | ""         |5654836           |             |
|15              | ""          |18               | ""         |5653648           |             |
|16              |   |532              | ""            |7574653           |              |
|17              |      |645              | "-2"          |5865973           |             |
|18              | ""        |170              | ""            |1111111           |             |
|19              | ""   |204              | ""       |2222222           |          |
|20              | ""         |143              | ""          |3333333           |Ѩ       |
|21              | "" |25               | ""          |7654321           |             |
|22              | ""   |58               | ""          |7654321           |             |
|23              | ""          |55               |          |1453567           |             |
|24              | ""          |12               |                |3759080           |            |
|25              | ""      |287              | ""          |8790000           |            |
|26              | ""         |444              | ""          |8790000           |            |
|27              | ""      |234              | ""         |6666666           |             |
|28              |               |123              | ""         |6666667           |             |
|29              |           |876              | " "   |9000000           |           |
|30              |             |1974             | ""       |4328677           |           |
|31              |               |1890             | ""       |8888888           |             |


                           
|  |    |1|
|100          |70               |30        |
|200          |120              |80        |
|300          |290              |10        |
|400          |387              |13        |
|500          |429              |71        |
|600          |555              |45        |
|700          |691              |9         |
|800          |789              |11        |
|900          |899              |1         |
|370          |366              |4         |
|350          |350              |0         |
|120          |110              |10        |
|90           |79               |11        |
|90           |90               |0         |
|90           |18               |72        |
|560          |532              |28        |
|650          |645              |5         |
|270          |170              |100       |
|270          |204              |66        |
|270          |143              |127       |
|70           |25               |45        |
|78           |58               |20        |
|56           |55               |1         |
|34           |12               |22        |
|399          |287              |112       |
|456          |444              |12        |
|234          |234              |0         |
|190          |123              |67        |
|1000         |876              |124       |
|2000         |1974             |26        |
|2500         |1890             |610       |



                                             
       ,      ,      Access  7.
    .         
            
Access.
                           
      ,  .          
      .
             ,     Access      
           
   .            
 /,       
    ,   ,      
         ,      
.



                           

       1.  
       Microsoft Access 2.0
          . . 
          1996 

       2.  
       Microsoft Access 7.0 FOR WINDOWS 95 (STEP BY STEP)
             1998 .




" "