¹ÜÀíÐÅϢϵͳ£¨ÉÏ»ú£©ÏîÄ¿4¿Æ´ïµçÄÔÐÅϢϵͳÉè¼Æ ÏÂÔر¾ÎÄ

ͼ2. 30

£¨ËÄ£©´´½¨¡°Êý¾Ý²éѯ×Óϵͳ¡±Òªµã

²éѯÊý¾Ý¿âÖеÄÊý¾Ý£¬Êǽ¨Á¢ÐÅϢϵͳµÄÖ÷ҪĿµÄ¡£ÔÚAccess Êý¾Ý¿âÖÐʹÓòéѯ¶ÔÏó½øÐвéѯ´¦Àí¡£

1. ´´½¨¡°°´²úÆ·´úÂë²éѯËùÓмÆËã»úϸ½Ú¡±µÄ²éѯ (1) ´´½¨²éѯ¶ÔÏó

ÔÚAccess Êý¾Ý¿âÖнøÐвéѯҪ²éѯ¶ÔÏó¡£ÔÚ¡°»ù±¾Êý¾Ý¡±Êý¾Ý¿â´°¿ÚÑ¡Ôñ¡°²éѯ¡±¶ÔÏó£¬Ë«»÷¡°ÔÚÉè¼ÆÊÓͼÖд´½¨²éѯ¡±Ñ¡ÏÈçͼ2.31 Ëùʾ¡£

ͼ2. 31

ÔÚ´ò¿ªµÄ²éѯÉè¼ÆÊÓͼÖлá³öÏÖ¡°ÏÔʾ±í¡±¶Ô»°¿ò£¬Èçͼ2.32 Ëùʾ¡£

ͼ2. 32

Ñ¡ÔñÒª²éѯµÄ±í¡°¼ÆËã»ú¡±£¬µ¥»÷¡¾Ìí¼Ó¡¿°´Å¥£¬ÔÙµ¥»÷¡¾¹Ø±Õ¡¿°´Å¥£¬²éѯÉè¼ÆÊÓͼÉϲ¿»á³öÏÖ¡°¼ÆËã»ú¡±±í£¬Èçͼ2.33 Ëùʾ¡£½«±íÖÐÐèÒª²éѯµÄ×Ö¶ÎÍÏקµ½Éè¼ÆÊÓͼϲ¿µÄ×Ö¶ÎÀ¸ÖУ¬Èçͼ2.33 Ëùʾ¡£½«Éè¼ÆÊÓͼ±£´æΪ¡°°´²úÆ·´úÂë²éѯ¡±£¬Ò»¸ö²éѯ¶ÔÏó¾Í´´½¨ºÃÁË¡£

ͼ2. 33

(2) ´´½¨²éѯ´°¿Ú

ΪÁË·½±ã²éѯ£¬ÐèÒª½¨Á¢Ò»¸ö²éѯ´°¿Ú¡£

ÔÚ¡°»ù±¾Êý¾Ý¡±Êý¾Ý¿â´°¿ÚÑ¡Ôñ¡°´°Ì塱¶ÔÏó£¬Ë«»÷¡°ÔÚÉè¼ÆÊÓͼÖд´½¨´°Ì塱ѡÏ´ò¿ª´°ÌåÉè¼ÆÊÓͼ£¬Èçͼ2.34 Ëùʾ¡£

ͼ2.34

ÔÚ¹¤¾ßÏäµ¥»÷Îı¾±êÇ©¿Ø¼þ°´Å¥£¬ÔÚ´°ÌåÉϵ¥»÷¿É²åÈëÒ»¸öÎÄ×Ö±êÇ©¿Ø¼þ£¬¿ÉÔڸÿؼþÖÐÊäÈëÎÄ×ÖÏÔʾÔÚ´°¿ÚÉÏ¡£Ñ¡ÔñÎÄ×Ö±êÇ©¿Ø¼þ£¬µ¥»÷ÓÒ¼üÑ¡Ôñ¡°ÊôÐÔ¡±£¬¿É´ò¿ª¡°±êÇ©¡±ÊôÐÔ¶Ô»°¿ò£¬Èçͼ2.35 Ëùʾ£¬ÔÚ¡°¸ñʽ¡±Ñ¡ÏîÏ¿ÉÒÔÉèÖÃÎÄ×ÖµÄ×ÖÌå¡¢´óСµÈÊôÐÔ¡£

ͼ2.35

ÔÚ¹¤¾ßÏäµ¥»÷×éºÏ¿ò¿Ø¼þ°´Å¥£¬ÔÚ´°ÌåÉϵ¥»÷²åÈë¸Ã¿Ø¼þ¡£Ñ¡Ôñ×éºÏ¿ò¿Ø¼þ£¬µ¥»÷ÓÒ¼üÑ¡Ôñ¡°ÊôÐÔ¡±£¬¿É´ò¿ª¡°×éºÏ¿ò¡±ÊôÐÔ¶Ô»°¿ò£¬ÔÚ¡°Êý¾Ý¡±Ñ¡ÏîÏ£¬Èçͼ2.36 Ëùʾ£¬µ¥»÷¡¾ÐÐÀ´Ô´¡¿À¸×îÓҶ˵İ´Å¥£¬¿É´ò¿ªSQL Óï¾ä¶Ô»°¿ò£¬Èçͼ2.37 ËùʾѡÔñ²úÆ·´úÂëµ½×Ö¶ÎÀ¸ÖУ¬È»ºó¹Ø±ÕSQL Óï¾ä¶Ô»°¿ò¡£ÉèÖÃÆäÊôÐÔºó£¬ÔÚ´°ÌåÖпÉÒÔÔÚ×éºÏ¿òÖÐ×Ô¶¯³öÏÖ¼ÆËã»ú²úÆ·´úÂë¡£½«´°ÌåÃüÃûΪ¡°°´²úÆ·´úÂë²éѯ´°¿Ú¡±¡£

ͼ2.36

ͼ2.37

(3) ±àд²éѯÌõ¼þ

²éѯ¶ÔÏó¡°°´²úÆ·´úÂë²éѯ¡±²éѯµÄÊÇËùÓеļÆËã»ú²úÆ·µÄÇé¿ö¡£Èç¹ûÒª¸ù¾Ý²úÆ·´úÂëÏÔʾ¸Ã²úÆ·µÄÇé¿öÐèÒªÉèÖòéѯÌõ¼þ¡£ÔÚÉè¼ÆÊÓͼ¡°°´²úÆ·´úÂë²éѯ¡±²éѯ¶ÔÏó£¬ÔÚ¡¾Ìõ¼þ¡¿À¸ÖÐÊäÈë[Forms]![°´²úÆ·´úÂë²éѯ´°¿Ú]![Combo1]£¬Èçͼ2.38 Ëùʾ¡£[Forms]´ú±í´°ÌåÀàÐÍ¡¢[°´²úÆ·´úÂë²éѯ]´ú±í´°ÌåÃû³Æ¡¢[Combo1]±íʾ×éºÏ¿ò¿Ø¼þÃû³Æ¡£