1. Access. 2
1. ... 2
2. .. 2
3. ... 3
4. .. 4
5. ... 4
2. SELECT SQL. . . 4
1. ... 4
2. Access. 4
3. ... 7
4. .. 8
5. .. 8
6. ... 8
3. SELECT SQL. . JOIN. 8
1. ... 8
2. ... 9
3. .. 10
4. .. 10
5. ... 10
4. Microsoft Access. 10
1. ... 11
2. Access. 11
3. ... 11
4. .. 23
5. ... 23
5. ERwin.. 23
1. ... 24
2. ... 24
3. ... 33
1. Access.
, , .
, () . . : _ [1], , , . , . : _, , . ( ). : _, , . , . . , , . : , _, _, , .
:
3.1. . .
3.2. .
3.3. \ . . . --. , . (. .)
|
|
3.4. ( 20 , 5 , 5 , 20 ).
, , , . MS Access (*.mdb)
5.1. ?
5.2. ?
5.3. ?
5.4. ?
2. SELECT SQL. . .
SELECT Microsoft Jet SQL, Access 2 .
Access
Access SQL . :
-
- SQL.
, SQL .
Access:
2.1. . .
2.2.
2.3. , SQL
2.4. SQL-.
2.5. , .
3.1. :
SELECT FROM WHERE =< _ >;
3.2. , :
SELECT DISTINCT ., . FROM , , WHERE ._=._ And ._=._ And .="< _ >";
3.3. , :
SELECT ., . FROM , , WHERE ._=._ And ._=._ And .="< _ >";
3.4. , :
SELECT count( * ) FROM , WHERE ._=._ And .="< _ >";
3.5. , :
|
|
SELECT sum( . )
FROM ,
WHERE ._=._ And .="< _ >";
3.6. , :
SELECT ., count( * )
FROM ,
WHERE ._=._
GROUP BY ;
3.7. , :
SELECT ., count( * )
FROM , ,
WHERE ._=._ And ._=._ And .="< _ >"
GROUP BY .;