(. 1) :
4 - 1:n n- , , . . n- .
6 - m:n, : . . , - .
1
, , | ||
, | ||
, | ||
,... | ||
, , | ||
, , |
, , . , .
, .
, , .
(. 2).
2
, , , , , | ||
, , /, | 3 | |
,, , , | ||
, , , , | 3 | |
, , , | ||
, , , |
2 (. 3)
. 3
, ; , ; ; ; .
|
|
:
SELECT .[ ], ., ., ., ., .
FROM ;
:
SELECT .[ ], ., ., ., .
FROM
WHERE (((.)=""));
:
SELECT [ ].[ ], [ ]., [ ]., [ ]., [ ]., [ ].
FROM [ ]
WHERE ((([ ].)=""));
:
SELECT .[ ], ., ., ., .
FROM ;
:
TRANSFORM Max(.) AS [ ]
SELECT .[ ], .
FROM
GROUP BY .[ ], .
PIVOT .;
:
SELECT .[ ], .[ ], [ ]-[ ] AS [ ], .[ ], ., [,]*[ ] AS , .[,], Month([ ]) AS , .[ ]
FROM INNER JOIN ON .[ ] = .[ ];
:
SELECT ., ., ., .[ ], [ ].
FROM INNER JOIN [ ] ON .[ ] = [ ].[ ];
:
SELECT .[], .[], .[], .[], .[]
FROM
WHERE (((.)="") And ((.)>3));
:
TRANSFORM Sum(.[ ]) AS [Sum- ]
SELECT ., Sum(.[,]) AS [Sum-,]
FROM
WHERE (((.[,]) Is Not Null))
GROUP BY .
PIVOT .[,];
:
TRANSFORM Min([_ ].) AS [Min-]
SELECT [_ ]., Sum([_ ].) AS [ ]
FROM [_ ]
GROUP BY [_ ].
PIVOT [_ ].[ ];
:
DELETE .[ ]
FROM
WHERE (((.[ ])=[ ]));
MS Office Access (. 4)
. 4
. 5
. 6
. 7
λ, . ER- , . , MS Access 2007 .
|
|
.