|
|
|
??????? 3
??????? ???? ???? ?????? ?? ??????????? ???????. ?? ?????? ??????? ???????????? ?????? ? ????????? ???????????? ? ??????? ???????? ????: “ ???????????? ??????”, “???????”, “????? ???????”; ?????????????: ?????????? ??????? ?? ???? “???????????? ???????”, ?????????? ???????? ? ???? “????? ???????”: “???? ?? ???????” ? “???????????”, ?? ???? “???????”: “???????????” - “???????????”, ???????? ?????????? ?? ????? “???????”, “????? ???????”: ??????? ????? ??? ????? ????? ??????? ? ??????? ???? ??????, ??? ???? - “? ???? ???????”; ??????? ????? ?? ??????????? ???????, ??? ?????? “? ???? ???????”, ? ?????? ????????????? ?????????? ?????? ?? ???? “?????”; ??????? ?????? ? ???? ?????? ??????, ????????????? ?????? ??? ????? ??????? ? ??????? ???? ?????? ? ????????? ??????????? ???????.
???????
?????????????-??? ??????????? ??????? (???.)???????-???? (??.)???????-???? (??.)??????? (??.)????? ??????? (???.)06.01.99?????????25048045006.01.99??????38015015022.02.99??????65808006.01.99????70605506.01.99???????9835030022.02.99?????????25040040023.03.99??????65606019.03.99?????????25035038022.02.99??????38018018023.03.99???????98280260 ????? :
?????????? ???????.
???????? ???? ???? ??????. ??? ????? ??????? ???????? ACCESS. ????? ????, ??? ?? ?????? ?????????? ???? ??????? ??????????????? ?????? “????” ? “???????” ? ??????????? ?????????? ???? ?????? ???? ? ??????? , ?? ??????? ????? ??????? ???? ???? ?????? ? ???????? ??? ????? ???? ?????? ? ????? ?????? PRO_DT (?????????? MDB , ????? ????????? ????? ????????????? ????? ??????????). ??? ???? ????? ?????? ? ??????? ?? ???? ???? PRO_DT.MDB.
?????????? ??????? ??????. ??? ????? ? ????????? ?????????? ???? ?????? ??????????????? ?????? “???????” ? “????? ???????” ??? ???? ??????????? ?????????? ???? ???????????? ????????? ????? ???? ??????.
????????? ????. ??? ????? ???????? ??????? ???? ??? ? ????????? ??? ????????????? ?????? ? ?? ???????? ????????. ???????? ?? ??????? ????????? ??? ??????? - “??????_????????????”
?????????? ??????????? ????? ? ???? ???????:
????????????? ????????? ?????????? ???????????? ????????? ?????????????\???????????? ?????? ????99.99.00;0????????????
????????????????30????
???????????????????????????
???????????
????????? ????????? ?????? 8 ??.????
???????????
????????? ????????? ?????? 8 ??.??????????? ????????, ??? ??? ??????????? ?????? ????????? ???????, ???? “????????????” ????? ????? ????? 9 ????????, ?? ? ???? ??????, ??? ???????????? ?????? ? ????? ??????? ????????????? ??? ????? ?? ???????????, ??????? ????? ???? ??????? 30 ????????.
????? ???????? ??????????? ? ??????? ?????? ? ???????? ??????????? ????, ?? ?????? ?????????? ???? ???? ??????. ????? ??????? ?? ??????? “???????” ???????? ?????? ??????? ???? ? ????????????? ?????. ???????? ???????. ??? ???? ?????? ????????? ? ??????? ????? ????????? ? ????? ???? ?????? PRO_DT.MDB.
?????? ?????????? ???????? ? ???????.
???????
ACCESS???????? ????????????????????? ????????????
ACCESS????? ??????? ???? “????”, “???????”?????????? ???? ????????? ???????????? ????????? ????? (????)????????? ????? ????? PRO_DT.MDB?????????? ???? ?????? ?????, ??????? ? ???? ???? ?????? (???)??????????????????? ????? ?????? “???????”, ”????? ???????”??????? ? ???? ???????????? ????????? ??????? (????)???????? ???? ?????, ????? ???? ?????? ? ????????? ?????????????? ?????????????? ????????? ????? ???????, ?????????? ????? ???????, ??????? ?
???? ???? ?????? (???)?????????? ?????? “???????”, ???? ?????? ? ??????????????????? ??????? ???? ?????? ? ???????? ???????????.
?????????? ??????. ??? ?????, ???????? ? ???? ???? ?????? ?????? ??????????????? ?????? “??????” ? “???????”. ? ??????????? ?????????? ???? “???????? ???????” ?????? ?????? “????? ??????”. ??? ??? ? ????? ???? ?????? ??????? ?????? ???? ???????, ?? ? ??????????? ?????????? ???? ?????? ??????? ??? ???????? ??????? ??????????????? ?????? ?????? “????????” ? “???????”. ? ??????????? ???? ???????????? ????????? ??????? ???????? ????????? ????????:
? ?????? ?????? “????” ????????? ???? “???????????? ???????”.
? ?????? ?????????? ???? “???????????? ???????” ? ?????????????? ???? ???????? “?? ???????????”.
???????? ?????????????? ???? “???????”. ??? ????? ?????????? ?????? ? ????????? ??????? ?????? ?? ???? “???????????? ???????” ? ?????? ????????? : “???????: ??????????? - ???????????” ????? ??????? ????? ??????? ????? ???? “???????” ????? ???????????? ?????? ?? ???? “???????” ? ????? ?????? ??????? ???? ??????? ? ??????????? ???? ????? “????????”. ? ??????????? ?????????? ???? ??????? ???? ? ?????? ?????? ???? ????????????? ?????????????? ???? ??????? “????????” ? ?????? ??? ????????.
?????????? ????????? ?????????????? ????” ????? ???????”. ?????????? ?????? ? ????????? ??????? ?????? ?? ???? “???????”. ?????? ????????? “????? ???????: ???? ??????? * ???????????” ???????? ?????? ?? ???? “????? ???????” ? ????? ?????? ??????? ???? ??????? “????????” ? ????????? ??? ?????? ??? ?????? ???? ??? “????????”
??? ?????????? ???????? ????????? ?????????? ?????????? ????????? ????????:
??? ??????????? ?????? ?? ???? “”???????” ??????? ?? ???? “ACCESS” ????? “???”. ????? ??????? ????? “????????? ????????” ? ???? ???????????? ????????? ??????? ???????? ?????? “????????? ????????”. ? ???? ?????? ? ???? “???????” ?? ??????????????? ???? ??????? “SUM”.
??? ??????????? ?????? ?? ???? ”????? ???????” ??????? ?? ???? “ACCESS” ????? “???”. ????? ??????? ????? “????????? ????????” ? ???? ???????????? ????????? ??????? ???????? ?????? “????????? ????????”. ? ???? ?????? ? ???? “????? ???????” ?? ??????????????? ???? ??????? “SUM”.
??? ???????? ???? “??????” ??????? “??” ?? ?????? “????????? ????????? ???????” ? ???????? ??????? ??? “?????? ??????”
?????? ? ??????? ???????? ???????? ?? ???????? ???????.
???????
ACCESS???????? ????????????????????? ???????????? ????
?????????????????????? ??????? ?????? “?????? ? “???????”?????????? ???? ???????? ??????? (????)?????????? “????? ??????”?????????? ???? “?????????? ???????” (????)????????? ???????? ??????? ?????? “????????, ???????”?????????? ???? ???????????? ????????? ??????? (????)????????? ????? ???????, ??????? ??????????????????? ??????? ??????? (???)???????????
???? ????????? ????? ???????, ???????? ?????????????? ??????????? ?????, ?????????????? ??????.????????? ??????? ??????? (???)????????
???????
????????? ????? ???????; ???? ACCESS - “???” ”????????? ????????”, ??????????? ????? ????? “SUM”????????? ??????? ??????? (???)??????????? ?????, ?????????? ????? ??????????????????? ??????? ???????.
???????? ????? ??? ????? ????? ??????? ? ??????? ???? ??????.
??? ???????? ????? ??????? ???? ???? ??????. ????? ??????????????? ?????? ?????? “?????” ? “???????”. ?? ?????? ???????? ?????????? ???? “???????? ?????”. ? ???????????? ??????? ????????? ?????? ? ???????? ( ???? “????? ???????\???????”) ??????? ????????? ??????? “??????_????????????”.
1 2 3
|
|
|
|
 |
Íà ñàéòå: |
, ,
|
