,
! "
# ! $ # % & '(
)
( , *+ ) ) ) 080100 080500)
2010
,
_______________________
:
. ., ., . .
! ". , ., . #.
! .$., # #
%.&., ., . .
'() 681.140
, . . . : *. %-
+ + + *# + * -
+ * / . . , ". . !, .$. ! –
: . . . - , 2010. – 230 .
, + , -
+ # # + «- » (080100)
«% .» (080500), *# + / # -
* + * * # *
Microsoft Access Microsoft Excel.
.101. 0. 14 1. 3 . , +
©*
, 2010
©. . , ". .!, .$.!, 2010
2
| ,-.-/ / |
|
| ........................................................................................................... | 5 |
| - 01. # MS EXCEL ....................... | 7 |
| - 0 2. $ 1 # %' |
|
| . MS Access .................................................................................................. | 37 |
| - 0 3. 2 ) ................... | 66 |
| - 0 4. 2 ......................................... | 74 |
| - 0 5. 3 1.............. | 79 |
| - 0 6. 2 ............................................ | 86 |
| - 0 7. % ) ........................ | 93 |
| - 0 8. % ) )) |
|
| ................................................................................... | 101 |
| - 0 9. ))............................ | 108 |
| - 0 10. 2 )............................ | 116 |
| - 0 11. 2 ............................. | 123 |
| - 0 12. 2 .............................. | 132 |
| - 0 13. 2 )........................... | 135 |
| - 0 14. % ) ........................... | 139 |
| - 0 15. % ) 4 |
|
| 5............................................................................................. | 146 |
| - 0 16. ................................................. | 152 |
| - 0 17. $ |
|
| .......................................................................................................... | 157 |
| - 0 18. 3 ............. | 161 |
| - 0 19. 1 ) ) 6 |
|
| ) VBA ......................................................................................... | 168 |
| - 0 20. . |
|
| $ 1................................................................................. | 177 |
| - 0 21. 7 ) – ) ................... | 182 |
| - 0 22. $ MS WORD........................... | 185 |
3
| - 0 23. ) 5 |
|
| ) ..................................................................................... | 193 |
| - 0 24. # ) ) )............. | 202 |
| - 0 25. ) ) |
|
| .......................................................................................................... | 206 |
| - 0 26. & ) ) |
|
| VB............................................................................................................ | 214 |
| - ................................................................................................. | 222 |
| 2 6 ............................................................................................... | 223 |
4
../&/ /
2 # * * -
# * +:
•-# *, # * + # # +
. *# , , . -
* , # * #-
+ *# + . * + *;
•-*, , # #
# # # # + «- » «% .». " * *
* # * + # #
* * # ;
•- , # + Microsoft Office 2007, - +, *# + * # * / +, * + +
.
, # * # * -
+ + * Microsoft Office 2007. *
# ., # #
# # +, # # +.
# + # * #-
+ * Microsoft Excel 2007, *
* *, #, # * + *#-
+ # + * Microsoft Access 2007. , ++ + *# + + #-
+ Visual Basic.
, * * # +/ * *
* *, . * * # -
# . *# -
* +, . +
+ + + # . # * /. 0 , # *#-
5
+ * # + # -
+ *. # + * -
, *# + * MS Access 2007, # *
# # # + +.
6
-# ! 8 # ! 01. # %' & '( . MS
EXCEL
3 * – # + * # +
* * * *
* – , * * # # -
, ## * * # . *
# ## * *.
# - 4 , #-
* (* *).
* * * * + , * - * – . ) . # * * +,
# + # + *. #
# .
0 * # + # + *. ,-
, # + + * *,
. * #. ( + # #
* * [.
*+ )].
) /el
1.1 * # + *, .
* *, . . # # +,
* + + * #.
2., + * # + + +
# *. + # + . * # . #
+. ( + * # . * * .
3.2 + * * . *
* , * * *.
4.# # + * . * *
( *, *, *).
5.* . * # *
.
7
2 )
* -
, 1 *# +
# *. 2 # -
* . * .
( + * # * «(», +
* # «!»
+ # #+. MS Excel 2007 + #
* . # # «!»
«5 +» «6 +…» ( -
«!»).
1-
8
)
!
) - , # * + + *
# # +. ( + *, Excel , # + -
+ ., # *.
| %. | # [.] + * + | ||||
| # +: | [.]=[9]*["- ] | ||||
|
|
|
|
|
| |
| + | F2 |
| =/2*D2 | # | |
| * + # +: | F3:F22 | ||||
|
| " # $ | ||||
| $ – | # . # * * #- | ||||
| # +. |
|
|
|
|
|
| %. | " * , * #- | ||||
* # . * # +.
( + , * MS Excel 2007 -
:
•# # * (+ , * -
*),
•[&] – [ $ ],
•$ ) * #, #
# + ( 2),
•* # + - 8 ( -
) 8 ( ) -
*.
•+ * * # + * # +: -
.
. *# + + # # +.
+ # # * # # +,
* # # + + # # + # +, # *
9
+ # + *# + + # # -
# . .
( + + . # + +
# # & .
2-
# # # %
# %
%. * * * #, * *
1000. ( + , * * * #, -
/ # , :
•# # * (+ , *
*).
•[&] – [ ].
, . # u +
+ *. 7 / * #
# +, # + -[.] ( 3).
10
Нет комментариевНе стесняйтесь поделиться с нами вашим ценным мнением.
Текст