皮皮学，免费搜题
登录
logo - 刷刷题
搜题
【简答题】
考生文件夹下存在一个数据库文件“samp2．mdb”，里面已经设计好表对象“tEmployee”、“tSell”和“tBook”，试按以下要求完成设计： (1)创建一个查询，查找并显示单价高于平均单价的图书“书名”和“出版社名称”等字段内容，所建查询名为“qT1”。 (2)创建一个查询，按输入的售出日期查找某日期的售书情况，并按数量降序显示“姓名”、“书名”、“数量”三个字段的内容，所建查询名为“qT2”；当运行该查询时，应显示参数提示信息：“请输入售出日期”。 (3)创建一个查询，查找单价大于等于15且小于等于20的图书，并显示“书名”、“单价”、“作者名”和“出版社名称”四个字段的内容，所建查询名为“qT3”。 (4)创建一个查询，统计每名雇员的售书总量，并将显示的字段名设为“姓名”和“总数量”，所建查询名为“qT4”。
手机使用
分享
复制链接
新浪微博
分享QQ
微信扫一扫
微信内点击右上角“…”即可分享
反馈
参考答案：
举一反三
【简答题】Power supplies use____________ capacitors which can hold a erous charge for many hours. Make sure you______________ power supplies before you start working on them by keeping a_____________ connec...
查看完整题目与答案
【单选题】My father often _____ me _____  chess. [     ]
A.
help, at
B.
help, with
C.
helps, at
D.
helps, with
查看完整题目与答案
【单选题】By choosing your target customers, you can ________.
A.
learn how much you can charge for each dish
B.
decide on what kind of food to offer them
C.
know the cost of running the restaurant
D.
predict how many customers will arrive
查看完整题目与答案
【单选题】Li Lei often ____ Lin Tao ____ his English.
A.
help; to
B.
helps; with
C.
helps; to
D.
help; with
查看完整题目与答案
【单选题】留置权人与债务人没有约定留置财产后的债务履行期间的，留置权人应当给债务人的履行债务的期间最短为（ ）。
A.
1个月
B.
2个月
C.
3个月
D.
6个月
查看完整题目与答案
【单选题】Miss Zhao is very helpful. She often helps us ____we are in trouble.
A.
whether
B.
although
C.
whenever
D.
however
查看完整题目与答案
【单选题】She often ______ little brother ______ his homework. [     ]
A.
helps; doing
B.
helps; do
C.
help; to do
D.
helps; does
查看完整题目与答案
【简答题】Customer: Could you please tell me what kinds of rate plans you have? Julie: We have a wide 1 of rate plans for you to choose from, which can fully meet the needs of our customers. Do you trave...
查看完整题目与答案
【简答题】Tips to Stay Safe on a School Trip School trips can be great fun. But don't get hurt when you go on a school trip. Here are some tips for you. ★ Listen to the teacher. ★ On the bus, always wear seat b...
查看完整题目与答案
【简答题】Tips to Stay Safe on a School Trip School trips can be great fun. But don't get hurt when you go on a school trip. Here are some tips for you. ★ Listen to the teacher. ★ On the bus, always wear seat b...
查看完整题目与答案
相关题目：
【简答题】Power supplies use____________ capacitors which can hold a erous charge for many hours. Make sure you______________ power supplies before you start working on them by keeping a_____________ connec...
查看完整题目与答案
【单选题】My father often _____ me _____  chess. [     ]
A.
help, at
B.
help, with
C.
helps, at
D.
helps, with
查看完整题目与答案
【单选题】By choosing your target customers, you can ________.
A.
learn how much you can charge for each dish
B.
decide on what kind of food to offer them
C.
know the cost of running the restaurant
D.
predict how many customers will arrive
查看完整题目与答案
【单选题】Li Lei often ____ Lin Tao ____ his English.
A.
help; to
B.
helps; with
C.
helps; to
D.
help; with
查看完整题目与答案
【单选题】留置权人与债务人没有约定留置财产后的债务履行期间的，留置权人应当给债务人的履行债务的期间最短为（ ）。
A.
1个月
B.
2个月
C.
3个月
D.
6个月
查看完整题目与答案
【单选题】Miss Zhao is very helpful. She often helps us ____we are in trouble.
A.
whether
B.
although
C.
whenever
D.
however
查看完整题目与答案
【单选题】She often ______ little brother ______ his homework. [     ]
A.
helps; doing
B.
helps; do
C.
help; to do
D.
helps; does
查看完整题目与答案
【简答题】Customer: Could you please tell me what kinds of rate plans you have? Julie: We have a wide 1 of rate plans for you to choose from, which can fully meet the needs of our customers. Do you trave...
查看完整题目与答案
【简答题】Tips to Stay Safe on a School Trip School trips can be great fun. But don't get hurt when you go on a school trip. Here are some tips for you. ★ Listen to the teacher. ★ On the bus, always wear seat b...
查看完整题目与答案
【简答题】Tips to Stay Safe on a School Trip School trips can be great fun. But don't get hurt when you go on a school trip. Here are some tips for you. ★ Listen to the teacher. ★ On the bus, always wear seat b...
查看完整题目与答案
参考解析：
知识点：
题目纠错 0
发布
创建自己的小题库 - 刷刷题