²Ù×÷²½Ö裺
£¨1£©´ò¿ª½Ìѧ¹ÜÀíÊý¾Ý¿â£¬´ò¿ª½Ìʦ±í¡£
£¨2£©ÔÚ¡°¿ªÊ¼¡±Ñ¡ÏµÄ¡°ÅÅÐòºÍɸѡ¡±×éÖУ¬µ¥»÷¡°¸ß¼¶¡±°´Å¥£¬ÔÚ´ò¿ªµÄÏÂÀÁбíÖУ¬µ¥»÷¡°°´´°Ìåɸѡ¡±ÃüÁÈçͼ1-49Ëùʾ¡£
£¨3£©Õâʱ´ò¿ªÒ»¸öÉè¼Æ´°¿Ú£¬Æä´°¿Ú·ÖΪÁ½¸ö´°¸ñ£¬Éϲ¿´°¸ñÏÔʾ¡°½Ìʦ¡±±í£¬Ï²¿ÊÇÉèÖÃɸѡÌõ¼þµÄ´°¸ñ¡£ÏÖÔÚÒѾ°Ñ¡°³öÉúÈÕÆÚ¡±×Ö¶Î×Ô¶¯Ìí¼Óµ½Ï²¿´°¸ñÖС£
£¨4£©ÔÚµÚ1ÁеÄÌõ¼þµ¥Ôª¸ñÖÐÊäÈë¡°Month([¹¤×÷ʱ¼ä])=9¡±£¬ÔÚµÚ2ÁеĻòµ¥Ôª¸ñÖÐÊäÈë¡°µ³Ô±¡±Èçͼ1-49 Ëùʾ¡£
ͼ1-49ɸѡÊÓͼ
£¨5£©µ¥»÷¡°ÅÅÐòºÍɸѡ¡±×éÖеġ°Çл»É¸Ñ¡¡±°´Å¥£¬ÏÔʾɸѡµÄ½á¹û¡£
£¨6£©Èç¹û¾³£½øÐÐͬÑùµÄ¸ß¼¶É¸Ñ¡£¬¿ÉÒ԰ѽá¹û±£´æÏÂÀ´ÖØÐ´ò¿ª¡°¸ß¼¶¡±É¸Ñ¡ÁÐ±í£¬ÓÒ¼üµ¥»÷¡°½Ìʦ±í¡±´°¸ñ£¬ÔÚµ¯³ö²Ëµ¥Öе¥»÷¡°Áí´æÎª²éѯ¡±ÃüÁÈçͼ1-50Ëùʾ¡£ÔÚ´ò¿ªµÄÃüÃû¶Ô»°¿ò£¬Îª¸ß¼¶É¸Ñ¡ÃüÃû¡£Ôڸ߼¶É¸Ñ¡ÖУ¬»¹¿ÉÒÔÌí¼Ó¸ü¶àµÄ×Ö¶ÎÁкÍÉèÖøü¶àµÄɸѡÌõ¼þ¡£
¸ß¼¶É¸Ñ¡Êµ¼ÊÉÏÊÇ´´½¨ÁËÒ»¸ö²éѯ£¬Í¨¹ý²éѯ¿ÉÒÔʵÏÖ¸÷ÖÖ¸´ÔÓÌõ¼þµÄɸѡ¡£É¸Ñ¡ºÍ²éѯ²Ù×÷ÊǽüÒåµÄ£¬¿ÉÒÔ˵ɸѡÊÇÒ»ÖÖÁÙʱµÄÊÖ¶¯²Ù×÷£¬¶ø²éѯÔòÊÇÒ»ÖÖÔ¤Ïȶ¨ÖƲÙ×÷£¬ÔÚAccess Öвéѯ²Ù×÷¾ßÓиüÆÕ±éÒâÒå¡£
ͼ1-50¸ß¼¶É¸Ñ¡Áí´æÎª²éѯ²Ëµ¥
ʵÑéÒ»Êý¾Ý¿â¼°±íµÄ²Ù×÷
Ò»¡¢ÊµÑéÄ¿µÄ
1£®ÕÆÎÕÊý¾Ý¿âµÄ´´½¨¼°ÆäËü¼òµ¥²Ù×÷
2£®ÊìÁ·ÕÆÎÕÊý¾Ý±í½¨Á¢¡¢Êý¾Ý±íά»¤¡¢Êý¾Ý±íµÄ²Ù×÷
¶þ¡¢ÊµÑéÄÚÈÝÓëÒªÇó
1£®Êý¾Ý¿âµÄ´´½¨¡¢´ò¿ª¡¢¹Ø±Õ
2£®Êý¾Ý±íµÄ´´½¨£º½¨Á¢±í½á¹¹¡¢ÉèÖÃ×Ö¶ÎÊôÐÔ¡¢½¨Á¢±íÖ®¼ä¹ØÏµ¡¢Êý¾ÝµÄÊäÈë 3£®Êý¾Ý±íά»¤£º´ò¿ª±í¡¢¹Ø±Õ±í¡¢µ÷Õû±íÍâ¹Û¡¢Ð޸ıí½á¹¹¡¢±à¼±íÄÚÈÝ 4£®Êý¾Ý±íµÄ²Ù×÷£º²éÕÒÌæ»»Êý¾Ý¡¢ÅÅÐò¼Ç¼¡¢É¸Ñ¡¼Ç¼
Èý¡¢ÊµÑé²½Öè
°¸ÀýÒ»£º´´½¨Êý¾Ý¿â
1£®´´½¨¿ÕÊý¾Ý¿â
ÒªÇ󣺽¨Á¢¡°½Ìѧ¹ÜÀí¡±Êý¾Ý¿â¡£ ²Ù×÷²½Ö裺
ͼ1-1´´½¨½Ìѧ¹ÜÀíÊý¾Ý¿â
£¨1£©ÔÚAccess 2010Æô¶¯´°¿ÚÖУ¬ÔÚÖм䴰¸ñµÄÉÏ·½£¬µ¥»÷¡°¿ÕÊý¾Ý¿â¡±£¬ÔÚÓҲര¸ñµÄÎļþÃûÎı¾¿òÖУ¬¸ø³öÒ»¸öĬÈϵÄÎļþÃû¡°Database1.accdb¡±¡£°ÑËüÐÞ¸ÄΪ¡°½Ìѧ¹ÜÀí¡±Èçͼ1-1Ëùʾ¡£
£¨2£©µ¥»÷°´Å¥£¬ÔÚ´ò¿ªµÄ¡°Ð½¨Êý¾Ý¿â¡±¶Ô»°¿òÖУ¬Ñ¡ÔñÊý¾Ý¿âµÄ±£´æÎ»Ö㬵¥»÷¡°È·¶¨¡±°´Å¥£¬Èçͼ1-2Ëùʾ¡£
£¨3£©Õâʱ·µ»Øµ½accessÆô¶¯½çÃæ£¬ÏÔʾ½«Òª´´½¨µÄÊý¾Ý¿âµÄÃû³ÆºÍ±£´æÎ»Öã¬Èç¹ûÓû§Î´ÌṩÎļþÀ©Õ¹Ãû£¬access½«×Ô¶¯Ìí¼ÓÉÏ¡£
£¨4£©ÔÚÓҲര¸ñÏÂÃæ£¬µ¥»÷¡°´´½¨¡±ÃüÁî°´Å¥£¬Èçͼ1-1Ëùʾ¡£
£¨5£©Õâʱ¿ªÊ¼´´½¨¿Õ°×Êý¾Ý¿â£¬×Ô¶¯´´½¨ÁËÒ»¸öÃû³ÆÎª±í1µÄÊý¾Ý±í£¬²¢ÒÔÊý¾Ý±íÊÓͼ·½Ê½´ò¿ªÕâ¸ö±í1,Èçͼ1-3Ëùʾ¡£
Accessº¯Êý±í´ïʽµÄʾÀý
ÔÚ Microsoft Access ÖÐÐí¶à²Ù×÷Öж¼ÒªÊ¹Óñí´ïʽ£¬°üÀ¨´´½¨¼ÆËã¿Ø¼þ¡¢²éѯ¡¢É¸Ñ¡×¼Ôò¡¢Ä¬ÈÏÖµ¡¢ÓÐЧÐÔ¹æÔòºÍºêµÄÌõ¼þ¡£Í¨³££¬´´½¨±í´ïʽ×î¼ò½ÝµÄ·½·¨¾ÍÊÇÕÒµ½ÀàËÆµÄ±í´ïʽʾÀý£¬È»ºó¶ÔËü½øÐÐÐ޸ġ£ ÇëÑ¡Ôñ£º
Ò»¡¢ ÓÃÓÚ´°ÌåºÍ±¨±íÖеıí´ïʽʾÀý 1¡¢ ´¦Àí´°ÌåºÍ±¨±íÖÐÎı¾ÖµµÄʾÀý
ϱíÁгöÁË¿ÉÔÚ´°ÌåºÍ±¨±íµÄ¼ÆËã¿Ø¼þÖÐʹÓõıí´ïʽʾÀý£º ±í´ïʽ =\=[ÐÕÊÏ] & \Ãû×Ö] =Left([²úÆ·Ãû³Æ], 1) =Right([×ʲú´úÂë], 2) =Trim([µØÖ·]) =IIf(IsNull([µØÇø]), [³ÇÊÐ] & \ÓÊÕþ±àÂë], [³ÇÊÐ] & \µØÇø] & \ \ÓÊÕþ±àÂë]) ˵Ã÷ ÏÔʾ N/A¡£ ÏÔʾ¡°ÐÕÊÏ¡±¿Ø¼þºÍ¡°Ãû×Ö¡±¿Ø¼þµÄÖµ£¬Á½ÕßÖ®¼äÒÔ¿Õ¸ñ¸ô¿ª¡£ ʹÓà Left º¯ÊýÏÔʾ¡°²úÆ·Ãû³Æ¡±¿Ø¼þÖµµÄµÚÒ»¸ö×Ö·û¡£ ʹÓà Right º¯ÊýÏÔʾ¡°×ʲú´úÂ롱¿Ø¼þÖµµÄ×îºóÁ½¸ö×Ö·û¡£ ʹÓà Trim º¯ÊýÏÔʾ¡°µØÖ·¡±¿Ø¼þµÄÖµ£¬²¢ÇÒɾ³ýÊ×βµÄ¿Õ¸ñ¡£ Èç¹û¡°µØÇø¡±ÖµÎª Null ÔòʹÓà IIf º¯ÊýÏÔʾ¡°³ÇÊС±ºÍ¡°ÓÊÕþ±àÂ롱¿Ø¼þµÄÖµ£¬·ñÔòÏÔʾ¡°³ÇÊС±¡¢¡°µØÇø¡±ºÍ¡°ÓÊÕþ±àÂ롱¿Ø¼þµÄÖµ£¬ÖмäÒÔ¿Õ¸ñ·Ö¸ô¡£ ×¢ÊÍ
¼ÆËã¿Ø¼þÖеıí´ïʽӦʹÓà = ²Ù×÷·û¿ªÍ·¡£
ÔÚÉèÖüÆËã¿Ø¼þµÄ Name ÊôÐÔʱ£¬Ó¦È·±£Ê¹ÓÃΨһµÄÃû³Æ¡£²»ÒªÊ¹Óñí´ïʽÖÐʹÓõĿؼþÃû³Æ¡£
Left º¯Êý
·µ»Ø Variant (String)£¬ÆäÖаüº¬×Ö·û´®ÖдÓ×ó±ßËãÆðÖ¸¶¨ÊýÁ¿µÄ×Ö·û¡£ Óï·¨
Left(string, length)
Left º¯ÊýµÄÓï·¨ÓÐÏÂÃæµÄÃüÃû²ÎÊý£º ²¿·Ö string ˵Ã÷ ±ØÒª²ÎÊý¡£×Ö·û´®±í´ïʽÆäÖÐ×î×ó±ßµÄÄÇЩ×Ö·û½«±»·µ»Ø¡£Èç¹û string °üº¬ Null£¬½«·µ»Ø Null¡£ length ±ØÒª²ÎÊý£»Îª Variant (Long)¡£ÊýÖµ±í´ïʽ£¬Ö¸³ö½«·µ»Ø¶àÉÙ¸ö×Ö·û¡£Èç¹ûΪ 0£¬·µ»ØÁ㳤¶È×Ö·û´® (\¡£Èç¹û´óÓÚ»òµÈÓÚ string µÄ×Ö·ûÊý£¬Ôò·µ»ØÕû¸ö×Ö·û´®¡£ ˵Ã÷£ºÓûÖª string µÄ×Ö·ûÊý£¬Ê¹Óà Len º¯Êý¡£
×¢Ò⣺LeftB º¯Êý×÷ÓÃÓÚ°üº¬ÔÚ×Ö·û´®ÖеÄ×Ö½ÚÊý¾Ý¡£ËùÒÔ length Ö¸¶¨µÄÊÇ×Ö½ÚÊý£¬¶ø²»
ÊÇÒª·µ»ØµÄ×Ö·ûÊý¡£
Right º¯Êý
·µ»Ø Variant (String)£¬ÆäÖаüº¬´Ó×Ö·û´®ÓÒ±ßÈ¡³öµÄÖ¸¶¨ÊýÁ¿µÄ×Ö·û¡£ Óï·¨
Right(string, length)
Right º¯ÊýµÄÓï·¨¾ßÓÐÏÂÃæµÄÃüÃû²ÎÊý£º ²¿·Ö string length ˵Ã÷ ±ØÒª²ÎÊý¡£×Ö·û´®±í´ïʽ£¬´ÓÖÐ×îÓұߵÄ×Ö·û½«±»·µ»Ø¡£Èç¹û string °üº¬ Null£¬½«·µ»Ø Null¡£ ±ØÒª²ÎÊý£»Îª Variant (Long)¡£ÎªÊýÖµ±í´ïʽ£¬Ö¸³öÏë·µ»Ø¶àÉÙ×Ö·û¡£Èç¹ûΪ 0£¬·µ»ØÁ㳤¶È×Ö·û´® (\¡£Èç¹û´óÓÚ»òµÈÓÚ string µÄ×Ö·ûÊý£¬Ôò·µ»ØÕû¸ö×Ö·û´®¡£ ˵Ã÷£ºÓûÖª string µÄ×Ö·ûÊý£¬Óà Len º¯Êý¡£ ×¢Ò⣺RightB º¯Êý×÷ÓÃÓÚ°üº¬ÔÚ×Ö·û´®ÖеÄ×Ö½ÚÊý¾Ý¡£ËùÒÔ length Ö¸¶¨µÄÊÇ×Ö½ÚÊý£¬¶ø²»
ÊÇÖ¸¶¨·µ»ØµÄ×Ö·ûÊý¡£
LTrim¡¢RTrimÓë Trim º¯Êý ·µ»ØVariant (String)£¬ÆäÖаüº¬Ö¸¶¨×Ö·û´®µÄ¿½±´£¬Ã»ÓÐǰµ¼¿Õ°× (LTrim)¡¢Î²Ëæ¿Õ°× (RTrim) »òǰµ¼ºÍÎ²Ëæ¿Õ°× (Trim)¡£ Óï·¨
LTrim(string) RTrim(string) Trim(string)
±ØÒªµÄstring²ÎÊý¿ÉÒÔÊÇÈκÎÓÐЧµÄ×Ö·û´®±í´ïʽ¡£Èç¹ûstring°üº¬Null£¬½«·µ»ØNull¡£
IIf º¯Êý
¸ù¾Ý±í´ïʽµÄÖµ£¬À´·µ»ØÁ½²¿·ÖÖÐµÄÆäÖÐÒ»¸ö¡£ Óï·¨
IIf(expr, truepart, falsepart)
IIf º¯ÊýµÄÓï·¨º¬ÓÐÏÂÃæÕâЩÃüÃû²ÎÊý£º ²¿·Ö expr ±ØÒª²ÎÊý¡£ÓÃÀ´ÅжÏÕæÎ±µÄ±í´ïʽ¡£ ÃèÊö truepart falsepart ±ØÒª²ÎÊý¡£Èç¹û expr Ϊ True£¬Ôò·µ»ØÕⲿ·ÖµÄÖµ»ò±í´ïʽ¡£ ±ØÒª²ÎÊý¡£Èç¹û expr Ϊ False£¬Ôò·µ»ØÕⲿ·ÖµÄÖµ»ò±í´ïʽ¡£ ˵Ã÷£ºÓÉÓÚ IIf »á¼ÆËã truepart ºÍ falsepart£¬ËäÈ»ËüÖ»·µ»ØÆäÖеÄÒ»¸ö¡£Òò´ËҪעÒâµ½Õâ¸ö
¸±×÷Óá£ÀýÈ磬Èç¹û falsepart ²úÉúÒ»¸ö±»Áã³ý´íÎó£¬ÄÇô³ÌÐò¾Í»á·¢Éú´íÎ󣬼´Ê¹ expr Ϊ True¡£
Choose º¯Êý
´Ó²ÎÊýÁбíÖÐÑ¡Ôñ²¢·µ»ØÒ»¸öÖµ¡£ Óï·¨
Choose(index, choice-1[, choice-2, ... [, choice-n]])
Choose º¯ÊýµÄÓï·¨¾ßÓÐÒÔϼ¸¸ö²¿·Ö£º ²¿·Ö index choice ÃèÊö ±ØÒª²ÎÊý£¬ÊýÖµ±í´ïʽ»ò×ֶΣ¬ËüµÄÔËËã½á¹ûÊÇÒ»¸öÊýÖµ£¬ÇÒ½çÓÚ 1 ºÍ¿ÉÑ¡ÔñµÄÏîÄ¿ÊýÖ®¼ä¡£ ±ØÒª²ÎÊý£¬Variant ±í´ïʽ£¬°üº¬¿ÉÑ¡ÔñÏîÄ¿µÄÆäÖÐÖ®Ò»¡£ ˵Ã÷£ºChoose »á¸ù¾Ý index µÄÖµÀ´·µ»ØÑ¡ÔñÏîÁбíÖеÄij¸öÖµ¡£Èç¹û index ÊÇ 1£¬Ôò
Choose »á·µ»ØÁбíÖÐµÄµÚ 1 ¸öÑ¡ÔñÏî¡£Èç¹û index ÊÇ 2£¬Ôò»á·µ»ØÁбíÖÐµÄµÚ 2 ¸öÑ¡ÔñÏÒÔ´ËÀàÍÆ¡£
¿ÉÒÔʹÓà Choose À´²éÔÄÒ»¸öÁбíÖеÄÏîÄ¿¡£ÀýÈ磬Èç¹û index ËùÖ¸¶¨µÄֵΪ 3£¬¶ø choice-1 = \¡¢choice-2 = \¡¢ÇÒ choice-3 = \£¬ÄÇô Choose ½«·µ»Ø \¡£µ± index ´ú±íһѡÏî×éÖеÄֵʱ£¬ÔòÕâÏÄܽ«»áÌØ±ðÓÐÓá£
¼´Ê¹ËüÖ»·µ»ØÒ»¸öÑ¡ÏîÖµ£¬Choose ÈÔÈ»»á¼ÆËãÁбíÖеÄÿ¸öÑ¡ÔñÏî¡£ËùÒÔÓ¦¸Ã×¢Òâµ½ÕâÏ×÷Óá£ÀýÈ磬µ±ÔÚÿ¸öÑ¡ÔñÏî±í´ïʽÖÐʹÓÃÁË MsgBox º¯Êý×÷ΪÆäÖеÄÒ»²¿·Öʱ£¬Ã¿¼ÆËãÒ»¸öÑ¡ÔñÏ¾Í»áÏÔʾһ´ÎÏûÏ¢¿ò¡£
µ± indexСÓÚ 1 »ò´óÓÚÁгöµÄÑ¡ÔñÏîÊýĿʱ£¬Choose º¯Êý·µ»Ø Null¡£
Èç¹û index ²»ÊÇÕûÊý£¬Ôò»áÏÈËÄÉáÎåÈëΪÓëÆä×î½Ó½üµÄÕûÊý¡£
If...Then...Else Óï¾ä
¸ù¾Ý±í´ïʽµÄÖµÓÐÌõ¼þµØÖ´ÐÐÒ»×éÓï¾ä¡£ Óï·¨
If condition Then [statements][Else elsestatements]
»òÕߣ¬¿ÉÒÔʹÓÿéÐÎʽµÄÓï·¨£º
If condition Then