- ©«¤l
- 472
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 485
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows
- ³nÅ骩¥»
- MS Office
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- »´ä
- µù¥U®É¶¡
- 2010-7-4
- ³Ì«áµn¿ý
- 2014-12-28
|
¦U¦³¦Uªº¦n³B, µø²Å§Aªº¹ê»Ú»Ýn
Access- ¤è«K²¾°Ê(§âmdbÀɥѤ½¥q§Û¦^¨ì®a,¸òxlsÀɤ@¼Ë), ¦pªG¬O¥ÎEXCEL®³¸ê®Æ,¤£»Ý¦w¸Ëaccess
¤ñ°_EXCEL¸û¾A¦X©ñ¤j½g¤å¦r¼Æ¾Ú(MEMO), ¤ñ¸û¨ä¥LDBMS©ö¾Ç.
MySQL, MS SQL Server Express - §K¶O,§Ö³t, ¦ý»Ýn¦w¸ËServer,¤£¯àÀH«K²¾°Ê, (²¾°Ê»Ýnbackup/restore)
>±NÀɮ׶פJ¸ê®Æ®wªº®ÉÔ®e¶q¬O§_·|¤ñìexcelÀɤp?
ExcelÀɦpªG¥u¦³¸ê®Æ¤å¦r,«Ü¤Ö·|¹L2G.
¬Ý¬Ý¬O¤£¬O¦³¦h¥X¨Óªº±±¥ó/¹Ï¤ù,´î¤@¤UÂé
©ñ¤J¸ê®Æ®wªºì¦], ¥Dn³q±`¬O³o´XÓ:
1.¼Æ¾Ú¶q¦h: ¦³¦h¤Ö¦æ¼Æ¾Ú(¦p > 6¸U¦æ)
2.¼Æ¾Ú¦h©ó¤@Ó"ªí", ¥Î¨Ó°µÃöÁp / DISTINCT COUNT µ¥
3.¦h¤H¦P®É¬Ý/¦P®É¥[´î¼Æ¾Ú (³oÓ¥ÎEXCEL·|¤ñ¸û§xÃø) |
|