: ,
ss.
: 2 .
:
1. Access.
2. . ().
3. . .
4. , . . .
5. . .
6. : _, , , , _, . , _, . .
7. (. . ).
8. . .
9. . 48 : _, , , , _, _.
10. 2- , .
:
- . ;
- . ;
- _
_ ;
- :
) ;
) ;
) .
. , (
2- ).
. 1.
11. :
- ;
- . ;
- , . ;
- 11 - . Enter. ;
- .11 ;
- , , .
12. , . , . . , . . . . . , .! . :
12.1. (. Like *)
12.2. > 80 . (. >80)
12.3. (. Like *)
12.4. > 70., < 180.
12.5. , 70-80. (. Between 70 AND 80)
12.6. 20- (. < #01.01.97#).
13. .
|
|
|
, , , _, . . . . . . . . . , , _ . .! , . . .
3
: .
: 2 .
1. .
1. , , , , . : , .
2. Access. -> .
3. .
4. ( 2.).
.2
5.
3.
6. , .. . , .
.4
7. .5
.5
8. , , . ( .6 _. , ).
, , . , , , (.6).
.6
9. , (.). , .
|
|
|
.7
2.
1.
2. , .
3.
4. , .8
.8
3.
1. .
2.
3.
4. .
5. 10 .
6. 8 .
7. 30 .
1. Access ?
2. ?
3. ?
4. ? ? ?
5. ?
6. ?
7. ?
8. ?
9. ?
10. ?
11. ?
12. ?
13. ?
4
:
v SQL
Ø .
Ø
v
Ø ,
Ø
Ø
: 2 .
, , :
1. .
2. . .
3. , .
4. .
5. .
6. , .
7. .
8. 30% ( )
9. , ( )
10. ( , )
11. ( )
12. - ( ).
1. .
:
, .
.
, .
.
SQL
SELECT;
SELECT ;
SELECT .__, ., .[ ]
|
|
|
FROM INNER JOIN ( INNER JOIN ON ._ = .) ON ._ = ._
WHERE (.=[ ]);
. .
.
. .
, .
2. . .
, .
.
, .
.
SQL
SELECT;
SELECT ;
SELECT .__, ., .[ ]
FROM INNER JOIN ( INNER JOIN ON ._ = .) ON ._ = ._
WHERE (((.[ ])="."));
. ..
.
, .
3. , .
, .
.
.
SQL
SELECT;
SELECT ;
SELECT .__, ., .[ ]
FROM INNER JOIN ( INNER JOIN ON ._ = .) ON ._ = ._
WHERE ((.[__])=[ ]);
. .
.
. .
, .
4. .
, .
.
, .
.
SQL
SELECT;
SELECT ;
SELECT .__, ., .[ ]
FROM INNER JOIN ( INNER JOIN ON ._ = .) ON ._ = ._
WHERE ((.[ ])=[ ]);
. .
.
|
|
|
. , .
, .
5. .
:
, .
.
, .
.
SQL
SELECT;
SELECT ;
SELECT .__, ., .[ ]
FROM INNER JOIN ( INNER JOIN ON ._ = . ) ON ._ = ._
WHERE ((Year(Date())-Year([_]))=[ ] );
: : YEAR(DATE())-YEAR[_].
[ ].
. .
.
, .
6. , .
, .
.
, .
.
SQL
SELECT;
SELECT ;
SELECT .__, Count (.) AS [- ]
FROM LEFT JOIN ON ._ = ._
GROUP BY .__;
. .
.
, .
7. .
, .
.
, .
.
SQL
SELECT;
SELECT ;
SELECT .__, AVG (.) AS [ ]
FROM LEFT JOIN ON ._ = ._
GROUP BY .__;
. .
.
, .
8. 30% ( )
, .
.
, .
.
SQL
UPDATE;
UPDATE ;
UPDATE SET . = .*1.3
WHERE .=5;
. .
.
. .
, .
9. , ( )
, .
.
, .
|
|
|
.
SQL
DELETE;
DELETE ;
DELETE FROM WHERE .=9;
. .
.
. .
, .
10. ( , )
, SQL
SELECT *
FROM
WHERE .=[ ];
st.
, , , :
-. . . .
. - st. .
, . _. .
_ .
. .
11. ( )
10 ST. :
. ST
. _ _.
, .
. .
SQL
12. - ( ).
,
, , - -.
, , , . .
, . . .
.
, SQL, SQL. .
.
SQL:
1. 10 .
2.
3. . .
4. . .
5. .
6. ?
7. ?
8. .
9. 10 ?
10. , ?
11. Access.
:
- .
, . .
1. ?
2. ?
3. ?
4.
5. ?
6. ?
7. ?
8. ?
9. ?
10. ?
11. , ?
12. ?
1. .. . Windows 2000, Word, .: : -, 2010.
2. Excel. .: , 2009.
3. . . .: , 2005.
4. .. . .: , 2004
5. .. Microsoft Access 2003. . .: , 2005.
6. .. Windows . .: -, 2007.
