Excel ACCESS

: ,

: [1]   Word-212439.doc : 1

MS Excel


Microsoft Excel ( Microsoft Office Excel) - , Microsoft Microsoft Windows, Windows NT Mac OS. - , , Excel 2008 Mac OS X, VBA (Visual Basic ).Microsoft Excel Microsoft Office Excel .

Excel Visual Basic (VBA). . '- . (). , .

Excel . Excel 400 , , , ' , , . : , , , . , Excel, " - , . , , , , , " .

. , . Excel - . , , . -.

Microsoft Excel : .

Microsoft Excel , . , '.

, , . .

. . .

Microsoft Excel , :

  1. , , , , .
  2. - . () (), - .
  3. - 6 , , , , , , .
  4. - - Excel ( 100 ). . .
  5. . , ( , , ) : , , , ; , ..
  6. - ! , (), (), , () () , (), () (), , (), (, ) ().
  7. - , ( , ), , , , , .
  8. - ( - , - , - ), , () () ..
  9. - EXCEL, .

. MS ACCESS


() - , .

:

  • ' ( );
  • ' ;
  • , ;
  • ( , ).

:

  • , ', ,
  • , , , - ,
  • , ,
  • ( ), .

Microsoft Office Access - Microsoft. , ' , ' . VBA, Access , .

MS Access:

  • ;
  • ;
  • SQL- ( SQL MS Access ANSI);
  • , .

VBA, MS ACCESS " .

MS Access - . , , , , .

MS Access ' : "' ֻ (' ) " ( SQL, "Ի ). MS Access - MS SQL Server. " MS Access .


1


, 1+1 1 . . 100000 . 8%. .


%

.

./.


  1. EXCEL.
  2. ", " , ". 3 : = (C3*D3>100000; C3*D3*(1-0,08); C3*D3). 4-12 .
  3. F3 : "=E3/$E$13*100. F4-F12 . , .1.


.1 -

% (.2).


.2 -


.3 -


2 ( )


:



  1. EXCEL.
  2. A, B, C X. (Y) 7 : =( (1,2*$A$7+$C$7*ABS (LN(D7)))/(2*$B$7))*EXP(D7). 8-19 . , .3.


.4 -


  1. (.2).


.5 -


.6 -


3 ( )


x, A, B C , .


  1. EXCEL.
  2. x, A, B C. F10 : = ((E10>0; B10=0); (E10; B10)* (C10*E10)+D10* (E10; C10); ((E10=0; ((B10>0; B10<1))); (C10; 2)+ (D10; 2)+B10; (E10; 2)+EXP (B10+E10)+ (C10; D10))).
  3. . , .1.


.7 -


  1. 1 , . .2 .


1 -

A

B

C

X

Y

1

1

2

2

= ((E10>0; B10=0); (E10; B10)* (C10*E10)+D10* (E10; C10); ((E10=0; ((B10>0; B10<1))); (C10; 2)+ (D10; 2)+B10; (E10; 2)+EXP (B10+E10)+ (C10; D10)))

0

2

3

-1

= ((E11>0; B11=0); (E11; B11)* (C11*E11)+D11* (E11; C11); ((E11=0; ((B11>0; B11<1))); (C11; 2)+ (D11; 2)+B11; (E11; 2)+EXP (B11+E11)+ (C11; D11)))

3

4

1

0

= ((E12>0; B12=0); (E12; B12)* (C12*E12)+D12* (E12; C12); ((E12=0; ((B12>0; B12<1))); (C12; 2)+ (D12; 2)+B12; (E12; 2)+EXP (B12+E12)+ (C12; D12)))

1

3

2

0

= ((E13>0; B13=0); (E13; B13)* (C13*E13)+D13* (E13; C13); ((E13=0; ((B13>0; B13<1))); (C13; 2)+ (D13; 2)+B13; (E13; 2)+EXP (B13+E13)+ (C13; D13)))

3

2

1

1

= ((E14>0; B14=0); (E14; B14)* (C14*E14)+D14* (E14; C14); ((E14=0; ((B14>0; B14<1))); (C14; 2)+ (D14; 2)+B14; (E14; 2)+EXP (B14+E14)+ (C14; D14)))

0

0

0

1

= ((E15>0; B15=0); (E15; B15)* (C15*E15)+D15* (E15; C15); ((E15=0; ((B15>0; B15<1))); (C15; 2)+ (D15; 2)+B15; (E15; 2)+EXP (B15+E15)+ (C15; D15)))

2

3

3

2

= ((E16>0; B16=0); (E16; B16)* (C16*E16)+D16* (E16; C16); ((E16=0; ((B16>0; B16<1))); (C16; 2)+ (D16; 2)+B16; (E16; 2)+EXP (B16+E16)+ (C16; D16)))

3

2

4

0

= ((E17>0; B17=0); (E17; B17)* (C17*E17)+D17* (E17; C17); ((E17=0; ((B17>0; B17<1))); (C17; 2)+ (D17; 2)+B17; (E17; 2)+EXP (B17+E17)+ (C17; D17)))

0

1

4

1

= ((E18>0; B18=0); (E18; B18)* (C18*E18)+D18* (E18; C18); ((E18=0; ((B18>0; B18<1))); (C18; 2)+ (D18; 2)+B18; (E18; 2)+EXP (B18+E18)+ (C18; D18)))

-1

2

2

-1,2

= ((E19>0; B19=0); (E19; B19)* (C19*E19)+D19* (E19; C19); ((E19=0; ((B19>0; B19<1))); (C19; 2)+ (D19; 2)+B19; (E19; 2)+EXP (B19+E19)+ (C19; D19)))

2

2

3

1

= ((E20>0; B20=0); (E20; B20)* (C20*E20)+D20* (E20; C20); ((E20=0; ((B20>0; B20<1))); (C20; 2)+ (D20; 2)+B20; (E20; 2)+EXP (B20+E20)+ (C20; D20)))

1

4

-3

2

= ((E21>0; B21=0); (E21; B21)* (C21*E21)+D21* (E21; C21); ((E21=0; ((B21>0; B21<1))); (C21; 2)+ (D21; 2)+B21; (E21; 2)+EXP (B21+E21)+ (C21; D21)))

0

1

-3

-2,3

= ((E22>0; B22=0); (E22; B22)* (C22*E22)+D22* (E22; C22); ((E22=0; ((B22>0; B22<1))); (C22; 2)+ (D22; 2)+B22; (E22; 2)+EXP (B22+E22)+ (C22; D22)))

1

2

1

2

= ((E23>0; B23=0); (E23; B23)* (C23*E23)+D23* (E23; C23); ((E23=0; ((B23>0; B23<1))); (C23; 2)+ (D23; 2)+B23; (E23; 2)+EXP (B23+E23)+ (C23; D23)))

2

2

1

2

= ((E24>0; B24=0); (E24; B24)* (C24*E24)+D24* (E24; C24); ((E24=0; ((B24>0; B24<1))); (C24; 2)+ (D24; 2)+B24; (E24; 2)+EXP (B24+E24)+ (C24; D24)))


.8 -


4


, , ( 10 ):


2 -

(.)


3 -

(.)


4 -





. , .


5 -

(.)

(.)

1

2

3

4

5

6

7

8=(6*7)


  1. Microsoft ACCESS ".
  2. 3 : " , " " . .9, 10 11.


.9 - "


.10 - "


.11 -


  1. . " . 2 : " " " " " ֻ " - " ֻ " . .12.

.12 -


  1. 3 . .13, 14 15.

.13 - "


.14 - "


.15 - "

  1. , . , .16. 1 ( ), :

: [ ]*[ ()]


.16 -


, , .17.


.17 -


, .18.


.18 -

Allbest.ru

: 1