-



, .

:

:

..

:

.

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 .



© 2010

.