Access2003$B$K$h$k%G!<%?%Y!<%9F~Lg(B $BBh(B3$B2s(B(1$B7n(B9$BF|(B) Part 2
$B%/%(%j$K$h$k=87W!&1i;;$J$I!$%/%(%j$N
. . $B%/%(%j$N=87W5!G=(B$B!!(B-Northwind$B%G!<%?%Y!<%9$N>&IJ%F!<%V%k$r;H$C$F(B-
$B%/%(%j$G$OMM!9$J=87W$r9T$&$3$H$,$G$-$^$9!#=87W5!G=$r;H$&$H!$FCDj$NCj=P>r7o$GCj=P$7$?%l%3!<%I72$N!$FCDj$N%U%#!<%k%ICM$N9g7WCM!&J?6QCM!&J,;6!&I8=`JP:9$J$I$r4JC1$K$5$i$K?WB.$K7W;;$9$k$3$H$,=PMh$^$9!#$3$N5!G=$O!$
$B!!(B
$B;EF~@h$4$H$K!V:_8K?t$N9g7W!W$r5a$a$k!#!!(B
$B"(;EF~@h$G%0%k!<%W2=$7!$%0%k!<%WFb$G:_8K?t$N9g7WCM$r7W;;$9$k!#(B
1. [$B%*%V%8%'%/%H(B]$B$G(B[$B%/%(%j(B]$B$rA*Br$7!$(B[$B?75,:n@.(B]$B$r2!$7$^$9!#!Z%/%(%j$N?75,:n@.![$G(B[$B%G%6%$%s%S%e!<(B]$B$rA*Br$7(B[OK]$B$r2!$7$^$9!#(B
2. [$B%F!<%V%k$NI=<((B]$B2hLL$G(B[$B%F!<%V%k(B]$B%?%V$rA*Br$7!$(B[$B>&IJ(B]$B%F!<%V%k$rA*Br$7$F(B[$BDI2C(B]$B$r2!$7$^$9!#(B$B%G%6%$%s%S%e!&IJ(B]$B%F!<%V%k$N%U%#!<%k%I0lMw$,I=<($5$l$F$$$k(B$B$N$r3NG'$7$F!$(B[$B%F!<%V%k$NI=<((B]$B2hLL$rJD$8$^$9!#(B
3. $B%/%(%j$N(B$BBh(B1$B%U%#!<%k%I$K(B[$B;EF~@h%3!<%I(B]$B$r@_Dj$7!$Bh(B2$B%U%#!<%k%I$K(B[$B:_8K(B]$B$r@_Dj(B$B$7$^$9!#(B
4. $B%D!<%k%\%C%/%9$N$J$+$G(B$B!V&2!W%^!<%/$N%\%?%s!J=87W!K(B$B$r2!$7$^$9!#$9$k$H!$%U%#!<%k%I@_DjMs$K(B[$B=87W(B]$BMs$,DI2C$5$l$^$9(B$B!#(B
5. [$B;EF~@h%3!<%I(B]$B%U%#!<%k%I$N(B[$B=87W(B]$BMs$O!V%0%k!<%W2=!W$N$^$^$K$7$F$*$-$^$9!#$B@_Dj8e2hLL$O$3$A$i(B$B!K!#(B
6. $B%a%K%e!<$N(B[$BI=<((B]$B!](B[$B%G!<%?%7!<%H%S%e!<(B]$B$G!$%G!<%?%7!<%H%S%e!<$rI=<($7$^$9!#(B
7. $B:_8K?t$NB?$$=gHV$G;EF~@h$,I=<($5$l$F$$$k$3$H$r3NG'$7$F$/$@$5$$!#(B
$B!!(B
$B%l%]!<%H2]Bj(B 3$B!!(B -$B%a!<%k$N%l%]!<%H$K2rEz$r=q$$$F$/$@$5$$(B-
$BLd(B5$B!!:_8K9g7W6b3[$,B?$$=g$K;EF~@h$rJB$SBX$($J$5$$!#>e0L#3
$B%R%s%H!'(B[$B;EF~@h%3!<%I(B]$B$G%0%k!<%W2=$9$k!#$^$?!$(B[$B:_8K6b3[(B]$B%U%#!<%k%I$r:n@.!J!V:_8K6b3[(B: [$BC12A(B]*[$B:_8K(B]$B!W$G5a$a$k!K$7!$(B[$B=87W(B]$BMs$K!V9g7W!W!$(B[$BJB$SBX$((B]$BMs$K!V9_=g!W$r@_Dj$9$k!#(B
$B!!(B
$B;EF~@h$4$H$K!VC12A!W$NJ?6Q!$:GBgCM!$:G>.CM$r5a$a$k!#!!(B
1. [$B%*%V%8%'%/%H(B]$B$G(B[$B%/%(%j(B]$B$rA*Br$7!$(B[$B?75,:n@.(B]$B$r2!$7$^$9!#!Z%/%(%j$N?75,:n@.![$G(B[$B%G%6%$%s%S%e!<(B]$B$rA*Br$7(B[OK]$B$r2!$7$^$9!#(B$B!!(B
2. [$B%F!<%V%k$NI=<((B]$B2hLL$G(B[$B%F!<%V%k(B]$B%?%V$rA*Br$7!$(B[$B>&IJ(B]$B%F!<%V%k$rA*Br$7$F(B[$BDI2C(B]$B$r2!$7$^$9!#(B$B%G%6%$%s%S%e!&IJ(B]$B%F!<%V%k$N%U%#!<%k%I0lMw$,I=<($5$l$F$$$k(B$B$N$r3NG'$7$F!$(B[$B%F!<%V%k$NI=<((B]$B2hLL$rJD$8$^$9!#(B
3. $B%D!<%k%\%C%/%9$N(B$B!V&2!W%^!<%/$N%\%?%s!J=87W!K(B$B$r2!$7!$(B[$B=87W(B]$BMs$rI=<($5$;$^$9!#(B
4. $B%/%(%j$NBh(B1$B%U%#!<%k%I$K(B[$B;EF~@h%3!<%I(B]$B!J(B[$B=87W(B]$BMs$O!V%0%k!<%W2=!W!K!$Bh(B2$B%U%#!<%k%I$K(B[$BC12A(B]$B!J(B[$B=87W(B]$BMs$O!VJ?6Q!W!$(B[$BJB$SBX$((B]$BMs$O!V9_=g!W!K!$Bh(B3$B%U%#!<%k%I$K(B[$BC12A(B]$B!J(B[$B=87W(B]$BMs$O!V:GBg!W!K!$Bh(B4$B%U%#!<%k%I$K(B[$BC12A(B]$B!J(B[$B=87W(B]$BMs$O!V:G>.!W!K$r@_Dj$7$^$9!J(B$B@_Dj8e2hLL$O$3$A$i(B$B!K!#(B
5. $B%a%K%e!<$N(B[$BI=<((B]$B!](B[$B%G!<%?%7!<%H%S%e!<(B]$B$G!$(B$B%G!<%?%7!<%H%S%e!<(B$B$rI=<($7$^$9!#(B
$B"(:n@.$7$?%/%(%j$O(B"$B1i=,C12A(B"$B$HL>A0$r$D$1$FJ]B8$7$F$/$@$5$$!#(B
$B!!(B
$B%/%(%j$N=87W!&1i;;7k2L$r(BCSV$B7A<0$G=PNO$9$k!#(B
$B%/%(%j$N=87W!&1i;;7k2L$O(BCSV$B7A<0$G=PNO$G$-$^$9!#(BCSV$B7A<0$H$O%+%s%^6h@Z$j7A<0$N%F%-%9%H%G!<%?$N$3$H$G$9!#$3$l$O!$%(%/%;%k$d%o!<%I$G;HMQ$9$k$3$H$,$G$-$kHFMQ@-$N9b$$%G!<%?7A<0$G$9!#(B
1. [$B%*%V%8%'%/%H(B]$B$G(B[$B%/%(%j(B]$B$rA*Br$7!$@h$[$I:n@.$7$?(B[$B1i=,C12A(B]$B%/%(%j$r$B%G!<%?%7!<%H%S%e!<(B$B$G%G!<%?$rI=<($7$^$9!#(B
2. $B%a%K%e!<$N(B[$B%U%!%$%k(B]$B!](B[$B%(%/%9%]!<%H(B]$B$r2!$7!$(B['$B1i=,C12A(B'$B%/%(%j$r%(%/%9%]!<%H(B]$B2hLL$rI=<($7$^$9!#$3$3$G!$J]B8@h$K3F<+$N(BH$B%I%i%$%V$N(B[$B%3%s%T%e!<%?1i=,(B]$B%U%)%k%@$r;XDj$7!$$5$i$K(B[$B%U%!%$%k$N
3. [$B%(%/%9%]!<%H%&%#%6!<%I(B]$B$N(B1$B%Z!<%8L\$G$O!$!V6h@Z$j5-9fIU$-!&!&!&!W$r%A%'%C%/$7$F(B[$Bl9g$K$O!$(B$B!V(I%%%(B\$B1i=,C12A(B.csv$B!W$HJQ99(B$B$7$F(B[$B40N;(B]$B$r2!$7$F$/$@$5$$!#%(%/%9%]!<%H$,=*N;$7$?;]$N%a%C%;!<%8$,I=<($5$l$k$N$G(B[OK]$B$r2!$7$^$9!#(B
4. $B3F<+$N(BH$B%I%i%$%V$N(B[$B%3%s%T%e!<%?1i=,(B]$B%U%)%k%@$r3+$-!$!V1i=,C12A(B.csv$B!W%U%!%$%k$r%@%V%k%/%j%C%/$7$F3+$$$F$/$@$5$$!#%(%/%;%k$,5/F0$7!$%(%/%;%k>e$G%G!<%?$NJT=8$,=PMh$k$3$H$,$o$+$j$^$9!#(B
$B"((BCSV$B7A<0$N%G!<%?$O$[$H$s$I$N%=%U%H$G3+$/$3$H$,$G$-$^$9!#(B
$B!!(B
$B%/%(%j$N%]%$%s%H@0M}(B
$B!|%/%(%j$rMQ$$$?Cj=P$d1i;;$G$O!$85%G!<%?$NJQ99Ey$r9T$o$J$$$N$G85%G!<%?$r2u$9?4G[$,$J$$!#(B
$B!|%/%(%j$O$"$/$^$G$b(B"$B7W;;<0!J%W%m%0%i%`!K(B"$B$J$N$G!$$=$l<+BN$O%G!<%?$r;}$C$F$$$^$;$s!#$J$N$G!$%/%(%j$r$?$/$5$s:n$C$F$b%G!<%?NL$OA}$($J$$!#%(%/%;%k$G$O!$1i;;7k2L$rI=<($9$k%;%k$rDI2C$7$F$$$/$N$G!$$$$m$$$m1i;;$9$k$H!$$H$s$G$b$J$$Bg$-$5$N%U%!%$%k$K$J$C$F$7$^$&$3$H$,$"$j$^$9!#$9$k$H!$(B"$B%a%b%jITB-$G
$B!|%/%(%j$b%F!<%V%k$HF1$8$K07$($^$9!#$D$^$j!$%/%(%j$r%G!<%?%=!<%9$K$7$F!J%F!<%V%k$K8+N)$F$F!K?7$7$$%/%(%j$r:n@.$G$-$k$H$$$&$3$H$G$9!#%(%/%;%k$G$O!$F1MM$N%G!<%?%7!<%H$r:n$k>l9g!$%7!<%H$r$^$k#1KgJ,%3%T!<$7$FDI2C$7$J$$$H$$$1$^$;$s$,!$(BAccess$B$G$O%F!<%V%k$rA}$d$9I,MW$O$"$j$^$;$s!#$3$l$N$*$+$2$G!$$"$H$"$H$N%A%'%C%/$d=$@5$,05E]E*$K4JC1$K$J$j$^$9!*(B
$B!|1i;;$J$I$N@_Dj$,%(%/%;%k$N?tG\3Z$G$9!#%(%/%;%k$G$O!$$R$H$D$N%;%k$KF~NO$7$?<0$rB>$N%;%k$K%3%T!<$9$k$?$a$K!$$:!<$C$H%I%i%C%0$7$F$$$-$^$9!#$3$N:n6H$,BgJQ6K$^$j$J$$!#?t@i8D$N%G!<%?=hM}$G$O$3$l$@$1$G$b#1F|$D$V$l$^$9$h!*(BAccess$B$G$O%/%(%j$N%G%6%$%s2hLL$G1i;;<0$r5-F~$9$l$P(BOK$B$G$9!#(B
$B!!(B
$B%l%]!<%H2]Bj(B 4$B!!(B -$B%a!<%k$N%l%]!<%H$K2rEz$r=q$$$F$/$@$5$$(B-
$BLd(B6 JC_Ranks_2000.mdb$B$r;HMQ$7$F$/$@$5$$!#(B[$B;(;o@5<0L>(B]$B$K(B"physiology"$B$r4^$_!$(B[Impact Factor]$B$,(B1.5$B0J>e(B5.0$B0J2<$G!$:G$b(B[2000 Total cites]$B$,>.$5$$;(;o$N@5<0L>>N$O2?$G$9$+!)(B
$B!!(B
$BLd(B7 JC_Ranks_2000.mdb$B$r;HMQ$7$F$/$@$5$$!#(B[$B;(;o@5<0L>(B]$B$K(B"physiology"$B$r4^$`$,(B"plant"$B$r4^$^$:!$(B[2000 Total cites]$B$,(B1000$B0J>e(B2000$B0J2<(B$B$N;(;o$O2?:}$"$j$^$9$+!)(B
$B!!(B
$B!!(B
$B!!(B
$BA0%Z!<%8$KLa$k(B...
Last update 2006/1/5

$B%3%s%T%e!<%?1i=,%H%C%W$X(B | $B%b!<%0$N(BOffice$B;29M=q%H%C%W$X(B | $BA0%Z!<%8$X(B

2006 Computer exercise$B!!#K(B. Takayama All rights reserved.