欢迎来到牛牛题库网 牛牛题库官网
logo

未知题型

在考生文件夹下完成如下简单应用: 1.用SQL语句完成下列操作:列出“林诗因”持有的所有外币的名称(源自rate_exchange表)以及持有数量(源自currency_sl表),并将检索结果按持有数量升序排序存储在表rate_temp中,同时将使用的SQL语句存储于新建的文本文件ratE.txt中。 2.使用一对多报表向导建立报表。要求如下:父表为rate_exchange,子表为currency_sl;从父表中选择字段“外币名称”,从子表中选择全部字段;两个表通过“外币代码”建立联系;按“外币代码”降序排序;报表样式为“经营式”,方向为“横向”,报表标题为“外币持有情况”;生成的报表文件名为currency_repon。

A.用SQL语句完成下列操作:列出“林诗因”持有的所有外币的名称(源自rate_exchange表)以及持有数量(源自currency_sl表),并将检索结果按持有数量升序排序存储在表rate_temp中,同时将使用的SQL语句存储于新建的文本文件ratE.txt中。
B.使用一对多报表向导建立报表。要求如下:父表为rate_exchange,子表为currency_sl;从父表中选择字段“外币名称”,从子表中选择全部字段;两个表通过“外币代码”建立联系;按“外币代码”降序排序;报表样式为“经营式”,方向为“横向”,报表标题为“外币持有情况”;生成的报表文件名为currency_repon。
【参考答案】

(1)【操作步骤】
步骤1:单击工具栏中的“新建”按钮,新建一个文本文件,
输入下列代码:
**......

(↓↓↓ 点击下方‘点击查看答案’看完整答案 ↓↓↓)

点击查看答案

相关考题

问答题
未知题型
Scientists working on a problem do not know and sometimes can&39;t even guess what the final result will bE.Late on Friday, 8 November, 1895, Professor Rontgen, a German physicist, was doing an experiment in his laboratory when he noticed something extraordinary. He had covered an electric bulb with black cardboard, and when he switched on the current he saw little dancing lights on his tablE.(46) ; how then could any ray penetrate? On the table there were some pieces of paper which had been covered with metal salts. (47) . Professor Rontgen took a piece of this paper and held it at a distance from the lamp. Between it and the lamp he placed a variety of objects, a books, a pack of cards, a piece of wood and a door key. The ray penetrated every one of them except the key. He called his wife into the laboratory and asked her to hold her hand between the lamp and a photographic platE.(48) , but she held up her hand for a quarter of an hour, and when the plate was developed there was a picture of the bones of her hand and of the ring on one finger. The mysterious ray could pass through the flesh and not through the bone or the ring.
At a scientific meeting, Professor Rontegen called this new ray "the unknown", the X-ray. (49) , and soon there were X-ray machines in all the big hospitals. The most obvious use for this discovery was to enable doctors to see exactly how a bone was fractureD.Other uses came later. It was found that these rays could be used to destroy cancer cells, just as they destroyed the healthy cells of the doctors who first used the machines. (50) , and the lungs could be X-rayed to show if there was any tuberculosis present.
46
A.It was on this paper that the lights were shiningB.She was very surprised by this requestC.Now the bulb was completely coveredD.It was a great inventionE.Methods were found later by which ulcers in the stomach could be locatedF.Doctors quickly saw how this could be used
47
A.It was on this paper that the lights were shiningB.She was very surprised by this requestC.Now the bulb was completely coveredD.It was a great inventionE.Methods were found later by which ulcers in the stomach could be locatedF.Doctors quickly saw how this could be used
48
A.It was on this paper that the lights were shiningB.She was very surprised by this requestC.Now the bulb was completely coveredD.It was a great inventionE.Methods were found later by which ulcers in the stomach could be locatedF.Doctors quickly saw how this could be used
49
A.It was on this paper that the lights were shiningB.She was very surprised by this requestC.Now the bulb was completely coveredD.It was a great inventionE.Methods were found later by which ulcers in the stomach could be locatedF.Doctors quickly saw how this could be used
50
A.It was on this paper that the lights were shiningB.She was very surprised by this requestC.Now the bulb was completely coveredD.It was a great inventionE.Methods were found later by which ulcers in the stomach could be locatedF.Doctors quickly saw how this could be used
请帮忙给出每个问题的正确答案和分析,谢谢!
微信小程序免费搜题
微信扫一扫,加关注免费搜题

微信扫一扫,加关注免费搜题