Access2000$B$K$h$k%G!<%?%Y!<%9F~Lg(B $BBh(B4$B2s(B(12$B7n(B19$BF|(B) Part 1

Access2000$B$rMxMQ$7$?
. . $B=`Hw(B$B!!(B-$BB,Dj%G!<%?$N%@%&%s%m!<%I(B-
2004$BG/$NB4O@5e29EY$N7P;~JQ2=$N%G!<%?!J%U%!%$%kL>$O!V(Bsample.csv$B!W!K$r%5%s%W%k$H$7$F;HMQ$7$^$9!#$3$N%G!<%?$r3F<+$N(B[$B%3%s%T%e!<%?1i=,(B]$B%U%)%k%@$K%@%&%s%m!<%I$7$^$9!#(B
1. $B1&Ns$N%"%$%3%s!J(B$B!K>e$G1&%/%j%C%/$7!$(B$B!VBP>]$r%U%!%$%k$KJ]B8!W$rA*Br(B$B$7$^$9!#(B[$BL>A0$r$D$1$FJ]B8(B]$B2hLL(B$B$G3F<+$N(BHD$BNN0h!J(BH$B!'%I%i%$%V!K$N(B[$B%3%s%T%e!<%?1i=,(B]$B%U%)%k%@$rA*Br$7!$!V(Bsample.csv$B!W$H$$$&L>A0$GJ]B8$7$F$/$@$5$$!#(B
sample.csv
2. $B%@%&%s%m!<%I$,=*N;$7$?;]$N%a%C%;!<%8(B$B$,I=<($5$l$k$N$G(B[$BJD$8$k(B]$B$r2!$7$F$/$@$5$$!#(B
3. $B3F<+$N(BHD$BNN0h!J(BH$B!'%I%i%$%V!K$N(B[$B%3%s%T%e!<%?1i=,(B]$B%U%)%k%@$r3+$-!$$=$NCf$K!V(Bsample.csv$B!W(B$B$,$"$k$3$H$r3NG'$7$F$/$@$5$$!#!V(Bsample.csv$B!W$r%@%V%k%/%j%C%/$7!$%(%/%;%k$GFbMF$r3NG'$7$F$/$@$5$$!#8aA0(B7$B;~2a$.$+$i4%5e29EY$H<>5e29EY$r(B10$BIC$4$H$KB,Dj$7$?%G!<%?$G$"$k$3$H$r3NG'$7$F$/$@$5$$!#(B
$B!!(B
CSV$B7A<0%U%!%$%k$r(BAccess2000$B$K$B!!(B-$B%G!<%?$N%$%s%]!<%H(B-
1. $B%G!<%?2r@OMQ$N%G!<%?%Y!<%9$r?7$?$K:n@.$7$^$9!#(BAccess2000$B$,3+$+$l$F$$$k>l9g$K$O!$0lEY(BAccess2000$B$r=*N;$7$F$/$@$5$$!#(B
2. [$B%9%?!<%H(B]$B$+$i(B[Microsoft Access]$B$r5/F0$7$^$9!#(B
3. $B%*!<%W%K%s%02hLL(B$B$G(B[$B6u$N%G!<%?%Y!<%9(B]$B$rA*Br$7$F(B[$B#O#K(B]$B$r2!$7$^$9!#(B
4. $B!Z%G!<%?%Y!<%9$N?75,:n@.![2hLL$G%G!<%?%Y!<%9$r:n@.$9$k%U%)%k%@(B($B3F<+$N(BHD$BNN0h$K!V%3%s%T%e!<%?1i=,!W%U%)%k%@$r:n@.$9$k$3$H(B)$B$rA*Br$7!$%U%!%$%kL>!J%G!<%?%Y!<%9L>!K$K!V%G!<%?2r@O!W$HF~NO$7$F(B[$B:n@.(B]$B$r2!$7$^$9!#!Z%G!<%?2r@O!'%G!<%?%Y!<%9![2hLL$,N)$A>e$,$j$^$9!#(B
5. $B%a%K%e!<$N(B[$B%U%!%$%k(B]$B!](B[$B30It%G!<%?$N$B$7$^$9!#(B
6. $B%$%s%]!<%H%U%!%$%k$rA*Br$9$k2hLL$G!$!V%U%!%$%k$N>l=j!W$r3F<+$N(BHD$BNN0h$N(B[$B%3%s%T%e!<%?1i=,(B]$B%U%)%k%@$H$7!$!V%U%!%$%k$N
7. $B!V(Bsample.csv$B!W%U%!%$%k$rA*Br$7!$(B[$B%$%s%]!<%H(B]$B$r2!$7$^$9!#(B
8. [$B%F%-%9%H(B $B%$%s%]!<%H(B $B%&%#%6!<%I(B]$B$N(B1$B%Z!<%8L\(B$B$G$O!$!V6h@Z$j5-9fIU$-(I%%%$B!W$,A*$P$l$F$k$3$H$r3NG'$7$F(B[$B
9. [$B%F%-%9%H(B $B%$%s%]!<%H(B $B%&%#%6!<%I(B]$B$N(B2$B%Z!<%8L\(B$B$G$O!$!V%U%#!<%k%I6h@Z$j5-9f!W$K(B[$B%+%s%^(B]$B$,A*Br$5$l!$(B[$BF|;~(B]$B!&(B[$B4%5e(B]$B!&(B[$B<>5e(B]$B$,6hJL$5$l$F$$$k$3$H$r3NG'$7$F(B[$B
10. [$B%F%-%9%H(B $B%$%s%]!<%H(B $B%&%#%6!<%I(B]$B$N(B4$B%Z!<%8L\(B$B$G$O3F%U%#!<%k%I$N[$B%U%#!<%k%IL>(B]$B$K!VF|;~!W!$(B[$B%G!<%?7?(B]$B$K!VF|IU(B/$B;~9o7?!W(B$B$r@_Dj$7$^$9!J(B$B@_Dj2hLL$O$3$A$i(B$B!K!#$D$E$$$FF10l2hLL$G%U%#!<%k%I(B2$B$rA*Br$7!$(B[$B%U%#!<%k%IL>(B]$B$K!V4%5e29EY!W!$(B[$B%G!<%?7?(B]$B$K!VG\@:EYIbF0>.?tE@7?!W(B$B$r@_Dj$7$^$9!J(B$B@_Dj2hLL$O$3$A$i(B$B!K!#$5$i$K!$F10l2hLL$N$^$^$G%U%#!<%k%I(B3$B$rA*Br$7!$(B[$B%U%#!<%k%IL>(B]$B$K!V<>5e29EY!W!$(B[$B%G!<%?7?(B]$B$K!VG\@:EYIbF0>.?tE@7?!W(B$B$r@_Dj$7$^$9!J(B$B@_Dj2hLL$O$3$A$i(B$B!K!#$9$Y$F$N@_Dj$r3NG'$7$F$+$i(B[$B
11. [$B%F%-%9%H(B $B%$%s%]!<%H(B $B%&%#%6!<%I(B]$B$N(B5$B%Z!<%8L\(B$B$G$O(B[$B
12. [$B%F%-%9%H(B $B%$%s%]!<%H(B $B%&%#%6!<%I(B]$B$N(B6$B%Z!<%8L\(B$B$G$O!$(B[$B%$%s%]!<%H@h$N%F!<%V%k(B]$B$K!VB,Dj%G!<%?!W$HF~NO$7$F(B[$B40N;(B]$B$r2!$7$^$9!#(B
13. $B%G!<%?$N%$%s%]!<%H$,40N;$7$?;]$N%a%C%;!<%8(B$B$,I=<($5$l$k$N$G!$(B[OK]$B$r2!$7$^$9!#(B
14. [$B%*%V%8%'%/%H(B]$B$G(B[$B%F!<%V%k(B]$B$rA*Br$7!$(B[$BB,Dj%G!<%?(B]$B%F!<%V%k$,:n@.$5$l$F$$$k$3$H$r3NG'$7$F$/$@$5$$!#$5$i$K!$(B[$BB,Dj%G!<%?(B]$B%F!<%V%k$NCf?H$r3NG'$7!$(B10$BIC$4$H$N29EY%G!<%?$,%$%s%]!<%H$5$l$F$$$k$3$H$r3NG'$7$F$/$@$5$$!J(B$B%$%s%]!<%H$5$l$?(B[$BB,Dj%G!<%?(B]$B%F!<%V%k(B$B!K!#(B
15. [$BB,Dj%G!<%?(B_$B%$%s%]!<%H(B $B%(%i!<(B]$B%F!<%V%k$O!$%$%s%]!<%H$K<:GT$7$?9`L\?t$r<($7$F$$$^$9!#:#2s$N%$%s%]!<%H$G$O!$(B1$B9TL\$N!VF|;~!&4%5e!&<>5e!W$N.?tE@7?!W$G$O$J$$$?$a$K@8$8$?%(%i!<$G$9!#(B$B$=$N$?$a!$(B[$BB,Dj%G!<%?(B]$B%F!<%V%k$N(B1$B%l%3!<%IL\$,6uMs$K$J$C$F$$$^$9!#$3$N%l%3!<%I$r:o=|$7$F$*$-$^$9!#(B
$B"(Bh(B3$B2s1i=,$G3X=,$7$?%G!<%?$N%(%/%9%]!<%H$H!$:#2s$N%$%s%]!<%H$r;HMQ$9$k$3$H$G!$(BAccess$B$H$=$NB>$N%=%U%H4V$G$N%G!<%?$N$d$j
$B!!(B
$B%G!<%?2r@O$N4pAC!!(B-1$B;~4V$4$H$NJ?6QCM%G!<%?$r:n@.$9$k(B-
[$BF|;~(B]$B%U%#!<%k%I$+$i!V;~!W$H!VJ,!W$r
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[$BB,Dj%G!<%?(B]$B%F!<%V%k$rA*Br$7$F(B[$BDI2C(B]$B$r2!$7$^$9!#%G%6%$%s%S%e!
3. $B%/%(%j$NBh(B1$B%U%#!<%k%I$G(B[$BB,Dj%G!<%?(B.*]$B$rA*Br$7!$(B[$BB,Dj%G!<%?(B]$B%F!<%V%k$NA4%G!<%?$,I=<($5$l$k$h$&$K$7$^$9!#(B
4. $BBh(B2$B%U%#!<%k%I$K$O!V;~!W$,I=<($5$l$k$h$&$K$7$^$9!#(B[$BF|;~(B]$B%U%#!<%k%I$+$i!V;~!W$@$1$rCj=P$9$k$?$a$K!$(BHour$B4X?t$r;HMQ$7$^$9!#Bh(B2$B%U%#!<%k%I$K$O!V;~(B: Hour([$BF|;~(B])$B!W$HF~NO$7$F$/$@$5$$!J(B$B@_Dj:Q2hLL$O$3$A$i(B$B!K!#(B
5. $BBh(B3$B%U%#!<%k%I$K$O!VJ,!W$,I=<($5$l$k$h$&$K$7$^$9!#(B[$BF|;~(B]$B%U%#!<%k%I$+$i!VJ,!W$@$1$rCj=P$9$k$?$a$K!$(BMinute$B4X?t$r;HMQ$7$^$9!#Bh(B2$B%U%#!<%k%I$K$O!VJ,(B: Minute([$BF|;~(B])$B!W$HF~NO$7$F$/$@$5$$!J(B$B@_Dj:Q2hLL$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!$(B$B!V;~!W$H!VJ,!W$,I=<($5$l$k%U%#!<%k%I$,DI2C$5$l$F$$$k(B$B$3$H$r3NG'$7$F$/$@$5$$!#(B
7. $B:n@.$7$?%/%(%j$O!$!V;~J,B,Dj%G!<%?!W$HL>A0$r$D$1$FJ]B8$7$F$/$@$5$$!#(B
$B!!(B
1$B;~4V$4$H$NJ?6QCM%G!<%?$K2C9)$9$k(B$B!!(B-[$B;~J,B,Dj%G!<%?(B]$B%/%(%j$rMQ$$$F(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%/%(%j(B]$B%?%V$rA*Br$7!$(B[$B;~J,B,Dj%G!<%?(B]$B%/%(%j$rA*Br$7$F(B[$BDI2C(B]$B$r2!$7$^$9!#%G%6%$%s%S%e!
3. $B%/%(%j$NBh(B1$B%U%#!<%k%I$K(B[$B;~(B]$B$r@_Dj$7!$Bh(B2$B%U%#!<%k%I$K(B[$B4%5e29EY(B]$B$r!$Bh(B3$B%U%#!<%k%I$K(B[$B<>5e29EY(B]$B$r@_Dj$7$^$9!J(B$B@_Dj:Q2hLL$O$3$A$i(B$B!K!#(B
4. $B%D!<%k%\%C%/%9$N(B$B!V&2!W%^!<%/$N%\%?%s!J=87W!K(B$B$r2!$7!$%U%#!<%k%I@_DjMs$K(B[$B=87W(B]$BMs$rDI2C$7$9!#(B
5. [$B;~(B]$B$N=87WMs$O!V%0%k!<%W2=!W$N$^$^$K$7$F$*$-$^$9!#5e29EY(B]$B$N=87WMs$b!VJ?6Q!W$KJQ99$7$^$9!J(B$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!$(B$B!V;~!W$4$H$N4%5e29EY$H<>5e29EY$NJ?6QCM$,I=<($5$l$F$$$k(B$B$3$H$r3NG'$7$F$/$@$5$$!#(B
$B!!(B
$BLd(B1$B!!(B$B!VJ,!W$4$H$N(B$B4%5e29EY$H<>5e29EY(B$B$NJ?6QCM$r7W;;$7$J$5$$!#(B
$B"(%R%s%H!'!V;~!W$G!V%0%k!<%W2=!W$7!$$D$.$K!VJ,!W$G!V%0%k!<%W2=!W$9$k!#(B
$BLd(B2$B!!!VJ,!W$4$H$NJ?6Q4%5e29EY$HJ?6Q<>5e29EY$N:9$,:GBg$H$J$k;~9o!J(B$B!{!{;~!{!{J,(B$B!K$r5a$a$J$5$$!#(B
$B"(%N!<%R%s%H(B
$B!!!!(B
$B
Last update 2005/12/17

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


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