. .
o - , . , . . 0.
o . , . . , . 255.
o - . , . . , . 255.
o - . , . . , . 255.
o . , . .
o . - , .
o - . , . . , . 255.
o , . , . . 0.
o - - . , . . , . 255.
o - . , . . , . 255.
o - . , . . , . 255.
o -mail , Microsoft Office Outlook. , . . , .
o , . , . . , .
o , . , . . 0.
|
|
o - . , . . , . 255.
o . , . . , . 255.
o - . , . . , . 255.
o -mail , Microsoft Office Outlook. , . . , .
o , . , . . , .
/
o , . . .
o , . .
/
o , . . .
o , . .
o , . , . .
o . , . . , . 255.
o . : #.##" ";0;*
o . : ##"";;*
o - . : ####"";;*
o - . : ####"";0;*
o . 0. : - ( - ). :
o - . , . . , . 255. : (, , ..)
SQL
SQL , , , , .
SQL Microsoft Access ( ), Microsoft Access , SQL. , , , , ( ) . , , Microsoft Access "" SQL.
|
|
Microsoft Access. . , .
, .
" SQL" :
, , (. . 7.1),
,
- .
. 7.1 SQL
SQL, . , , , - .
, SQL , . - , , , . , .
Microsoft Access SQL , SQL, , , , , SQL.
, .
SQL
, , . , Microsoft Access "" , , .
, .
< >
, . , .
[ ]
, " " |.
{ }
, .
...
, .
SELECT. , . SELECT < > :
- FROM < >
- [WHERE < >]
- [GROUP BY < >]
- [HAVING < >]
- [ORDER BY < >]
, Microsoft Access, : TRANSFORM ( ), IN ( ), DISTINCTROW ( - ), WITH OWNER-ACCESS OPTION ( , , , ).
|
|
, :
[+|-] { | () | |_}
[{ + | - | * | / | \ | ^ | MOD | &} { | () | | _} ]...
SQL, , AVG, COUNT, MAX, MIN, STDEV, STDEVP, SUM, VAR VARP. , Microsoft Access Access Basic.
SQL, (, , ).
- . . . , , #.
() .
: , FROM . Microsoft Access , . , [ ].[ 1]
" " - .
1) :
1 .
SELECT .[ ], .[ ], .[ ], .[ ], .[ ], Year(Date())-Year([]![ ]) AS
FROM
WHERE (((Year(Date())-Year([]![ ]))<=1));
.
SELECT .[ ], .[ ]
FROM
WHERE (((.[ ])=[ ]));;
.
SELECT [ / ].[ ], .[ ]
FROM [ / ] INNER JOIN ON [ / ].[ ] = .[ ]
WHERE ((([ / ].[ ])=[ ]))
GROUP BY [ / ].[ ], .[ ];
.
SELECT [ / ].[ ], .[ ]
FROM INNER JOIN [ / ] ON .[ ] = [ / ].[ ]
WHERE ((([ / ].[ ])=[ ]))
GROUP BY [ / ].[ ], .[ ];
.
SELECT .[ ], .[ ], .[ ]
FROM
WHERE (((.[ ])=[ ]));
2)
|
|
UPDATE SET
WHERE (((.[ ])=[ ]));
UPDATE SET
WHERE (((.[ ])=[ ]));
3)
.
DELETE .[ ]
FROM
WHERE (((.[ ])=[ ]));
. , , , , , , .
, Microsoft Access.
, SQL , , , , .