2017Äê¡¶µçË㻯»á¼Æ¡·06ÈÎÎñ-×ÜÕËÆÚÄ©´¦Àí(2)
5. ¼ÇÕË
½«ËùÓÐÒÑÉóºËƾ֤¼ÇÕË¡£
µã»÷Öв¿µÄ¡°¼ÇÕÊ¡±¡ªµã¡°È«Ñ¡¡±¡ªµã¡°ÏÂÒ»²½¡±¡ª¡°ÏÂÒ»²½¡±¡ª¡°¼ÇÕË¡±¡ª¡°È·ÈÏ¡±¡ª¡°È·¶¨¡±
6. Õ˲¾²éѯ
×ÜÕË¡ªÕ˲¾²éѯ¡ªÓà¶î±í¡ªÔÚµ¯³öµÄ¶Ô»°¿òÖС°¿ÆÄ¿ÀàÐÍ¡±Ñ¡Ôñ¡°³É±¾¡±£¬µã¡°È·¶¨¡±¡£µã¡°Êä³ö¡±£¬ÔÚµ¯³öµÄ¶Ô»°¿òÖÐÑ¡Ôñ±£´æÂ·¾¶¡°D:\Exam\04ÈÎÎñ×ÜÕËÈÕ³£ÒµÎñ´¦Àí\***¡±£¨***´ú±í¿¼ÉúÐÕÃû£©£¬ÊäÈëÎļþÃû£º³É±¾ÀàÓà¶î±í¡ª±£´æÀàÐÍ£º¡°UFSoft Report File(*.rep)¡±¡ª±£´æ¡ªÈ·¶¨
Í˳ö¡ª¹Ø±Õ¡° ³©½ÝͨT3¡±´°¿Ú
½»¾í
µÚÈýƪ·¶ÎÄ£º2014ÄêµçË㻯»á¼Æ--06ÈÎÎñ×ÜÕ˳öÄɹÜÀí
2014ÄêµçË㻯»á¼Æ--06ÈÎÎñ×ÜÕ˳öÄɹÜÀí
06ÈÎÎñ ×ÜÕ˳öÄɹÜÀí
[¿¼ºËÒªÇó]
ÒÔ³öÄÉ¡°22 ÁõÄÈ¡±µÄÉí·ÝÍê³É×ÜÕ˳öÄɹÜÀí¡£
²Ù×÷Ô±¡°22¡±£»ÃÜÂë¡°2¡±£»ÕËÌס°555¡±£»»á¼ÆÄê¶È¡°2011¡±£»ÈÕÆÚ¡°2011-01-31¡±¡£ [¿¼ºËÄÚÈÝ] 1. ÈÕ¼ÇÕ˲éѯ
²éѯ¹¤Ðдæ¿îÈÕ¼ÇÕË£¬½«ÆäÊä³öµ½¿¼ÉúÎļþ¼Ð£¨C:\cwks\ÐÕÃû£©Ï£¬ÎļþÃûΪ¡°ÒøÐдæ¿îÈÕ¼ÇÕË¡±£¬±£´æÀàÐÍΪ¡°Microsoft Excel 3 (*.xls)¡±£¬ÆäËûĬÈÏ¡£
2. µÇ¼Ç֧Ʊ²¾
2011Äê1ÔÂ26ÈÕ£¬²É¹ºÖÐÐÄÓÚÃçÁìȡתÕË֧ƱһÕÅ£¬Æ±ºÅ789£¬ÏÞ¶î20000Ôª£¬ÓÃ;Ϊ¡°²É¹ºÉÌÆ·¡±¡£
3. ÒøÐжÔÕË
£¨1£©Â¼ÈëÒøÐжÔÕËÆÚ³õÊý¾Ý
ÈðÏé¿Æ¼¼¹¤Ðдæ¿îÈÕ¼ÇÕËµÄÆôÓÃÈÕÆÚΪ2011/01/01£¬ÈÕ¼ÇÕ˵÷ÕûǰÓà¶îΪ800000Ôª£¬ÒøÐжÔÕ˵¥µ÷ÕûǰÓà¶îΪ780000Ôª£¬Î´´ïÕËÏîÒ»±Ê£¬ÏµÒøÐÐÒѸ¶Æóҵδ¸¶¿î20000Ôª£¨ÈÕÆÚΪ2010Äê12ÔÂ31ÈÕ£©¡£
£¨2£©Â¼ÈëÒøÐжÔÕ˵¥
01Ô·ݹ¤Ðдæ¿îÒøÐжÔÕ˵¥
£¨3£©ÒøÐжÔÕË£¬¶ÔÕ˽ØÖ¹ÈÕÆÚΪ2011-01-31¡££¨¹¤Ðдæ¿î£© £¨4£©Éú³ÉÒøÐдæ¿îÓà¶îµ÷½Ú±í£¨¹¤Ðдæ¿î£©
²éѯ¹¤Ðдæ¿îµÄÒøÐдæ¿îÓà¶îµ÷½Ú±í£¬½«ÆäÊä³öµ½¿¼ÉúÎļþ¼Ð£¨C:\cwks\ÐÕÃû£©Ï£¬ÎļþÃûΪ¡°ÒøÐдæ¿îÓà¶îµ÷½Ú±í¡±£¬±£´æÀàÐÍΪ¡°Microsoft Excel 3 (*.xls)¡±£¬ÆäËûĬÈÏ¡£
²Ù×÷¹ý³Ì£º
ϵͳµÇ¼
Ñ¡Ôñ¡°´ò¿ª[×ÜÕË]Ó¦ÓóÌÐò¡± ÊäÈëÓû§Ãû¡°22¡± ÊäÈëÃÜÂë¡°2¡±
Ñ¡Ôñ»òÊäÈëµÇ¼ÈÕÆÚ¡°2011-01-31¡± Ñ¡Ôñ¡°È·¶¨¡± 1.ÈÕ¼ÇÕ˲éѯ
Ñ¡Ôñ¡°Ïֽ𡱲˵¥Ï¡°ÏÖ½ð¹ÜÀí¡±Ï¡°ÈÕ¼ÇÕË¡±Öеġ°ÒøÐÐÈÕ¼ÇÕË¡± Ñ¡Ôñ¿ÆÄ¿ÁбíÖеġ°100201 ¹¤Ðдæ¿î¡± Ñ¡Ôñ¡°È·ÈÏ¡± Ñ¡Ôñ¡°µ¼³ö¡±
ÔÚ¡°±£´æÔÚ¡±ÁбíÖÐÑ¡ÔñCÅÌ Ë«»÷cwksÎļþ¼Ð Ë«»÷¿¼ÉúÐÕÃûÎļþ¼Ð
ÊäÈëÎļþÃû¡°ÒøÐдæ¿îÈÕ¼ÇÕË¡±
Ñ¡ÔñÎļþÀàÐÍ¡°Microsoft Excel 3£¨*.xls£©¡± Ñ¡Ôñ¡°±£´æ¡± Ñ¡Ôñ¡°È·ÈÏ¡± Ñ¡Ôñ¡°È·¶¨¡± Ñ¡Ôñ¡°Í˳ö¡± 2.µÇ¼Ç֧Ʊ²¾
Ñ¡Ôñ¡°Ïֽ𡱲˵¥Ï¡°Æ±¾Ý¹ÜÀí¡±Öеġ°Ö§Æ±µÇ¼Ç²¾¡± Ñ¡Ôñ¿ÆÄ¿¡°¹¤Ðдæ¿î£¨100201£©¡±£¨±¾ÀýĬÈÏ£¬²»ÐèÑ¡Ôñ£¬ËùÑ¡ÒøÐпÆÄ¿´ÓÏÂÃæ¸÷ÌâÖв鿴£¬´ËΪ³öÌâ©¶´£©
Ñ¡Ôñ¡°È·¶¨¡± Ñ¡Ôñ¡°Ôö¼Ó¡±
ÊäÈë»òÑ¡ÔñÈÕÆÚ¡°2011.1.26¡± Ñ¡ÔñÁìÓò¿ÃÅ¡°²É¹ºÖÐÐÄ¡± Ñ¡ÔñÁìÓÃÈË¡°ÓÚÃ硱 ÊäÈëÆ±ºÅ¡°789¡±
ÊäÈëÔ¤¼Æ½ð¶î¡°20000¡± Ë«»÷ÊäÈëÓÃ;¡°²É¹ºÉÌÆ·¡±
Ñ¡Ôñ¡°±£´æ¡± Ñ¡Ôñ¡°Í˳ö¡± 3.ÒøÐжÔÕË
£¨1£©ÊäÈëÒøÐжÔÕËÆÚ³õÊý¾Ý
Ñ¡Ôñ¡°Ïֽ𡱲˵¥Ï¡°ÉèÖá±Öеġ°ÒøÐÐÆÚ³õ¼È롱 ¿ÆÄ¿Ñ¡Ôñ¡°¹¤Ðдæ¿î£¨100201£©¡±£¨±¾ÀýĬÈϲ»ÐèÑ¡Ôñ£© Ñ¡Ôñ¡°È·¶¨¡±
ÊäÈ뵥λÈÕ¼ÇÕ˵÷ÕûǰÓà¶î¡°800000¡± ÊäÈëÒøÐжÔÕ˵¥µ÷ÕûǰÓà¶î¡°780000¡± Ñ¡Ôñ¡°¶ÔÕ˵¥ÆÚ³õδ´ïÏ Ñ¡Ôñ¡°Ôö¼Ó¡±
ÊäÈë»òÑ¡ÔñÈÕÆÚ¡°2010.12.31¡± ÊäÈë´û·½½ð¶î¡°20000¡± Ñ¡Ôñ¡°±£´æ¡± Ñ¡Ôñ¡°Í˳ö¡± £¨2£©ÊäÈëÒøÐжÔÕ˵¥
Ñ¡Ôñ¡°ÒøÐжÔÕ˵¥Â¼È롱
Ñ¡Ôñ¿ÆÄ¿¡°¹¤Ðдæ¿î£¨100201£©¡±£¨±¾ÀýĬÈϲ»ÐèÊäÈ룩 Ñ¡Ôñ¡°È·¶¨¡± Ñ¡Ôñ¡°Ôö¼Ó¡±
ÊäÈëÈÕÆÚ¡°2011.01.03¡± Ë«»÷Ñ¡Ôñ½áË㷽ʽ¡°201¡± ÊäÈëÆ±ºÅ¡°ZP001¡± ÊäÈë´û·½½ð¶î¡°5000¡± Ñ¡Ôñ¡°Ôö¼Ó¡±
ÊäÈëÈÕÆÚ¡°2011.01.10¡± Ë«»÷Ñ¡Ôñ½áË㷽ʽ¡°201¡± ÊäÈëÆ±ºÅ¡°ZP004¡± ÊäÈë½è·½½ð¶î¡°60000¡± Ñ¡Ôñ¡°Ôö¼Ó¡±
ÊäÈëÈÕÆÚ¡°2011.01.16¡± Ë«»÷Ñ¡Ôñ½áË㷽ʽ¡°201¡± ÊäÈëÆ±ºÅ¡°ZP005¡± ÊäÈë´û·½½ð¶î¡°4000¡±
Ñ¡Ôñ¡°Ôö¼Ó¡±
ÊäÈëÈÕÆÚ¡°2011.01.25¡± Ë«»÷Ñ¡Ôñ½áË㷽ʽ¡°202¡± ÊäÈëÆ±ºÅ¡°HP003¡± ÊäÈë´û·½½ð¶î¡°30000¡± Ñ¡Ôñ¡°±£´æ¡± Ñ¡Ôñ¡°Í˳ö¡± £¨3£©ÒøÐжÔÕË
Ñ¡Ôñ¡°ÒøÐжÔÕË¡±
Ñ¡Ôñ¿ÆÄ¿¡°¹¤Ðдæ¿î£¨100201£©¡±£¨±¾ÀýĬÈÏ£© Ñ¡Ôñ¡°È·¶¨¡± Ñ¡Ôñ¡°¶ÔÕË¡±
Ñ¡Ôñ»òÊäÈë½ØÖ¹ÈÕÆÚ¡°2011.01.31¡± Ñ¡Ôñ¡°È·¶¨¡± Ñ¡Ôñ¡°Í˳ö¡±
£¨4£©Éú³ÉÒøÐдæ¿îÓà¶îµ÷½Ú±í
Ñ¡Ôñ¡°Óà¶îµ÷½Ú±í¡±
Ë«»÷¡°¹¤Ðдæ¿î£¨100201£©¡±Ò»ÐÐ Ñ¡Ôñ¡°Êä³ö¡±
È·Èϱ£´æÎļþ¼ÐΪCÅÌcwksÎļþ¼ÐÖеĿ¼ÉúÐÕÃûÎļþ¼ÐÊäÈëÎļþÃû¡°ÒøÐдæ¿îÓà¶îµ÷½Ú±í¡± Ñ¡Ôñ¡°È·ÈÏ¡± Ñ¡Ôñ¡°È·¶¨¡±
¹Ø±ÕÒøÐдæ¿îÓà¶îµ÷½Ú±í´°¿Ú ¹Ø±Õ³©½Ýͨ´°¿Ú
Ñ¡Ôñ¡°½»¾í¡±½øÐн»¾íÆÀ·Ö
¡¡ ´Ë´¦Òþ²Ø£º209×Ö£¬È«²¿ÎĵµÄÚÈÝÇëÏÂÔØºó²é¿´¡£Ï²»¶¾ÍÏÂÔØ°É ¡¡Ïà¹ØÍÆ¼ö£º
- [¾µä·¶ÎÄ]н³ê¹ÜÀí¹¤×÷×ܽᣨÓÅÐã6ƪ£©
- [¾µä·¶ÎÄ]СѧÑݽ²¸å¡¾¾«Ñ¡10ƪ¡¿
- [¾µä·¶ÎÄ]¼ÆËã»úרҵʵϰ±¨¸æ רҵʵ¼ù±¨¸æ1500
- [¾µä·¶ÎÄ]ÆßÄ꼶˼ÏëÆ·µÂ½Ìѧ¼Æ»®£¨ÓÅÐã7ƪ£©
- [¾µä·¶ÎÄ]º£Ñ¡±ÈÈü×ÔÎÒ½éÉÜ
- [¾µä·¶ÎÄ]³õÖÐÓ¢Óï±ÈÈü×ÔÎÒ½éÉÜ
- [¾µä·¶ÎÄ]ÐÂÀ´µÄÀÏʦ×ÔÎÒ½éÉÜ
- [¾µä·¶ÎÄ]³õÖÐÃÀÊõÀÏʦ×ÔÎÒ½éÉÜ
- [¾µä·¶ÎÄ]²Î¼ÓÄ£ÌØ±ÈÈü×ÔÎÒ½éÉÜ
- [¾µä·¶ÎÄ]ÀÏʦÏòÓ×¶ù×ÔÎÒ½éÉÜ
- [¾µä·¶ÎÄ]ÀÏʦ×ÔÎÒ½éÉܾµä·¶Àý
- [¾µä·¶ÎÄ]¸ßÖÐÕþÖÎÀÏʦ×ÔÎÒ½éÉÜ
- [¾µä·¶ÎÄ]¿ÆÈÎÀÏʦµÄ×ÔÎÒ½éÉÜ
- [¾µä·¶ÎÄ]¼ÆËã»úÀÏʦµÄ×ÔÎÒ½éÉÜ
- [¾µä·¶ÎÄ]ÏúÊÛ·¿²úÃæÊÔ×ÔÎÒ½éÉÜ
- [¾µä·¶ÎÄ]³õÖÐ×ÔÎÒ½éÉÜ400×Ö
- [¾µä·¶ÎÄ]ÐÂÒôÀÖ½ÌʦµÄ×ÔÎÒ½éÉÜ
- [¾µä·¶ÎÄ]ӦƸӢÓï¿ÚÓï×ÔÎÒ½éÉÜ
- [¾µä·¶ÎÄ]´óѧӢÓï×ÔÎÒ½éÉÜ·¶±¾
- [¾µä·¶ÎÄ]ÐÂÀÏʦÏòÁìµ¼×ÔÎÒ½éÉÜ
- ľ²ÄÊÕ¹ººÏͬ£¨¹²15ƪ£©(ľ²ÄÊÕ¹ºÐèÒª
- ×î±ê×¼µÄ¶þÊÖ³µÂòÂôºÏͬ£¨¾«Ñ¡6ƪ£©(×î
- ¹ØÓÚÆ¸ÓýÌʦµÄÐÒ飨ÕûÀí15ƪ£©(½Ìʦ
- ²úÆ·ÏúÊÛÐÒé·¶±¾£¨¾«Ñ¡17ƪ£©(²úÆ·ºÏ
- ÃèдÇŵĴÊÓ¾«Ñ¡6ƪ£©(ÃèдÇŵĴÊÓï
- ºÏͬÎïÁ÷£¨¾«Ñ¡11ƪ£©(ºÏͬÎïÁ÷ÆóÒµ)
- ÁùÄê¼¶ÓïÎÄϲáµÚËĵ¥Ôª²âÑéÌ⣨½õ¼¯5
- ÐÂÄê×£ÀÏʦʲôдº×£¸£Ó¾«Ñ¡16ƪ£©
- Ó¢Óï×ùÓÒÃú£¨½õ¼¯5ƪ£©(¾µäÓ¢ÎÄ×ùÓÒÃú
- Á÷¶¯È˿ڹÜÀí¹¤×÷»ã±¨£¨¼¯½õ17ƪ£©(Á÷
- ÃÀʳÓö¼ûÊ«´Ê£¨¹²8ƪ£©(ÃÀʳÓö¼ûÊ«´Ê)
- ºÓ±±Ê¡¼¼ÊõÊг¡ÌõÀý£¨ÍƼö7ƪ£©(ºÓ±±Ê¡
- ÐÎÈÝÒ»¸öÈ˵ÄÉ˸оä×Ó£¨¾«Ñ¡4ƪ£©(ÐÎÈÝ
- »é¼ÙÇë¼ÙÌõÄ£°å£¨¹²12ƪ£©(»é¼ÙÇë¼ÙÌõ
- ¹ã¸æ²ß»®ÊéµÄ׫д֮¹úÄڵĴú±íÖ÷ÕÅ£¨Í¨
- ÎåÒ»ÀͶ¯½ÚÃÀÈÝÔº»î¶¯·½°¸£¨¾«Ñ¡18ƪ£©
- ·¢»Ó¸öÈ˼òÀúµÄ¼ÛÖµ£¨¾«Ñ¡11ƪ£©(¸öÈË
- ÐÎÈÝÄïÁ©¸ÐÇéºÃµÄ¾ä×Ó£¨¹²4ƪ£©(ÐÎÈÝÄï
- ³õ¶þѧÉúÉÏ¿Î˯¾õ¼ìÌÖÊ飨¾«Ñ¡15ƪ£©(
- ¼ò¶Ìлé×£´ÊËÍÅóÓÑ£¨½õ¼¯5ƪ£©(¼ò¶ÌÐÂ




