未分类题

在“入学登记表．mdb”数据库中有入学登记表、系和专业表。
(1)以入学登记表为数据源，创建参数查询“查询1”，实现输入ID号显示入学信息。参数提示为“请输入ID”，结果显示入学登记的全部信息。查询结果如图所示。

(2)以入学登记表、系和专业表为数据源，创建查询“查询2”，实现统计每个系的招数人数。结果显示系名称和人数字段，人数即[入学登记表][ID]之Count。查询结果如图所示。

A.mdb”数据库中有入学登记表、系和专业表。
B.shangxueba.cn/images/ct_ctajm_simpapp_00038(20092)1.jpg'
C.shangxueba.cn/images/ct_ctajm_simpapp_00038(20092)2.jpg'

【参考答案】

<上一题目录下一题>

热门试题

未分类题

●One ofthe main resposibilities ofICMP is to report (71). Although technology has produced increasingly reliable transmission media, errors still exist and must be handled. IP is an (72) protocol. This means that error checking and error control are not a concem ofIP.ICMP was designed, in part, to compensate for this shortcoming. Howerver, ICMP does not _(73) errors, it simply reports them. Error correction is left to the higher-level potocols. Error messages are always sent to the original__(74) because the only information available in the datagram about the route is the source and destination lP addresses. ICMP uses the source IP address to send the error massage to the source ofthe(75) . (71) A, numbers B. functions C. strings D. errors(72) A. reliable B. unreliable C. available D. unavailable(73) A. correct B. conduct C. produce D. connect(74)A. user B. destination C. source D. program(75) A. datagram B. frame C. service D. protocol

未分类题

下列给定程序中，函数fun()的功能是：将长整型数中每一位上为偶数的数依次取出，构成一个新数放在冲。高位仍在高位，低位仍在低位。例如，当s中的数为87653142时，t中的数为8642。请改正程序中的错误，使它能得出正确的结果。注意：不要改动main,~数，不得增行或删行，也不得更改程序的结构。试题程序： include ＜conio.h＞ include ＜stdio.h＞ void fun(long s,long *t) ********************************** { int d; long s1=l; *t=0; while(s＞0) { d=s%10; ********************************** if(d%2=0) {*t=d*sl+*t; sl*=10 } ********************************** s =10; } } main ( ) { long s,t; clrscr(); printf(' nPlease enter s: '); scanf ('%ld',&s); fun(s,&t); printf('The result is :%ld n',t); }

相关试题