:

:


, .


:


:

..

:

.


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

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

. .. ..

.

, . . , : , . , . , , , . , . , :

* 64 ;

* , , , , , ;

* ;

* ;

, :

1. : MS Access , 50. , . - 255 ;

2. :

- . MS Access ;

- ;

- , ;

3. : . 15 4 ;

3.

. , .

, , , .

DB1.MDB :

---


. , , .

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


/ . .

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


---

: 14

“”. / . “ ” 14. .


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

---

:

. QBE . “ ” , . “ ” . “ ” / . OK .

1

1

λ

100

1234567

2

2

λ

200


1234567

3

3

λ

300

1234567

4

4

λ

400

1234567

5

5

λ

500

1234567


---

: , , ;

“”. “ ” / “ ” “” .

“ ” “” . “ ” . “First” . , / . “ ” “ ” , “ ” . “ ” “”


""

""

"-2"

""

""

""

""

""

""

""

""

""

""

""

""

""

""

"-2"

""

" "

""





















""


""















""




"˨"




"˨"



















""




"40 "





















""







""











""





""





""


















""





""


















"DJ 17"




""



















""






















""










3

4


6

1



5



8



""






















""








""

""



""











" "
















""







""





















---

: , ;

. / “ ” . “” “Sum”

4.

. , . , . , “” . , - .

. : “ ”, , .

“ ”. . “”.

. , , , , . , . , , , , .

. , .

. () . , . .

5.

, . , “” “” ().

, , .

:

--- . , , . . .

.

6.

Access , .

- . , “” - “” .Access . , .

: “” . , , “” Access “ ”. . , . , .

: . “”, “”. “ ”, , “”. , “” “” .

, Access , , .

, .

. . , , . . .

: , (

“” - “”. Access “”. “” - . “ ” “ ” - . , .

“AutoExec”; “ ”.

AutoExec-, [Shift]”.


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 .


17



 
2012 , , .