µÚÎåÕ´𰸠ÏÂÔØ±¾ÎÄ

Ò»¡¢Ñ¡ÔñÌâ

1£®ÔÚÏÂÁÐÑ¡ÏîÖУ¬²»ÊôÓÚ±¨±í¹¦ÄܵÄÊÇ£¨ £© A£©·Ö×é×éÖ¯Êý¾Ý£¬½øÐлã×Ü B£©¸ñʽ»¯Êý¾Ý

C£©½¨Á¢²éѯ D£©°üº¬×Ó±¨±í¼°Í¼±íÊý¾Ý 2£®ÒÔÏÂÐðÊöÕýÈ·µÄÊÇ£¨ £©

A£©±¨±íÖ»ÄÜÊäÈëÊý¾Ý B£©±¨±íÖ»ÄÜÊä³öÊý¾Ý C£©±¨±í¿ÉÒÔÊäÈëºÍÊä³öÊý¾Ý D£©±¨±í²»ÄÜÊäÈëºÍÊä³öÊý¾Ý 3£®¡°´òÓ¡Ô¤ÀÀ¡±ÊÓͼÓÃÓÚ£¨ £©¡£

A£©ÓÃÀ´´´½¨ºÍ±à¼­±¨±íµÄ½á¹¹ B£©ÓÃÀ´²é¿´±¨±íµÄÒ³ÃæÊý¾ÝÊä³öÐÎ̬ C£©ÓÃÀ´²é¿´±¨±íµÄ°æÃæÉèÖà D£©ÒÔÉ϶¼°üº¬ 4£®¡°°æÃæÔ¤ÀÀ¡±ÊÓͼÏÔʾÊý¾Ý£¨ £© A£©È«²¿ B£©Ò»Ò³ C£©µÚÒ»Ò³ D£©²¿·Ö 5£®ÏÂÁÐÑ¡ÏîÖУ¬²»ÊôÓÚ±¨±í½á¹¹µÄÊÇ£¨ £©

A£©±¨±íҳü B£©Ö÷Ìå C£©×éҳü½Ú D£©Ò³ÃæÒ³Ã¼ 6£®ÓÃÀ´ÏÔʾ±¨±íÖÐ×Ö¶ÎÃû³Æ»ò¶Ô¼Ç¼µÄ·Ö×éÃû³ÆµÄÊÇ£¨ £©¡£ A£©±¨±íҳü B£©Ö÷Ìå C£©×éҳü D£©Ò³ÃæÒ³Ã¼

7£®ÒªÉèÖÃÖ»Óб¨±í×îºóÒ»Ò³Ö÷ÌåÄÚÈÝÖ®ºóÊä³öµÄÐÅÏ¢£¬ÐèÒªÉèÖ㨠£© A£©±¨±íҳü B£©±¨±íÒ³½Å C£©Ò³ÃæÒ³Ã¼ D£©Ò³ÃæÒ³½Å 8£®ÔÚ±¨±íÉè¼ÆÇøÖУ¬£¨ £©Í¨³£ÓÃÀ´ÏÔʾÊý¾ÝµÄÁбêÌâ¡£ A£©×éÒ³½Å½Ú B£©Ö÷Ìå½Ú C£©±¨±íÒ³½Å½Ú D£©Ò³ÃæÒ³Ã¼½Ú 9£®ÔÚ±¨±íÉè¼ÆÖУ¬ÒÔÏ¿ÉÒÔ×ö°ó¶¨¿Ø¼þÏÔʾ×Ö¶ÎÊý¾ÝµÄÊÇ£¨ £© A£©Îı¾¿ò B£©±êÇ© C£©ÃüÁî°´Å¥ D£©Í¼Ïñ

10£®ÒªÊµÏÖ±¨±í°´Ä³×ֶηÖ×éͳ¼ÆÊä³ö£¬ÐèÒªÉèÖ㨠£© A£©±¨±íÒ³½Å B£©¸Ã×Ö¶Î×éÒ³½Å C£©Ö÷Ìå D£©Ò³ÃæÒ³½Å 11£®±êÇ©¿Ø¼þͨ³£Í¨¹ý£¨ £©Ïò±¨±íÖÐÌí¼Ó A£©¹¤¾ßÏä B£©¹¤¾ßÀ¸ C£©ÊôÐÔ±í D£©×Ö¶ÎÁбí

12£®¼ÆËã¿Ø¼þµÄ¿Ø¼þÀ´Ô´ÊôÐÔÒ»°ãÉèÖõĿªÍ·¼ÆËã±í´ïʽÊÇ£¨ £© A£©¡°=¡± B£©¡°-¡± C£©¡°>¡± D£©¡°<¡± 13£®ÏÂÁÐÑ¡ÏîÖУ¬²»ÊôÓÚ±¨±í´´½¨·½Ê½µÄÊÇ£¨ £©

A£©Ê¹ÓÃÃüÁî B£©Ê¹Óá°Éè¼Æ¡±ÊÓͼ¹¦ÄÜ C£©¡°×Ô¶¯±¨±í¡±¹¦ÄÜ D£©Ê¹ÓÃÏòµ¼¹¦ÄÜ

14£®Ê¹Ó㨠£©´´½¨±¨±í£¬¿ÉÒÔÍê³É´ó²¿·Ö±¨±íÉè¼Æ»ù±¾²Ù×÷£¬¼Ó¿ìÁË´´½¨±¨±íµÄ¹ý³Ì¡£

A£©Ê¹ÓÃÃüÁî B£©Ê¹Óá°Éè¼Æ¡±ÊÓͼ¹¦ÄÜ C£©×Ô¶¯±¨±í¹¦ÄÜ D£©Ê¹ÓÃÏòµ¼¹¦ÄÜ

15£®ÈôʹÓá°Í¼±íÏòµ¼¡±´´½¨±¨±í£¬ÐèÔÚ¡°Ð½¨±¨±í¡±ÖÐÑ¡Ôñ£¨ £© A£©±¨±íÏòµ¼ B£©Í¼±íÏòµ¼ C£©Éè¼ÆÊÓͼ D£©±êÇ©Ïòµ¼

16£®Óû§¿ÉÒÔÔÚ£¨ £©ÊÓͼÖУ¬¶ÔÒÑÉú³ÉµÄͼ±í±¨±í½øÐнøÒ»²½Ð޸ĺÍÍêÉÆ¡£ A£©Éè¼ÆÊÓͼ B£©Í¼±íÊÓͼ C£©±í¸ñÊÓͼ D£©±êÇ©ÊÓͼ 17£®±à¼­±¨±íÖ÷Òª°üÀ¨£¨ £©

A£©ÉèÖñ¨±í¸ñʽ¡¢±à¼­Í¼±í±¨±í¡¢Ò³Â뼰ʱ¼äÈÕÆÚ B£©ÉèÖñ¨±í¸ñʽ¡¢Ìí¼Ó±³¾°Í¼Æ¬¡¢Ò³Â뼰ʱ¼äÈÕÆÚ C£©±à¼­Í¼±í±¨±í¡¢Ìí¼Ó±³¾°Í¼Æ¬¡¢Ò³Â뼰ʱ¼äÈÕÆÚ D£©ÉèÖñ¨±íÀàÐÍ¡¢Ìí¼Ó±³¾°Í¼Æ¬¡¢Ò³Â뼰ʱ¼äÈÕÆÚ

18£®ÔÚACCESS±¨±íÖУ¬£¨ £©»áÒÔ¶ÌÐéÏß±êÖ¾ÔÚ±¨±íµÄ×ó±ß½çÉÏ A£©·Ö½Ú·û B£©·ÖÒ³·û C£©»ã×ÜÖµ D£©Ò³Âë

19£®¼ÆËãËùÓÐÔ±¹¤¡°»ù±¾¹¤×Ê¡±µÄ×ܼÆÖµ£¬ÐèÉèÖÿؼþÔ´ÊôÐÔΪ£¨ £© A£©=sum([»ù±¾¹¤×Ê]) B£©=avg([»ù±¾¹¤×Ê]) C£©=sum[»ù±¾¹¤×Ê] D£©=avg[»ù±¾¹¤×Ê]

20£®ÔÚÒÑÓб¨±íÖд´½¨×Ó±¨±í£¬Ðèµ¥»÷¹¤¾ßÏäÖеģ¨ £©°´Å¥ A£©×Ó±¨±í B£©×Ó´°Ìå C£©¿Ø¼þÏòµ¼ D£©×Ó´°Ìå/×Ó±¨±í

¶þ¡¢Ìî¿ÕÌâ

1£®±¨±íºÍ´°ÌåµÄÇø±ðÔÚÓÚ±¨±í¿ÉÒԶԼǼÅÅÐòºÍ·Ö×飬¶ø²»ÄÜÌí¼Ó¡¢É¾³ý¡¢Ð޸ļǼ¡£

2£®±¨±íµÄ»ù±¾¹¦ÄÜÊÇÓÃÀ´ÏÔʾ¸ñʽ»¯µÄÊý¾Ý¡£

3£®ÓÃÀ´ÏÔʾ±¨±íµÄ±êÌ⡢ͼÐλò˵Ã÷ÐÔÎÄ×ÖµÄÊDZ¨±íҳü¡£ 4£®¿ÉÒÔ´Ó±í¡¢²éѯ¡¢´°Ìå¡¢±¨±íµ¼³öHTMLÎĵµ¡£

5£®´ÓÊÓͼ²Ëµ¥ÖÐÑ¡ÔñÅÅÐòÓë·Ö×éÃüÁ¿ÉÒÔ¶Ô×éÒ³ÃæºÍ×éÒ³½Å½øÐе¥¶ÀÉèÖᣠ6£®ACCESSÌṩ3ÖÖ´´½¨±¨±íµÄ·½Ê½£ºÊ¹ÓÃÏòµ¼¹¦ÄÜ¡¢Ê¹ÓÃ×Ô¶¯±¨±í¹¦ÄܺÍʹÓÃÉè¼ÆÊÓͼ´´½¨¡£

7£®±¨±íҳüµÄÄÚÈÝÖ»ÔÚ±¨±íµÄµÚÒ»Ò³Ï´òÓ¡Êä³ö¡£

8£®ÔÚACCESSÖУ¬Í¨¹ýͼ±íÏòµ¼¿ÉÒÔ½«Êý¾ÝÒÔͼ±íÐÎʽÏÔʾ³öÀ´¡£ 9£®Í¨¹ýʹÓÃÅÅÐòÓë·Ö×éÃüÁ¿ÉÒÔʵÏÖ±¨±íµÄÅÅÐò¼°·Ö×éͳ¼Æ¹¦ÄÜ¡£ 10£®ÔÚACCESSÖУ¬Ò»¸öÖ÷±¨±í×î¶àÄܰüº¬Á½¼¶×Ó´°Ìå»ò×Ó±¨±í¡£