📄 例12-2.mht
字号:
style=3D'mso-spacerun:yes'> </span></span><span
style=3D'font-family:SimSun;mso-ascii-font-family:"Times New Roman";mso-han=
si-font-family:
"Times New Roman";mso-bidi-font-weight:bold'>分析：</span=
><span
style=3D'font-family:SimSun;mso-ascii-font-family:"Times New Roman";mso-han=
si-font-family:
"Times New Roman"'>我们让用户可以=
通过“学号”或“姓ࡧ=
7;”下拉列表选择或输&#=
20837;后按回车键的方法ʌ=
92;查询指定学生的成绩=
，无此记录时显示提=
1034;信息，如图</span><span
lang=3DEN-US>12-12</span><span style=3D'font-family:SimSun;mso-ascii-font-f=
amily:
"Times New Roman";mso-hansi-font-family:"Times New Roman"'>所示=
。</span></p>
<p class=3DMsoNormal><span lang=3DEN-US><span
style=3D'mso-spacerun:yes'> </span></span><span
style=3D'font-family:SimSun;mso-ascii-font-family:"Times New Roman";mso-han=
si-font-family:
"Times New Roman"'>单击“添加”或&#=
8220;修改”按钮后，显示=
;输入口令对话框，如&#=
22270;</span><span
lang=3DEN-US>12-13</span><span style=3D'font-family:SimSun;mso-ascii-font-f=
amily:
"Times New Roman";mso-hansi-font-family:"Times New Roman"'>所示=
。回答正确后（本例=
0026;空字符串，可以直৶=
9;按“确定”按钮），=
6174;示一个空白的添加ਤ=
8;据对话框。用户输入&=
#26032;记录的各项数据后A=
292;单击“更新”按钮使&=
#26356;新有效，并继续显=
034;下一个添加记录空对=
;话框，单击“取消”=
353;钮放弃数据，退出该=
;对话框返回到初始界&#=
38754;。</span></p>
<p class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><span lang=
=3DEN-US><!--[if gte vml 1]><v:shapetype
id=3D"_x0000_t75" coordsize=3D"21600,21600" o:spt=3D"75" o:preferrelative=
=3D"t"
path=3D"m@4@5l@4@11@9@11@9@5xe" filled=3D"f" stroked=3D"f">
<v:stroke joinstyle=3D"miter"/>
<v:formulas>
<v:f eqn=3D"if lineDrawn pixelLineWidth 0"/>
<v:f eqn=3D"sum @0 1 0"/>
<v:f eqn=3D"sum 0 0 @1"/>
<v:f eqn=3D"prod @2 1 2"/>
<v:f eqn=3D"prod @3 21600 pixelWidth"/>
<v:f eqn=3D"prod @3 21600 pixelHeight"/>
<v:f eqn=3D"sum @0 0 1"/>
<v:f eqn=3D"prod @6 1 2"/>
<v:f eqn=3D"prod @7 21600 pixelWidth"/>
<v:f eqn=3D"sum @8 21600 0"/>
<v:f eqn=3D"prod @7 21600 pixelHeight"/>
<v:f eqn=3D"sum @10 21600 0"/>
</v:formulas>
<v:path o:extrusionok=3D"f" gradientshapeok=3D"t" o:connecttype=3D"rect"/>
<o:lock v:ext=3D"edit" aspectratio=3D"t"/>
</v:shapetype><v:shape id=3D"_x0000_i1025" type=3D"#_x0000_t75" style=3D'wi=
dth:119.4pt;
height:87pt'>
<v:imagedata src=3D"file2562.files/image001.png" o:title=3D""/>
</v:shape><![endif]--><![if !vml]><img width=3D159 height=3D116
src=3D"file2562.files/image002.jpg" v:shapes=3D"_x0000_i1025"><![endif]><sp=
an
style=3D'mso-spacerun:yes'> </span><!--[if gte vml 1]><v:shape =
id=3D"_x0000_i1026"
type=3D"#_x0000_t75" style=3D'width:119.4pt;height:87pt'>
<v:imagedata src=3D"file2562.files/image003.png" o:title=3D""/>
</v:shape><![endif]--><![if !vml]><img width=3D159 height=3D116
src=3D"file2562.files/image004.jpg" v:shapes=3D"_x0000_i1026"><![endif]><sp=
an
style=3D'mso-spacerun:yes'> </span><!--[if gte vml 1]><v:s=
hape
id=3D"_x0000_i1027" type=3D"#_x0000_t75" style=3D'width:119.4pt;height:87p=
t'>
<v:imagedata src=3D"file2562.files/image005.png" o:title=3D""/>
</v:shape><![endif]--><![if !vml]><img width=3D159 height=3D116
src=3D"file2562.files/image006.jpg" v:shapes=3D"_x0000_i1027"><![endif]></s=
pan></p>
<h6><span lang=3DEN-US><span style=3D'mso-spacerun:yes'> =
</span></span><span
style=3D'font-family:SimSun;mso-ascii-font-family:"Times New Roman";mso-han=
si-font-family:
Roman'>图</span><span lang=3DEN-US>12-11<span
style=3D'mso-spacerun:yes'> </span></span><span style=3D'font-family:=
SimSun;
mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:Roman'>ఴ=
3;序主界面</span><span
lang=3DEN-US><span
style=3D'mso-spacerun:yes'> </spa=
n></span><span
style=3D'font-family:SimSun;mso-ascii-font-family:"Times New Roman";mso-han=
si-font-family:
Roman'>图</span><span lang=3DEN-US>12-12<span
style=3D'mso-spacerun:yes'> </span></span><span style=3D'font-family:=
SimSun;
mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:Roman'>ੑ=
0;找到匹配记录错误</span><s=
pan
lang=3DEN-US><span style=3D'mso-spacerun:yes'> </span></span><s=
pan
style=3D'font-family:SimSun;mso-ascii-font-family:"Times New Roman";mso-han=
si-font-family:
Roman'>图</span><span lang=3DEN-US>12-13<span
style=3D'mso-spacerun:yes'> </span></span><span style=3D'font-family:=
SimSun;
mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:Roman'>ࢯ=
8;答口令方可更改数据<=
/span></h6>
<p class=3DMsoNormal><span lang=3DEN-US><span
style=3D'mso-spacerun:yes'> </span></span><span
style=3D'font-family:SimSun;mso-ascii-font-family:"Times New Roman";mso-han=
si-font-family:
"Times New Roman"'>单击“修改”按&#=
38062;后“添加”和“修改=
”按钮变为“删除”ࡴ=
4;“更新”按钮，用户=
1487;以通过“学号”或“&=
#22995;名”找到需要修改į=
40;记录。修改后单击“&=
#26356;新”按钮，将打开Ì=
62;改确认对话框，确认=
后完成当前记录的修=
5913;。选择其他记录继ಱ=
3;进行修改工作，直到&=
#21333;击“退出”按钮返ࢯ=
8;初始界面（注意在初&=
#22987;界面中单击“退出̶=
1;按钮将退出程序）。<=
/span></p>
<p class=3DMsoNormal><span lang=3DEN-US><span
style=3D'mso-spacerun:yes'> </span></span><span
style=3D'font-family:SimSun;mso-ascii-font-family:"Times New Roman";mso-han=
si-font-family:
"Times New Roman"'>若单击“删除”&#=
25353;钮，将显示确认对Ŧ=
05;框，确认<span
class=3DGramE>后当前</span>记录将ඪ=
7;删除。</span></p>
<p class=3DMsoNormal><span lang=3DEN-US><span
style=3D'mso-spacerun:yes'> </span></span><span
style=3D'font-family:SimSun;mso-ascii-font-family:"Times New Roman";mso-han=
si-font-family:
"Times New Roman"'>设计步骤如下：=
</span></p>
<p class=3DMsoNormal><span lang=3DEN-US><span
style=3D'mso-spacerun:yes'> </span></span><span
style=3D'font-family:SimSun;mso-ascii-font-family:"Times New Roman";mso-han=
si-font-family:
"Times New Roman"'>①</span> <span style=3D'font-family:SimSun;mso-asc=
ii-font-family:
"Times New Roman";mso-hansi-font-family:"Times New Roman"'>创建=
数据库。</span></p>
<p class=3DMsoNormal><span lang=3DEN-US><span
style=3D'mso-spacerun:yes'> </span></span><span
style=3D'font-family:SimSun;mso-ascii-font-family:"Times New Roman";mso-han=
si-font-family:
"Times New Roman"'>通过</span><span lang=3DEN-US>Access</span><=
span
style=3D'font-family:SimSun;mso-ascii-font-family:"Times New Roman";mso-han=
si-font-family:
"Times New Roman"'>建立一个名为“&=
#25104;绩管理</span><span
lang=3DEN-US>.<span class=3DSpellE>mdb</span></span><span style=3D'font-fam=
ily:SimSun;
mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:"Times New Ro=
man"'>”的数据库，保存ࢷ=
2;</span><span
lang=3DEN-US>D</span><span style=3D'font-family:SimSun;mso-ascii-font-famil=
y:"Times New Roman";
mso-hansi-font-family:"Times New Roman"'>盘根目录&#=
19979;，在库中建立一个×=
17;为“成绩”的表，并&#=
21521;其中添加一些数据ť=
60;录，表结构如表</span><span
lang=3DEN-US>12-1</span><span style=3D'font-family:SimSun;mso-ascii-font-fa=
mily:
"Times New Roman";mso-hansi-font-family:"Times New Roman"'>所示=
。</span></p>
<p class=3DMsoHeading7><span style=3D'font-family:SimHei;mso-ascii-font-fam=
ily:
Arial'>表</span><span lang=3DEN-US>12-1<span
style=3D'mso-spacerun:yes'> </span></span><span style=3D'font-family:=
SimHei;
mso-ascii-font-family:Arial'>成绩表结构</span=
></p>
<div align=3Dcenter>
<table class=3DMsoNormalTable border=3D1 cellspacing=3D0 cellpadding=3D0 wi=
dth=3D"100%"
style=3D'width:100.0%;border-collapse:collapse;border:none;mso-border-alt:=
solid windowtext 1.5pt;
mso-padding-alt:0cm 5.4pt 0cm 5.4pt;mso-border-insideh:.75pt solid windowt=
ext;
mso-border-insidev:.75pt solid windowtext'>
<tr style=3D'mso-yfti-irow:0;mso-yfti-firstrow:yes;page-break-inside:avoid=
'>
<td width=3D"13%" valign=3Dtop style=3D'width:13.22%;border:solid windowt=
ext 1.0pt;
border-left:none;mso-border-top-alt:solid windowtext .75pt;mso-border-bot=
tom-alt:
solid windowtext .75pt;mso-border-right-alt:solid windowtext .75pt;
padding:0cm 5.4pt 0cm 5.4pt'>
<p class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><span
style=3D'font-size:7.5pt;font-family:SimSun;mso-ascii-font-family:"Times =
New Roman";
mso-hansi-font-family:"Times New Roman"'>字段</span><span
lang=3DEN-US style=3D'font-size:7.5pt'><o:p></o:p></span></p>
</td>
<td width=3D"11%" valign=3Dtop style=3D'width:11.04%;border:solid windowt=
ext 1.0pt;
border-left:none;mso-border-left-alt:solid windowtext .75pt;mso-border-al=
t:
solid windowtext .75pt;padding:0cm 5.4pt 0cm 5.4pt'>
<p class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><span
style=3D'font-size:7.5pt;font-family:SimSun;mso-ascii-font-family:"Times =
New Roman";
mso-hansi-font-family:"Times New Roman"'>类型</span><span
lang=3DEN-US style=3D'font-size:7.5pt'><o:p></o:p></span></p>
</td>
<td width=3D"23%" valign=3Dtop style=3D'width:23.58%;border-top:solid win=
dowtext 1.0pt;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:double=
windowtext 1.5pt;
mso-border-left-alt:solid windowtext .75pt;mso-border-alt:solid windowtex=
t .75pt;
mso-border-right-alt:double windowtext 1.5pt;padding:0cm 5.4pt 0cm 5.4pt'>
<p class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><span
style=3D'font-size:7.5pt;font-family:SimSun;mso-ascii-font-family:"Times =
New Roman";
mso-hansi-font-family:"Times New Roman"'>大小</span><span
lang=3DEN-US style=3D'font-size:7.5pt'><o:p></o:p></span></p>
</td>
<td width=3D"14%" valign=3Dtop style=3D'width:14.34%;border:solid windowt=
ext 1.0pt;
border-left:none;mso-border-left-alt:double windowtext 1.5pt;mso-border-a=
lt:
solid windowtext .75pt;mso-border-left-alt:double windowtext 1.5pt;
padding:0cm 5.4pt 0cm 5.4pt'>
<p class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><span
style=3D'font-size:7.5pt;font-family:SimSun;mso-ascii-font-family:"Times =
New Roman";
mso-hansi-font-family:"Times New Roman"'>字段</span><span
lang=3DEN-US style=3D'font-size:7.5pt'><o:p></o:p></span></p>
</td>
<td width=3D"14%" valign=3Dtop style=3D'width:14.26%;border:solid windowt=
ext 1.0pt;
border-left:none;mso-border-left-alt:solid windowtext .75pt;mso-border-al=
t:
solid windowtext .75pt;padding:0cm 5.4pt 0cm 5.4pt'>
<p class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><span
style=3D'font-size:7.5pt;font-family:SimSun;mso-ascii-font-family:"Times =
New Roman";
mso-hansi-font-family:"Times New Roman"'>类型</span><span
lang=3DEN-US style=3D'font-size:7.5pt'><o:p></o:p></span></p>
</td>
<td width=3D"23%" valign=3Dtop style=3D'width:23.56%;border-top:solid win=
dowtext 1.0pt;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:none;
mso-border-left-alt:solid windowtext .75pt;mso-border-top-alt:solid windo=
wtext .75pt;
mso-border-left-alt:solid windowtext .75pt;mso-border-bottom-alt:solid wi=
ndowtext .75pt;
padding:0cm 5.4pt 0cm 5.4pt'>
<p class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><span
style=3D'font-size:7.5pt;font-family:SimSun;mso-ascii-font-family:"Times =
New Roman";
mso-hansi-font-family:"Times New Roman"'>大小</span><span
lang=3DEN-US style=3D'font-size:7.5pt'><o:p></o:p></span></p>
</td>
</tr>
<tr style=3D'mso-yfti-irow:1;page-break-inside:avoid'>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -