364 , , : , , , , , , . , , , .
:
364150
(304)
(123)
(23)
(113)
(4)
(4814)
(5227)
(2616)
(3423)
(4214)
(1518)
(68)
- (2836)
(8269)
(50)
(50)
(762)
(2)
(5275)
(30)
(1222)
(43)
(20403)
(465)
(19)
(108)
(173)
(96)
(899)
(54)
(34)
(476)
(106)
(62792)
(3562)
, (6444)
(2165)
(21320)
(766)
(64)
(3145)
(60)
(17)
(588)
(1000)
(106)
(48)
(3)
(1167)
(8485)
(537)
: (2044)
(11657)
(532)
(21)
(7985)
(3721)
, (10549)
(88)
(58)
(36)
(2257)
(12491)
(91)
(797)
(1338)
(24)
, (214)
(1141)
(3)
(8)
(21697)
(7850)
(3801)
(682)
, (2881)
(475)
(1)
, (7100)
(8694)
, (4121)
(443)
(952)
(2967)
(23)
(748)
(4876)
(95)
(107)
(7)
(2004)
(15)
(663)
(240)
(39)
(25)
(624)
(16)
(2652)
(136)
(90)
(406)
(95)
(24)
(3463)
(4482)
(7216)
(4592)
(5386)
(3)
(2244)
(23)
(29)
(35)
(4517)
(20645)
- (666)
(119)
(2573)
(889)
(288)
(148)
, (1140)

:

:
:
: 23:07:38 02 2005
: 83 : 2 : 0 : 0 :    

, .

:

:

..

:

.

1998

3

4

4

6

10

10

11

13

15

16

.

. . . Access 7 .

. , .

. Microsoft Access 7. . .

.

Access 7. , :

1. : ;

;

;

2. : ;

;

;

;

;

;

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

/
:
? : letsdoit777.blogspot.com
21:59:08 18 2016
9000 " "? : business1777.blogspot.com ! C !
12:15:53 24 2015

, :



, ?

, .
, .
, .
, .
, .



(150759)
(1839)
Copyright 2005-2016 BestReferat.ru bestreferat@mail.ru

@Mail.ru