KNOWLEDGE HYPERMARKET

Компьютерный практикум: Работа 7. Реализация сложных запросов
Строка 3: Строка 3:
<br> '''<metakeywords>Компьютерный практикум: Работа 7. Реализация сложных запросов</metakeywords>''' <br>  
<br> '''<metakeywords>Компьютерный практикум: Работа 7. Реализация сложных запросов</metakeywords>''' <br>  
-
<br>  
+
<meta content="text/html; charset=utf-8" http-equiv="Content-Type"></meta><meta content="Word.Document" name="ProgId"></meta><meta content="Microsoft Word 11" name="Generator"></meta><meta content="Microsoft Word 11" name="Originator"></meta><link href="file:///C:\Temp\msohtml1\01\clip_filelist.xml" rel="File-List"></link><!--[if gte mso 9]><xml>
 +
<w:WordDocument>
 +
  <w:View>Normal</w:View>
 +
  <w:Zoom>0</w:Zoom>
 +
  <w:PunctuationKerning/>
 +
  <w:ValidateAgainstSchemas/>
 +
  <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
 +
  <w:IgnoreMixedContent>false</w:IgnoreMixedContent>
 +
  <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
 +
  <w:Compatibility>
 +
  <w:BreakWrappedTables/>
 +
  <w:SnapToGridInCell/>
 +
  <w:WrapTextWithPunct/>
 +
  <w:UseAsianBreakRules/>
 +
  <w:DontGrowAutofit/>
 +
  </w:Compatibility>
 +
  <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
 +
</w:WordDocument>
 +
</xml><![endif]--><!--[if gte mso 9]><xml>
 +
<w:LatentStyles DefLockedState="false" LatentStyleCount="156">
 +
</w:LatentStyles>
 +
</xml><![endif]--><style>&lt;!-- /* Font Definitions */ @font-face {font-family:Tahoma; panose-1:2 11 6 4 3 5 4 4 2 4; mso-font-charset:204; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:1627421319 -2147483648 8 0 66047 0;} @font-face {font-family:"MS Reference Sans Serif"; panose-1:2 11 6 4 3 5 4 4 2 4; mso-font-charset:204; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:536871559 0 0 0 415 0;} @font-face {font-family:"Bookman Old Style"; panose-1:2 5 6 4 5 5 5 2 2 4; mso-font-charset:204; mso-generic-font-family:roman; mso-font-pitch:variable; mso-font-signature:647 0 0 0 159 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0cm; margin-bottom:.0001pt; mso-pagination:none; mso-layout-grid-align:none; text-autospace:none; font-size:12.0pt; font-family:"Bookman Old Style"; mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";} p.Style3, li.Style3, div.Style3 {mso-style-name:Style3; margin:0cm; margin-bottom:.0001pt; text-align:right; line-height:13.8pt; mso-line-height-rule:exactly; mso-pagination:none; mso-layout-grid-align:none; text-autospace:none; font-size:12.0pt; font-family:"Bookman Old Style"; mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";} p.Style10, li.Style10, div.Style10 {mso-style-name:Style10; margin:0cm; margin-bottom:.0001pt; mso-pagination:none; mso-layout-grid-align:none; text-autospace:none; font-size:12.0pt; font-family:"Bookman Old Style"; mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";} p.Style25, li.Style25, div.Style25 {mso-style-name:Style25; margin:0cm; margin-bottom:.0001pt; text-align:justify; text-indent:21.6pt; line-height:17.5pt; mso-line-height-rule:exactly; mso-pagination:none; mso-layout-grid-align:none; text-autospace:none; font-size:12.0pt; font-family:"Bookman Old Style"; mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";} p.Style92, li.Style92, div.Style92 {mso-style-name:Style92; margin:0cm; margin-bottom:.0001pt; mso-pagination:none; mso-layout-grid-align:none; text-autospace:none; font-size:12.0pt; font-family:"Bookman Old Style"; mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";} p.Style112, li.Style112, div.Style112 {mso-style-name:Style112; margin:0cm; margin-bottom:.0001pt; text-align:justify; line-height:15.85pt; mso-line-height-rule:exactly; mso-pagination:none; mso-layout-grid-align:none; text-autospace:none; font-size:12.0pt; font-family:"Bookman Old Style"; mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";} p.Style113, li.Style113, div.Style113 {mso-style-name:Style113; margin:0cm; margin-bottom:.0001pt; mso-pagination:none; mso-layout-grid-align:none; text-autospace:none; font-size:12.0pt; font-family:"Bookman Old Style"; mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";} p.Style121, li.Style121, div.Style121 {mso-style-name:Style121; margin:0cm; margin-bottom:.0001pt; text-align:center; mso-pagination:none; mso-layout-grid-align:none; text-autospace:none; font-size:12.0pt; font-family:"Bookman Old Style"; mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";} p.Style122, li.Style122, div.Style122 {mso-style-name:Style122; margin:0cm; margin-bottom:.0001pt; text-align:justify; mso-pagination:none; mso-layout-grid-align:none; text-autospace:none; font-size:12.0pt; font-family:"Bookman Old Style"; mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";} p.Style124, li.Style124, div.Style124 {mso-style-name:Style124; margin:0cm; margin-bottom:.0001pt; text-align:justify; line-height:17.6pt; mso-line-height-rule:exactly; mso-pagination:none; mso-layout-grid-align:none; text-autospace:none; font-size:12.0pt; font-family:"Bookman Old Style"; mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";} p.Style125, li.Style125, div.Style125 {mso-style-name:Style125; margin:0cm; margin-bottom:.0001pt; text-indent:-16.85pt; line-height:17.6pt; mso-line-height-rule:exactly; mso-pagination:none; mso-layout-grid-align:none; text-autospace:none; font-size:12.0pt; font-family:"Bookman Old Style"; mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";} p.Style126, li.Style126, div.Style126 {mso-style-name:Style126; margin:0cm; margin-bottom:.0001pt; text-align:center; mso-pagination:none; mso-layout-grid-align:none; text-autospace:none; font-size:12.0pt; font-family:"Bookman Old Style"; mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";} p.Style127, li.Style127, div.Style127 {mso-style-name:Style127; margin:0cm; margin-bottom:.0001pt; text-align:justify; text-indent:22.2pt; line-height:16.1pt; mso-line-height-rule:exactly; mso-pagination:none; mso-layout-grid-align:none; text-autospace:none; font-size:12.0pt; font-family:"Bookman Old Style"; mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";} p.Style128, li.Style128, div.Style128 {mso-style-name:Style128; margin:0cm; margin-bottom:.0001pt; text-align:justify; text-indent:-22.2pt; line-height:18.75pt; mso-line-height-rule:exactly; mso-pagination:none; mso-layout-grid-align:none; text-autospace:none; font-size:12.0pt; font-family:"Bookman Old Style"; mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";} p.Style132, li.Style132, div.Style132 {mso-style-name:Style132; margin:0cm; margin-bottom:.0001pt; text-align:center; mso-pagination:none; mso-layout-grid-align:none; text-autospace:none; font-size:12.0pt; font-family:"Bookman Old Style"; mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";} p.Style135, li.Style135, div.Style135 {mso-style-name:Style135; margin:0cm; margin-bottom:.0001pt; text-align:justify; text-indent:-15.7pt; line-height:17.45pt; mso-line-height-rule:exactly; mso-pagination:none; mso-layout-grid-align:none; text-autospace:none; font-size:12.0pt; font-family:"Bookman Old Style"; mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";} span.FontStyle294 {mso-style-name:"Font Style294"; mso-ansi-font-size:15.0pt; mso-bidi-font-size:15.0pt; font-family:"MS Reference Sans Serif"; mso-ascii-font-family:"MS Reference Sans Serif"; mso-hansi-font-family:"MS Reference Sans Serif"; mso-bidi-font-family:"MS Reference Sans Serif"; letter-spacing:.5pt; font-style:italic;} span.FontStyle299 {mso-style-name:"Font Style299"; mso-ansi-font-size:16.0pt; mso-bidi-font-size:16.0pt; font-family:"MS Reference Sans Serif"; mso-ascii-font-family:"MS Reference Sans Serif"; mso-hansi-font-family:"MS Reference Sans Serif"; mso-bidi-font-family:"MS Reference Sans Serif";} span.FontStyle314 {mso-style-name:"Font Style314"; mso-ansi-font-size:18.0pt; mso-bidi-font-size:18.0pt; font-family:Tahoma; mso-ascii-font-family:Tahoma; mso-hansi-font-family:Tahoma; mso-bidi-font-family:Tahoma; letter-spacing:-.5pt; font-weight:bold;} span.FontStyle320 {mso-style-name:"Font Style320"; mso-ansi-font-size:13.0pt; mso-bidi-font-size:13.0pt; font-family:"MS Reference Sans Serif"; mso-ascii-font-family:"MS Reference Sans Serif"; mso-hansi-font-family:"MS Reference Sans Serif"; mso-bidi-font-family:"MS Reference Sans Serif"; letter-spacing:-1.0pt; font-weight:bold;} span.FontStyle331 {mso-style-name:"Font Style331"; mso-ansi-font-size:10.0pt; mso-bidi-font-size:10.0pt; font-family:"Bookman Old Style"; mso-ascii-font-family:"Bookman Old Style"; mso-hansi-font-family:"Bookman Old Style"; mso-bidi-font-family:"Bookman Old Style"; font-weight:bold;} span.FontStyle336 {mso-style-name:"Font Style336"; mso-ansi-font-size:12.0pt; mso-bidi-font-size:12.0pt; font-family:"Bookman Old Style"; mso-ascii-font-family:"Bookman Old Style"; mso-hansi-font-family:"Bookman Old Style"; mso-bidi-font-family:"Bookman Old Style"; font-weight:bold;} span.FontStyle340 {mso-style-name:"Font Style340"; mso-ansi-font-size:16.0pt; mso-bidi-font-size:16.0pt; font-family:"Bookman Old Style"; mso-ascii-font-family:"Bookman Old Style"; mso-hansi-font-family:"Bookman Old Style"; mso-bidi-font-family:"Bookman Old Style";} span.FontStyle343 {mso-style-name:"Font Style343"; mso-ansi-font-size:14.0pt; mso-bidi-font-size:14.0pt; font-family:"Bookman Old Style"; mso-ascii-font-family:"Bookman Old Style"; mso-hansi-font-family:"Bookman Old Style"; mso-bidi-font-family:"Bookman Old Style"; letter-spacing:-.5pt; font-weight:bold;} span.FontStyle345 {mso-style-name:"Font Style345"; mso-ansi-font-size:10.0pt; mso-bidi-font-size:10.0pt; font-family:"Bookman Old Style"; mso-ascii-font-family:"Bookman Old Style"; mso-hansi-font-family:"Bookman Old Style"; mso-bidi-font-family:"Bookman Old Style"; font-weight:bold;} @page Section1 {size:841.85pt 1190.5pt; margin:298.7pt 172.8pt 72.0pt 208.8pt; mso-header-margin:36.0pt; mso-footer-margin:36.0pt; mso-paper-source:0;} div.Section1 {page:Section1;} @page Section2 {size:612.0pt 792.0pt; margin:2.0cm 42.5pt 2.0cm 3.0cm; mso-header-margin:36.0pt; mso-footer-margin:36.0pt; mso-paper-source:0;} div.Section2 {page:Section2;} /* List Definitions */ @list l0 {mso-list-id:-2; mso-list-type:simple; mso-list-template-ids:1946826162;} @list l0:level1 {mso-level-start-at:0; mso-level-number-format:bullet; mso-level-text:*; mso-level-tab-stop:none; mso-level-number-position:left; margin-left:0cm; text-indent:0cm;} @list l1 {mso-list-id:1112213927; mso-list-type:simple; mso-list-template-ids:-336688602;} @list l1:level1 {mso-level-text:"%1\)"; mso-level-tab-stop:none; mso-level-number-position:left; mso-level-legacy:yes; mso-level-legacy-indent:22.2pt; mso-level-legacy-space:0cm; margin-left:0cm; text-indent:0cm; font-family:"Bookman Old Style";} @list l0:level1 lfo1 {mso-level-start-at:65535; mso-level-numbering:continue; mso-level-text:•; mso-level-tab-stop:none; mso-level-number-position:left; mso-level-legacy:yes; mso-level-legacy-indent:15.7pt; mso-level-legacy-space:0cm; margin-left:0cm; text-indent:0cm; font-family:"Bookman Old Style";} @list l0:level1 lfo2 {mso-level-start-at:65535; mso-level-numbering:continue; mso-level-text:•; mso-level-tab-stop:none; mso-level-number-position:left; mso-level-legacy:yes; mso-level-legacy-indent:16.85pt; mso-level-legacy-space:0cm; margin-left:0cm; text-indent:0cm; font-family:"Bookman Old Style";} ol {margin-bottom:0cm;} ul {margin-bottom:0cm;} --&gt; </style><!--[if gte mso 10]>
 +
<style>
 +
/* Style Definitions */
 +
table.MsoNormalTable
 +
{mso-style-name:"Обычная таблица";
 +
mso-tstyle-rowband-size:0;
 +
mso-tstyle-colband-size:0;
 +
mso-style-noshow:yes;
 +
mso-style-parent:"";
 +
mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
 +
mso-para-margin:0cm;
 +
mso-para-margin-bottom:.0001pt;
 +
mso-pagination:widow-orphan;
 +
font-size:10.0pt;
 +
font-family:"Times New Roman";
 +
mso-ansi-language:#0400;
 +
mso-fareast-language:#0400;
 +
mso-bidi-language:#0400;}
 +
</style>
 +
<![endif]--> <div class="Section1">
 +
'''<span class="FontStyle314"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; font-weight: normal;">Компьютерный практикум</span></span>'''<span style="font-size: 11pt; font-family: &quot;Times New Roman";"><o:p>
 +
</o:p></span>
 +
 
 +
<span style="font-size: 11pt; font-family: &quot;Times New Roman";"><o:p>&nbsp;</o:p></span>
 +
 
 +
<span class="FontStyle294"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; letter-spacing: 1pt;">Работа</span></span><span class="FontStyle294"><span style="font-size: 11pt; font-family: &quot;Times New Roman";">
 +
</span></span><span class="FontStyle294"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; letter-spacing: 1pt;">7.</span></span><span class="FontStyle294"><span style="font-size: 11pt; font-family: &quot;Times New Roman";">
 +
</span></span><span class="FontStyle294"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; letter-spacing: 1pt;">Реализация</span></span><span class="FontStyle294"><span style="font-size: 11pt; font-family: &quot;Times New Roman";">
 +
</span></span><span class="FontStyle294"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; letter-spacing: 1pt;">сложных</span></span><span class="FontStyle294"><span style="font-size: 11pt; font-family: &quot;Times New Roman";">
 +
</span></span><span class="FontStyle294"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; letter-spacing: 1pt;">запросов<o:p></o:p></span></span>
 +
 
 +
<span style="font-size: 11pt; font-family: &quot;Times New Roman";"><o:p>&nbsp;</o:p></span>
 +
 
 +
<span class="FontStyle343"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; font-weight: normal;">Цели работы</span></span>''<span class="FontStyle343"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; font-weight: normal;">:</span></span>''<span class="FontStyle343"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; font-weight: normal;"><o:p></o:p></span></span>
 +
 
 +
''<!--[if !supportLists]--><span class="FontStyle340"><span style="font-size: 11pt; letter-spacing: -0.5pt;"><span style="">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; •<span style="font: 7pt &quot;Times New Roman";">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 +
</span></span></span></span><!--[endif]--><span class="FontStyle340"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; letter-spacing: -0.5pt;">закрепление</span></span><span class="FontStyle340"><span style="font-size: 11pt; font-family: &quot;Times New Roman";">
 +
<span style="letter-spacing: -0.5pt;">навыков</span> <span style="letter-spacing: -0.5pt;">до</span> <span style="letter-spacing: -0.5pt;">созданию</span> <span style="letter-spacing: -0.5pt;">и</span> <span style="letter-spacing: -0.5pt;">заполнению</span> <span style="letter-spacing: -0.5pt;">таблиц;</span></span></span>''<span class="FontStyle340"><span style="font-size: 11pt; font-family: &quot;Times New Roman";"><span style="letter-spacing: -0.5pt;"><o:p></o:p></span></span></span>
 +
 
 +
''<!--[if !supportLists]--><span class="FontStyle340"><span style="font-size: 11pt; letter-spacing: -0.5pt;"><span style="">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; •<span style="font: 7pt &quot;Times New Roman";">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 +
</span></span></span></span><!--[endif]--><span class="FontStyle340"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; letter-spacing: -0.5pt;">отработка</span></span><span class="FontStyle340"><span style="font-size: 11pt; font-family: &quot;Times New Roman";">
 +
<span style="letter-spacing: -0.5pt;">приемов</span> <span style="letter-spacing: -0.5pt;">реализации</span> <span style="letter-spacing: -0.5pt;">сложных</span> <span style="letter-spacing: -0.5pt;">запросов</span> <span style="letter-spacing: -0.5pt;">на</span> <span style="letter-spacing: -0.5pt;">вы­борку;</span></span></span>''<span class="FontStyle340"><span style="font-size: 11pt; font-family: &quot;Times New Roman";"><span style="letter-spacing: -0.5pt;"><o:p></o:p></span></span></span>
 +
 
 +
''<!--[if !supportLists]--><span class="FontStyle340"><span style="font-size: 11pt; letter-spacing: -0.5pt;"><span style="">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; •<span style="font: 7pt &quot;Times New Roman";">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 +
</span></span></span></span><!--[endif]--><span class="FontStyle340"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; letter-spacing: -0.5pt;">обучение</span></span><span class="FontStyle340"><span style="font-size: 11pt; font-family: &quot;Times New Roman";">
 +
<span style="letter-spacing: -0.5pt;">реализации</span> <span style="letter-spacing: -0.5pt;">запросов</span> <span style="letter-spacing: -0.5pt;">на</span> <span style="letter-spacing: -0.5pt;">удаление,</span> <span style="letter-spacing: -0.5pt;">а</span> <span style="letter-spacing: -0.5pt;">также</span> <span style="letter-spacing: -0.5pt;">ис­пользованию</span> <span style="letter-spacing: -0.5pt;">вычисляемых</span> <span style="letter-spacing: -0.5pt;">полей</span> <span style="letter-spacing: -0.5pt;">в</span> <span style="letter-spacing: -0.5pt;">запросах. Используемые</span> <span style="letter-spacing: -0.5pt;">программные</span> <span style="letter-spacing: -0.5pt;">средства:</span></span></span><span class="FontStyle340"><span lang="EN-US" style="font-size: 11pt; font-family: &quot;Times New Roman"; letter-spacing: -0.5pt;">MS</span></span><span class="FontStyle340"><span lang="EN-US" style="font-size: 11pt; font-family: &quot;Times New Roman";"> <span style="letter-spacing: -0.5pt;">Access</span></span></span>''
 +
 
 +
 
 +
 
 +
''<span class="FontStyle340"><span lang="EN-US" style="font-size: 11pt; font-family: &quot;Times New Roman";"><span style="letter-spacing: -0.5pt;" /></span></span>''''<span class="FontStyle340"><span lang="EN-US" style="font-size: 11pt; font-family: &quot;Times New Roman";"><span style="letter-spacing: -0.5pt;" /></span></span><span class="FontStyle340" />''<span class="FontStyle340"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; letter-spacing: -0.5pt;"><o:p></o:p></span></span>
 +
 
 +
'''<span class="FontStyle320"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; font-weight: normal;">Задание 1</span></span>'''<span class="FontStyle320"
 +
 
 +
'''''<span style="font-size: 11pt; font-family: &quot;Times New Roman";" />'''''
 +
 
 +
''<span style="font-size: 11pt; font-family: &quot;Times New Roman";"><o:p> </o:p></span>''<span style="font-size: 11pt; font-family: &quot;Times New Roman";"><o:p></o:p></span>
 +
 
 +
''<span class="FontStyle340"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; letter-spacing: -0.5pt;">Создать</span></span><span class="FontStyle340"><span style="font-size: 11pt; font-family: &quot;Times New Roman";"> <span style="letter-spacing: -0.5pt;">таблицу</span> <span style="letter-spacing: -0.5pt;">«Оценки»</span> <span style="letter-spacing: -0.5pt;">и</span> <span style="letter-spacing: -0.5pt;">ввести</span> <span style="letter-spacing: -0.5pt;">в</span> <span style="letter-spacing: -0.5pt;">нее</span> <span style="letter-spacing: -0.5pt;">данные,</span> <span style="letter-spacing: -0.5pt;">пред­ставленные</span> <span style="letter-spacing: -0.5pt;">в</span> <span style="letter-spacing: -0.5pt;">теме 19</span></span></span><span class="FontStyle336"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; font-weight: normal;"> </span></span><span class="FontStyle340"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; letter-spacing: -0.5pt;">в</span></span><span class="FontStyle340"><span style="font-size: 11pt; font-family: &quot;Times New Roman";">
 +
<span style="letter-spacing: -0.5pt;">табл.</span></span></span><span class="FontStyle336"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; font-weight: normal;">1.11.</span></span>''<span class="FontStyle336"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; font-weight: normal;"><o:p></o:p></span></span>
 +
 
 +
'''<span class="FontStyle299"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; letter-spacing: -0.5pt;">Задание</span><span style="font-size: 11pt; font-family: &quot;Times New Roman";"> <span style="letter-spacing: -0.5pt;">2</span></span></span>'''<span class="FontStyle299"><span style="font-size: 11pt; font-family: &quot;Times New Roman";" /></span><span class="FontStyle299"><span style="font-size: 11pt; font-family: &quot;Times New Roman";"><span style="letter-spacing: -0.5pt;"><o:p></o:p></span></span></span>
 +
 
 +
''<span class="FontStyle340"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; letter-spacing: -0.5pt;">Используя</span></span><span class="FontStyle340"><span style="font-size: 11pt; font-family: &quot;Times New Roman";"> <span style="letter-spacing: -0.5pt;">конструктор</span> <span style="letter-spacing: -0.5pt;">запросов</span></span></span><span class="FontStyle340"><span lang="EN-US" style="font-size: 11pt; font-family: &quot;Times New Roman"; letter-spacing: -0.5pt;">MS</span></span><span class="FontStyle340"><span lang="EN-US" style="font-size: 11pt; font-family: &quot;Times New Roman";">
 +
</span></span><span class="FontStyle340"><span lang="EN-US" style="font-size: 11pt; font-family: &quot;Times New Roman"; letter-spacing: -0.5pt;">Access</span></span><span class="FontStyle340"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; letter-spacing: -0.5pt;">,</span></span><span class="FontStyle340"><span style="font-size: 11pt; font-family: &quot;Times New Roman";"> <span style="letter-spacing: -0.5pt;">выполнить все</span> <span style="letter-spacing: -0.5pt;">запросы,</span> <span style="letter-spacing: -0.5pt;">описанные</span> <span style="letter-spacing: -0.5pt;">в</span> <span style="letter-spacing: -0.5pt;">§</span> <span style="letter-spacing: -0.5pt;">1.14.</span></span></span>''<span class="FontStyle340"><span style="font-size: 11pt; font-family: &quot;Times New Roman";"><span style="letter-spacing: -0.5pt;"><o:p></o:p></span></span></span>
 +
 
 +
''<span style="font-size: 11pt; font-family: &quot;Times New Roman";"><o:p>&nbsp;</o:p></span>''<span style="font-size: 11pt; font-family: &quot;Times New Roman";"><o:p></o:p></span>
 +
 
 +
''<span class="FontStyle299"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; letter-spacing: -0.5pt;">Задание</span></span><span class="FontStyle299"><span style="font-size: 11pt; font-family: &quot;Times New Roman";"> <span style="letter-spacing: -0.5pt;">3</span></span></span>''<span class="FontStyle299"><span style="font-size: 11pt; font-family: &quot;Times New Roman";"><span style="letter-spacing: -0.5pt;"><o:p></o:p></span></span></span>
 +
 
 +
''<span class="FontStyle340"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; letter-spacing: -0.5pt;">Реализовать</span></span><span class="FontStyle340"><span style="font-size: 11pt; font-family: &quot;Times New Roman";"> <span style="letter-spacing: -0.5pt;">в</span> <span style="letter-spacing: -0.5pt;">конструкторе</span> <span style="letter-spacing: -0.5pt;">запросов</span> <span style="letter-spacing: -0.5pt;">следующие</span> <span style="letter-spacing: -0.5pt;">зада­ния:</span></span></span>''<span class="FontStyle340"><span style="font-size: 11pt; font-family: &quot;Times New Roman";"><span style="letter-spacing: -0.5pt;"><o:p></o:p></span></span></span>
 +
 
 +
''<!--[if !supportLists]--><span class="FontStyle340"><span style="font-size: 11pt; letter-spacing: -0.5pt;"><span style="">1)<span style="font: 7pt &quot;Times New Roman";">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 +
</span></span></span></span><!--[endif]--><span class="FontStyle340"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; letter-spacing: -0.5pt;">получить</span></span><span class="FontStyle340"><span style="font-size: 11pt; font-family: &quot;Times New Roman";">
 +
<span style="letter-spacing: -0.5pt;">таблицу,</span> <span style="letter-spacing: -0.5pt;">содержащую</span> <span style="letter-spacing: -0.5pt;">фамилии</span> <span style="letter-spacing: -0.5pt;">абитуриен­тов</span> <span style="letter-spacing: -0.5pt;">и</span> <span style="letter-spacing: -0.5pt;">средние</span> <span style="letter-spacing: -0.5pt;">значения</span> <span style="letter-spacing: -0.5pt;">оценок,</span> <span style="letter-spacing: -0.5pt;">полученных</span> <span style="letter-spacing: -0.5pt;">на</span> <span style="letter-spacing: -0.5pt;">экзаме­нах;</span></span></span>''<span class="FontStyle340"><span style="font-size: 11pt; font-family: &quot;Times New Roman";"><span style="letter-spacing: -0.5pt;"><o:p></o:p></span></span></span>
 +
 
 +
''<!--[if !supportLists]--><span class="FontStyle340"><span style="font-size: 11pt; letter-spacing: -0.5pt;"><span style="">2)<span style="font: 7pt &quot;Times New Roman";">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 +
</span></span></span></span><!--[endif]--><span class="FontStyle340"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; letter-spacing: -0.5pt;">получить</span></span><span class="FontStyle340"><span style="font-size: 11pt; font-family: &quot;Times New Roman";">
 +
<span style="letter-spacing: -0.5pt;">список</span> <span style="letter-spacing: -0.5pt;">лишь</span> <span style="letter-spacing: -0.5pt;">тех</span> <span style="letter-spacing: -0.5pt;">абитуриентов,</span> <span style="letter-spacing: -0.5pt;">у</span> <span style="letter-spacing: -0.5pt;">которых оценка</span> <span style="letter-spacing: -0.5pt;">за</span> <span style="letter-spacing: -0.5pt;">первый</span> <span style="letter-spacing: -0.5pt;">экзамен</span> <span style="letter-spacing: -0.5pt;">больше</span> <span style="letter-spacing: -0.5pt;">среднего</span> <span style="letter-spacing: -0.5pt;">балла</span> <span style="letter-spacing: -0.5pt;">за
 +
все</span> <span style="letter-spacing: -0.5pt;">экзамены;</span></span></span>''<span class="FontStyle340"><span style="font-size: 11pt; font-family: &quot;Times New Roman";"><span style="letter-spacing: -0.5pt;"><o:p></o:p></span></span></span>
 +
 
 +
''<!--[if !supportLists]--><span class="FontStyle340"><span style="font-size: 11pt; letter-spacing: -0.5pt;"><span style="">3)<span style="font: 7pt &quot;Times New Roman";">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 +
</span></span></span></span><!--[endif]--><span class="FontStyle340"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; letter-spacing: -0.5pt;">предположим,</span></span><span class="FontStyle340"><span style="font-size: 11pt; font-family: &quot;Times New Roman";">
 +
<span style="letter-spacing: -0.5pt;">что</span> <span style="letter-spacing: -0.5pt;">действует</span> <span style="letter-spacing: -0.5pt;">следующее</span> <span style="letter-spacing: -0.5pt;">правило:</span> <span style="letter-spacing: -0.5pt;">на экономический</span> <span style="letter-spacing: -0.5pt;">факультет</span> <span style="letter-spacing: -0.5pt;">университета</span> <span style="letter-spacing: -0.5pt;">принимаются те</span> <span style="letter-spacing: -0.5pt;">абитуриенты,</span> <span style="letter-spacing: -0.5pt;">у</span> <span style="letter-spacing: -0.5pt;">которых</span> <span style="letter-spacing: -0.5pt;">сумма</span> <span style="letter-spacing: -0.5pt;">баллов</span> <span style="letter-spacing: -0.5pt;">за</span> <span style="letter-spacing: -0.5pt;">экзамены
 +
не</span> <span style="letter-spacing: -0.5pt;">меньше</span> <span style="letter-spacing: -0.5pt;">14;</span> <span style="letter-spacing: -0.5pt;">на</span> <span style="letter-spacing: -0.5pt;">исторический</span> <span style="letter-spacing: -0.5pt;">факультет</span> <span style="letter-spacing: -0.5pt;">—</span> <span style="letter-spacing: -0.5pt;">не</span> <span style="letter-spacing: -0.5pt;">мень­ше</span> <span style="letter-spacing: -0.5pt;">13;</span> <span style="letter-spacing: -0.5pt;">на</span> <span style="letter-spacing: -0.5pt;">юридический</span> <span style="letter-spacing: -0.5pt;">факультет</span> <span style="letter-spacing: -0.5pt;">—</span> <span style="letter-spacing: -0.5pt;">не</span> <span style="letter-spacing: -0.5pt;">меньше</span> <span style="letter-spacing: -0.5pt;">12. Получить</span> <span style="letter-spacing: -0.5pt;">список</span> <span style="letter-spacing: -0.5pt;">принятых</span> <span style="letter-spacing: -0.5pt;">на</span> <span style="letter-spacing: -0.5pt;">каждый</span> <span style="letter-spacing: -0.5pt;">факультет»</span></span></span>''<span class="FontStyle340"><span style="font-size: 11pt; font-family: &quot;Times New Roman";"><span style="letter-spacing: -0.5pt;"><o:p></o:p></span></span></span>
 +
 
 +
''<span class="FontStyle340"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; letter-spacing: -0.5pt;">указав</span></span><span class="FontStyle340"><span style="font-size: 11pt; font-family: &quot;Times New Roman";"> <span style="letter-spacing: -0.5pt;">факультеты,</span> <span style="letter-spacing: -0.5pt;">специальности,</span> <span style="letter-spacing: -0.5pt;">фамилии,</span> <span style="letter-spacing: -0.5pt;">имена, отчества.</span> <span style="letter-spacing: -0.5pt;">Отсортировать</span> <span style="letter-spacing: -0.5pt;">список</span> <span style="letter-spacing: -0.5pt;">по</span> <span style="letter-spacing: -0.5pt;">факультету</span> <span style="letter-spacing: -0.5pt;">и</span> <span style="letter-spacing: -0.5pt;">еде*
 +
циальеости.</span></span></span>''<span class="FontStyle340"><span style="font-size: 11pt; font-family: &quot;Times New Roman";"><span style="letter-spacing: -0.5pt;"><o:p></o:p></span></span></span>
 +
</div>''<span class="FontStyle340"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; letter-spacing: -0.5pt;">
 +
 
 +
</span></span> ''
 +
''<span class="FontStyle294"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; letter-spacing: 1pt;">Работа</span></span><span class="FontStyle294"><span style="font-size: 11pt; font-family: &quot;Times New Roman";">
 +
</span></span><span class="FontStyle294"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; letter-spacing: 1pt;">8.</span></span><span class="FontStyle294"><span style="font-size: 11pt; font-family: &quot;Times New Roman";">
 +
</span></span><span class="FontStyle294"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; letter-spacing: 1pt;">Творческое</span></span><span class="FontStyle294"><span style="font-size: 11pt; font-family: &quot;Times New Roman";">
 +
</span></span><span class="FontStyle294"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; letter-spacing: 1pt;">задание</span></span><span class="FontStyle294"><span style="font-size: 11pt; font-family: &quot;Times New Roman";">
 +
</span></span><span class="FontStyle294"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; letter-spacing: 1pt;">на</span></span><span class="FontStyle294"><span style="font-size: 11pt; font-family: &quot;Times New Roman";">
 +
</span></span><span class="FontStyle294"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; letter-spacing: 1pt;">реализацию</span></span>''<span class="FontStyle294"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; letter-spacing: 1pt;"><o:p></o:p></span></span>
 +
 
 +
''<span class="FontStyle294"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; letter-spacing: 1pt;">сложных</span></span><span class="FontStyle294"><span style="font-size: 11pt; font-family: &quot;Times New Roman";"> </span></span><span class="FontStyle294"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; letter-spacing: 1pt;">запросов</span></span>''<span class="FontStyle294"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; letter-spacing: 1pt;"><o:p></o:p></span></span>
 +
 
 +
''<span class="FontStyle343"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; font-weight: normal;">Цель работы: отработка умения
 +
формулировать сложные запросы и реализовывать их с помощью конструктора в </span></span><span class="FontStyle343"><span lang="EN-US" style="font-size: 11pt; font-family: &quot;Times New Roman"; font-weight: normal;">MS</span></span><span class="FontStyle343"><span lang="EN-US" style="font-size: 11pt; font-family: &quot;Times New Roman"; font-weight: normal;"> </span></span><span class="FontStyle343"><span lang="EN-US" style="font-size: 11pt; font-family: &quot;Times New Roman"; font-weight: normal;">Access</span></span><span class="FontStyle343"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; font-weight: normal;">.</span></span>''<span class="FontStyle343"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; font-weight: normal;"><o:p></o:p></span></span>
 +
 
 +
''<span class="FontStyle343"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; font-weight: normal;">Используемые программные средства: </span></span><span class="FontStyle343"><span lang="EN-US" style="font-size: 11pt; font-family: &quot;Times New Roman"; font-weight: normal;">MS</span></span><span class="FontStyle343"><span lang="EN-US" style="font-size: 11pt; font-family: &quot;Times New Roman"; font-weight: normal;"> </span></span><span class="FontStyle343"><span lang="EN-US" style="font-size: 11pt; font-family: &quot;Times New Roman"; font-weight: normal;">Access</span></span><span class="FontStyle343"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; font-weight: normal;">. Задание</span></span>''<span class="FontStyle343"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; font-weight: normal;"><o:p></o:p></span></span>
 +
 
 +
''<span class="FontStyle343"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; font-weight: normal;">Выполнить различные типы запросов
 +
к самостоятельно созданной базе данных* Для этого:</span></span>''<span class="FontStyle343"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; font-weight: normal;"><o:p></o:p></span></span>
 +
 
 +
''<!--[if !supportLists]--><span class="FontStyle343"><span style="font-size: 11pt; font-weight: normal;"><span style="">•<span style="font: 7pt &quot;Times New Roman";">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 +
</span></span></span></span><!--[endif]--><span class="FontStyle343"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; font-weight: normal;">придумать общую формулировку не менее, чем пяти за­просов
 +
на выборку с использованием сложных условий отбора и сортировки;</span></span>''<span class="FontStyle343"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; font-weight: normal;"><o:p></o:p></span></span>
 +
 
 +
''<!--[if !supportLists]--><span class="FontStyle343"><span style="font-size: 11pt; font-weight: normal;"><span style="">•<span style="font: 7pt &quot;Times New Roman";">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 +
</span></span></span></span><!--[endif]--><span class="FontStyle343"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; font-weight: normal;">записать в тетради команды запросов на
 +
гипотетическом языке;</span></span>''<span class="FontStyle343"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; font-weight: normal;"><o:p></o:p></span></span>
 +
 
 +
''<!--[if !supportLists]--><span class="FontStyle343"><span style="font-size: 11pt; font-weight: normal;"><span style="">•<span style="font: 7pt &quot;Times New Roman";">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 +
</span></span></span></span><!--[endif]--><span class="FontStyle343"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; font-weight: normal;">реализовать запросы с помощью конструктора в </span></span><span class="FontStyle343"><span lang="EN-US" style="font-size: 11pt; font-family: &quot;Times New Roman"; font-weight: normal;">MS</span></span><span class="FontStyle343"><span lang="EN-US" style="font-size: 11pt; font-family: &quot;Times New Roman"; font-weight: normal;"> </span></span><span class="FontStyle343"><span lang="EN-US" style="font-size: 11pt; font-family: &quot;Times New Roman"; font-weight: normal;">Access</span></span><span class="FontStyle343"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; font-weight: normal;">;</span></span>''<span class="FontStyle343"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; font-weight: normal;"><o:p></o:p></span></span>
 +
 
 +
''<!--[if !supportLists]--><span class="FontStyle343"><span style="font-size: 11pt; font-weight: normal;"><span style="">•<span style="font: 7pt &quot;Times New Roman";">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 +
</span></span></span></span><!--[endif]--><span class="FontStyle343"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; font-weight: normal;">придумать и реализовать запросы на удаление записей;</span></span>''<span class="FontStyle343"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; font-weight: normal;"><o:p></o:p></span></span>
 +
 
 +
''<!--[if !supportLists]--><span class="FontStyle343"><span style="font-size: 11pt; font-weight: normal;"><span style="">•<span style="font: 7pt &quot;Times New Roman";">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 +
</span></span></span></span><!--[endif]--><span class="FontStyle343"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; font-weight: normal;">придумать и реализовать запросы с использованием вы­числяемых
 +
полей.</span></span>''<span class="FontStyle343"><span style="font-size: 11pt; font-family: &quot;Times New Roman"; font-weight: normal;"><o:p></o:p></span></span>
 +
 
 +
''<span class="FontStyle343"><span style="font-size: 11pt; font-weight: normal;" /></span>''<span class="FontStyle343"><span style="font-size: 11pt; font-weight: normal;"><o:p></o:p></span></span>
 +
 
''Семакин И.Г., Хеннер Е.К., Информатика и ИКТ, 11''  
''Семакин И.Г., Хеннер Е.К., Информатика и ИКТ, 11''  

Версия 11:49, 15 августа 2010

Гипермаркет знаний>>Информатика>>Информатика 11 класс>>Информатика: Компьютерный практикум: Работа 7. Реализация сложных запросов



<meta content="text/html; charset=utf-8" http-equiv="Content-Type"></meta><meta content="Word.Document" name="ProgId"></meta><meta content="Microsoft Word 11" name="Generator"></meta><meta content="Microsoft Word 11" name="Originator"></meta><link href="file:///C:\Temp\msohtml1\01\clip_filelist.xml" rel="File-List"></link><style><!-- /* Font Definitions */ @font-face {font-family:Tahoma; panose-1:2 11 6 4 3 5 4 4 2 4; mso-font-charset:204; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:1627421319 -2147483648 8 0 66047 0;} @font-face {font-family:"MS Reference Sans Serif"; panose-1:2 11 6 4 3 5 4 4 2 4; mso-font-charset:204; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:536871559 0 0 0 415 0;} @font-face {font-family:"Bookman Old Style"; panose-1:2 5 6 4 5 5 5 2 2 4; mso-font-charset:204; mso-generic-font-family:roman; mso-font-pitch:variable; mso-font-signature:647 0 0 0 159 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0cm; margin-bottom:.0001pt; mso-pagination:none; mso-layout-grid-align:none; text-autospace:none; font-size:12.0pt; font-family:"Bookman Old Style"; mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";} p.Style3, li.Style3, div.Style3 {mso-style-name:Style3; margin:0cm; margin-bottom:.0001pt; text-align:right; line-height:13.8pt; mso-line-height-rule:exactly; mso-pagination:none; mso-layout-grid-align:none; text-autospace:none; font-size:12.0pt; font-family:"Bookman Old Style"; mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";} p.Style10, li.Style10, div.Style10 {mso-style-name:Style10; margin:0cm; margin-bottom:.0001pt; mso-pagination:none; mso-layout-grid-align:none; text-autospace:none; font-size:12.0pt; font-family:"Bookman Old Style"; mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";} p.Style25, li.Style25, div.Style25 {mso-style-name:Style25; margin:0cm; margin-bottom:.0001pt; text-align:justify; text-indent:21.6pt; line-height:17.5pt; mso-line-height-rule:exactly; mso-pagination:none; mso-layout-grid-align:none; text-autospace:none; font-size:12.0pt; font-family:"Bookman Old Style"; mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";} p.Style92, li.Style92, div.Style92 {mso-style-name:Style92; margin:0cm; margin-bottom:.0001pt; mso-pagination:none; mso-layout-grid-align:none; text-autospace:none; font-size:12.0pt; font-family:"Bookman Old Style"; mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";} p.Style112, li.Style112, div.Style112 {mso-style-name:Style112; margin:0cm; margin-bottom:.0001pt; text-align:justify; line-height:15.85pt; mso-line-height-rule:exactly; mso-pagination:none; mso-layout-grid-align:none; text-autospace:none; font-size:12.0pt; font-family:"Bookman Old Style"; mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";} p.Style113, li.Style113, div.Style113 {mso-style-name:Style113; margin:0cm; margin-bottom:.0001pt; mso-pagination:none; mso-layout-grid-align:none; text-autospace:none; font-size:12.0pt; font-family:"Bookman Old Style"; mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";} p.Style121, li.Style121, div.Style121 {mso-style-name:Style121; margin:0cm; margin-bottom:.0001pt; text-align:center; mso-pagination:none; mso-layout-grid-align:none; text-autospace:none; font-size:12.0pt; font-family:"Bookman Old Style"; mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";} p.Style122, li.Style122, div.Style122 {mso-style-name:Style122; margin:0cm; margin-bottom:.0001pt; text-align:justify; mso-pagination:none; mso-layout-grid-align:none; text-autospace:none; font-size:12.0pt; font-family:"Bookman Old Style"; mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";} p.Style124, li.Style124, div.Style124 {mso-style-name:Style124; margin:0cm; margin-bottom:.0001pt; text-align:justify; line-height:17.6pt; mso-line-height-rule:exactly; mso-pagination:none; mso-layout-grid-align:none; text-autospace:none; font-size:12.0pt; font-family:"Bookman Old Style"; mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";} p.Style125, li.Style125, div.Style125 {mso-style-name:Style125; margin:0cm; margin-bottom:.0001pt; text-indent:-16.85pt; line-height:17.6pt; mso-line-height-rule:exactly; mso-pagination:none; mso-layout-grid-align:none; text-autospace:none; font-size:12.0pt; font-family:"Bookman Old Style"; mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";} p.Style126, li.Style126, div.Style126 {mso-style-name:Style126; margin:0cm; margin-bottom:.0001pt; text-align:center; mso-pagination:none; mso-layout-grid-align:none; text-autospace:none; font-size:12.0pt; font-family:"Bookman Old Style"; mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";} p.Style127, li.Style127, div.Style127 {mso-style-name:Style127; margin:0cm; margin-bottom:.0001pt; text-align:justify; text-indent:22.2pt; line-height:16.1pt; mso-line-height-rule:exactly; mso-pagination:none; mso-layout-grid-align:none; text-autospace:none; font-size:12.0pt; font-family:"Bookman Old Style"; mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";} p.Style128, li.Style128, div.Style128 {mso-style-name:Style128; margin:0cm; margin-bottom:.0001pt; text-align:justify; text-indent:-22.2pt; line-height:18.75pt; mso-line-height-rule:exactly; mso-pagination:none; mso-layout-grid-align:none; text-autospace:none; font-size:12.0pt; font-family:"Bookman Old Style"; mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";} p.Style132, li.Style132, div.Style132 {mso-style-name:Style132; margin:0cm; margin-bottom:.0001pt; text-align:center; mso-pagination:none; mso-layout-grid-align:none; text-autospace:none; font-size:12.0pt; font-family:"Bookman Old Style"; mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";} p.Style135, li.Style135, div.Style135 {mso-style-name:Style135; margin:0cm; margin-bottom:.0001pt; text-align:justify; text-indent:-15.7pt; line-height:17.45pt; mso-line-height-rule:exactly; mso-pagination:none; mso-layout-grid-align:none; text-autospace:none; font-size:12.0pt; font-family:"Bookman Old Style"; mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";} span.FontStyle294 {mso-style-name:"Font Style294"; mso-ansi-font-size:15.0pt; mso-bidi-font-size:15.0pt; font-family:"MS Reference Sans Serif"; mso-ascii-font-family:"MS Reference Sans Serif"; mso-hansi-font-family:"MS Reference Sans Serif"; mso-bidi-font-family:"MS Reference Sans Serif"; letter-spacing:.5pt; font-style:italic;} span.FontStyle299 {mso-style-name:"Font Style299"; mso-ansi-font-size:16.0pt; mso-bidi-font-size:16.0pt; font-family:"MS Reference Sans Serif"; mso-ascii-font-family:"MS Reference Sans Serif"; mso-hansi-font-family:"MS Reference Sans Serif"; mso-bidi-font-family:"MS Reference Sans Serif";} span.FontStyle314 {mso-style-name:"Font Style314"; mso-ansi-font-size:18.0pt; mso-bidi-font-size:18.0pt; font-family:Tahoma; mso-ascii-font-family:Tahoma; mso-hansi-font-family:Tahoma; mso-bidi-font-family:Tahoma; letter-spacing:-.5pt; font-weight:bold;} span.FontStyle320 {mso-style-name:"Font Style320"; mso-ansi-font-size:13.0pt; mso-bidi-font-size:13.0pt; font-family:"MS Reference Sans Serif"; mso-ascii-font-family:"MS Reference Sans Serif"; mso-hansi-font-family:"MS Reference Sans Serif"; mso-bidi-font-family:"MS Reference Sans Serif"; letter-spacing:-1.0pt; font-weight:bold;} span.FontStyle331 {mso-style-name:"Font Style331"; mso-ansi-font-size:10.0pt; mso-bidi-font-size:10.0pt; font-family:"Bookman Old Style"; mso-ascii-font-family:"Bookman Old Style"; mso-hansi-font-family:"Bookman Old Style"; mso-bidi-font-family:"Bookman Old Style"; font-weight:bold;} span.FontStyle336 {mso-style-name:"Font Style336"; mso-ansi-font-size:12.0pt; mso-bidi-font-size:12.0pt; font-family:"Bookman Old Style"; mso-ascii-font-family:"Bookman Old Style"; mso-hansi-font-family:"Bookman Old Style"; mso-bidi-font-family:"Bookman Old Style"; font-weight:bold;} span.FontStyle340 {mso-style-name:"Font Style340"; mso-ansi-font-size:16.0pt; mso-bidi-font-size:16.0pt; font-family:"Bookman Old Style"; mso-ascii-font-family:"Bookman Old Style"; mso-hansi-font-family:"Bookman Old Style"; mso-bidi-font-family:"Bookman Old Style";} span.FontStyle343 {mso-style-name:"Font Style343"; mso-ansi-font-size:14.0pt; mso-bidi-font-size:14.0pt; font-family:"Bookman Old Style"; mso-ascii-font-family:"Bookman Old Style"; mso-hansi-font-family:"Bookman Old Style"; mso-bidi-font-family:"Bookman Old Style"; letter-spacing:-.5pt; font-weight:bold;} span.FontStyle345 {mso-style-name:"Font Style345"; mso-ansi-font-size:10.0pt; mso-bidi-font-size:10.0pt; font-family:"Bookman Old Style"; mso-ascii-font-family:"Bookman Old Style"; mso-hansi-font-family:"Bookman Old Style"; mso-bidi-font-family:"Bookman Old Style"; font-weight:bold;} @page Section1 {size:841.85pt 1190.5pt; margin:298.7pt 172.8pt 72.0pt 208.8pt; mso-header-margin:36.0pt; mso-footer-margin:36.0pt; mso-paper-source:0;} div.Section1 {page:Section1;} @page Section2 {size:612.0pt 792.0pt; margin:2.0cm 42.5pt 2.0cm 3.0cm; mso-header-margin:36.0pt; mso-footer-margin:36.0pt; mso-paper-source:0;} div.Section2 {page:Section2;} /* List Definitions */ @list l0 {mso-list-id:-2; mso-list-type:simple; mso-list-template-ids:1946826162;} @list l0:level1 {mso-level-start-at:0; mso-level-number-format:bullet; mso-level-text:*; mso-level-tab-stop:none; mso-level-number-position:left; margin-left:0cm; text-indent:0cm;} @list l1 {mso-list-id:1112213927; mso-list-type:simple; mso-list-template-ids:-336688602;} @list l1:level1 {mso-level-text:"%1\)"; mso-level-tab-stop:none; mso-level-number-position:left; mso-level-legacy:yes; mso-level-legacy-indent:22.2pt; mso-level-legacy-space:0cm; margin-left:0cm; text-indent:0cm; font-family:"Bookman Old Style";} @list l0:level1 lfo1 {mso-level-start-at:65535; mso-level-numbering:continue; mso-level-text:•; mso-level-tab-stop:none; mso-level-number-position:left; mso-level-legacy:yes; mso-level-legacy-indent:15.7pt; mso-level-legacy-space:0cm; margin-left:0cm; text-indent:0cm; font-family:"Bookman Old Style";} @list l0:level1 lfo2 {mso-level-start-at:65535; mso-level-numbering:continue; mso-level-text:•; mso-level-tab-stop:none; mso-level-number-position:left; mso-level-legacy:yes; mso-level-legacy-indent:16.85pt; mso-level-legacy-space:0cm; margin-left:0cm; text-indent:0cm; font-family:"Bookman Old Style";} ol {margin-bottom:0cm;} ul {margin-bottom:0cm;} --> </style>

Компьютерный практикум<o:p> </o:p>

<o:p> </o:p>

Работа 7. Реализация сложных запросов<o:p></o:p>

<o:p> </o:p>

Цели работы:<o:p></o:p>

            •       закрепление навыков до созданию и заполнению таблиц;<o:p></o:p>

            •      отработка приемов реализации сложных запросов на вы­борку;<o:p></o:p>

            •      обучение реализации запросов на удаление, а также ис­пользованию вычисляемых полей в запросах. Используемые программные средства:MS Access


<span style="letter-spacing: -0.5pt;" />'<span style="letter-spacing: -0.5pt;" /><span class="FontStyle340" /><o:p></o:p>

Задание 1<span class="FontStyle320"

<span style="font-size: 11pt; font-family: "Times New Roman";" />

<o:p> </o:p><o:p></o:p>

Создать таблицу «Оценки» и ввести в нее данные, пред­ставленные в теме 19 в табл.1.11.<o:p></o:p>

Задание 2<span style="font-size: 11pt; font-family: "Times New Roman";" /><o:p></o:p>

Используя конструктор запросовMS Access, выполнить все запросы, описанные в § 1.14.<o:p></o:p>

<o:p> </o:p><o:p></o:p>

Задание 3<o:p></o:p>

Реализовать в конструкторе запросов следующие зада­ния:<o:p></o:p>

1)                  получить таблицу, содержащую фамилии абитуриен­тов и средние значения оценок, полученных на экзаме­нах;<o:p></o:p>

2)                  получить список лишь тех абитуриентов, у которых оценка за первый экзамен больше среднего балла за все экзамены;<o:p></o:p>

3)                  предположим, что действует следующее правило: на экономический факультет университета принимаются те абитуриенты, у которых сумма баллов за экзамены не меньше 14; на исторический факультет — не мень­ше 13; на юридический факультет — не меньше 12. Получить список принятых на каждый факультет»<o:p></o:p>

указав факультеты, специальности, фамилии, имена, отчества. Отсортировать список по факультету и еде* циальеости.<o:p></o:p>

Работа 8. Творческое задание на реализацию<o:p></o:p>

сложных запросов<o:p></o:p>

Цель работы: отработка умения формулировать сложные запросы и реализовывать их с помощью конструктора в MS Access.<o:p></o:p>

Используемые программные средства: MS Access. Задание<o:p></o:p>

Выполнить различные типы запросов к самостоятельно созданной базе данных* Для этого:<o:p></o:p>

•               придумать общую формулировку не менее, чем пяти за­просов на выборку с использованием сложных условий отбора и сортировки;<o:p></o:p>

•               записать в тетради команды запросов на гипотетическом языке;<o:p></o:p>

•               реализовать запросы с помощью конструктора в MS Access;<o:p></o:p>

•               придумать и реализовать запросы на удаление записей;<o:p></o:p>

•               придумать и реализовать запросы с использованием вы­числяемых полей.<o:p></o:p>

<span style="font-size: 11pt; font-weight: normal;" /><o:p></o:p>


Семакин И.Г., Хеннер Е.К., Информатика и ИКТ, 11

Отослано читателями из интернет-сайтов


Содержание урока
1236084776 kr.jpg конспект урока                       
1236084776 kr.jpg опорный каркас  
1236084776 kr.jpg презентация урока
1236084776 kr.jpg акселеративные методы 
1236084776 kr.jpg интерактивные технологии 

Практика
1236084776 kr.jpg задачи и упражнения 
1236084776 kr.jpg самопроверка
1236084776 kr.jpg практикумы, тренинги, кейсы, квесты
1236084776 kr.jpg домашние задания
1236084776 kr.jpg дискуссионные вопросы
1236084776 kr.jpg риторические вопросы от учеников
 
Иллюстрации
1236084776 kr.jpg аудио-, видеоклипы и мультимедиа 
1236084776 kr.jpg фотографии, картинки 
1236084776 kr.jpg графики, таблицы, схемы
1236084776 kr.jpg юмор, анекдоты, приколы, комиксы
1236084776 kr.jpg притчи, поговорки, кроссворды, цитаты

Дополнения
1236084776 kr.jpg рефераты
1236084776 kr.jpg статьи 
1236084776 kr.jpg фишки для любознательных 
1236084776 kr.jpg шпаргалки 
1236084776 kr.jpg учебники основные и дополнительные
1236084776 kr.jpg словарь терминов                          
1236084776 kr.jpg прочие 

Совершенствование учебников и уроков
1236084776 kr.jpg исправление ошибок в учебнике
1236084776 kr.jpg обновление фрагмента в учебнике 
1236084776 kr.jpg элементы новаторства на уроке 
1236084776 kr.jpg замена устаревших знаний новыми 
 
Только для учителей
1236084776 kr.jpg идеальные уроки 
1236084776 kr.jpg календарный план на год  
1236084776 kr.jpg методические рекомендации  
1236084776 kr.jpg программы
1236084776 kr.jpg обсуждения


Интегрированные уроки


Если у вас есть исправления или предложения к данному уроку, напишите нам.

Если вы хотите увидеть другие корректировки и пожелания к урокам, смотрите здесь - Образовательный форум.

Источник — «http://edufuture.biz/index.php?title=%D0%9A%D0%BE%D0%BC%D0%BF%D1%8C%D1%8E%D1%82%D0%B5%D1%80%D0%BD%D1%8B%D0%B9_%D0%BF%D1%80%D0%B0%D0%BA%D1%82%D0%B8%D0%BA%D1%83%D0%BC:_%D0%A0%D0%B0%D0%B1%D0%BE%D1%82%D0%B0_7._%D0%A0%D0%B5%D0%B0%D0%BB%D0%B8%D0%B7%D0%B0%D1%86%D0%B8%D1%8F_%D1%81%D0%BB%D0%BE%D0%B6%D0%BD%D1%8B%D1%85_%D0%B7%D0%B0%D0%BF%D1%80%D0%BE%D1%81%D0%BE%D0%B2»

Авторські права | Privacy Policy |FAQ | Партнери | Контакти | Кейс-уроки

©  Автор системы образования 7W и Гипермаркета Знаний - Владимир Спиваковский

При использовании материалов ресурса
ссылка на edufuture.biz обязательна (для интернет ресурсов - гиперссылка).
edufuture.biz 2008-© Все права защищены.
Сайт edufuture.biz является порталом, в котором не предусмотрены темы политики, наркомании, алкоголизма, курения и других "взрослых" тем.

Разработка - Гипермаркет знаний 2008-

Ждем Ваши замечания и предложения на email:
По вопросам рекламы и спонсорства пишите на email: