. .
~ ~
 









-











 


, .

:

:

..

:

.

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 .












© «»