Hi, OtherMark<br><br>Formatting is not important to this outcome, but it is assessable if RDBMS is used for U4O1...<br><br><p><strong>If students use a relational database management system in Unit 4, the following additional functions apply:</strong></p>
<ul><li><strong>import/export of data</strong></li><li><strong>format data for display</strong></li><li><strong>create and edit a range of forms, including different data types and controls</strong></li><li><strong>create and edit a range of formatted reports.</strong></li>
</ul><br><br><div class="gmail_quote">On 26 May 2011 10:47, Mark Scott <span dir="ltr"><<a href="mailto:msc@luther.vic.edu.au">msc@luther.vic.edu.au</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div link="blue" vlink="purple" lang="EN-AU"><div><p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"> </span></p><p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">HELP!!!!!!!!</span></p><p class="MsoNormal">
<span style="font-size:11.0pt;color:#1F497D"> </span></p><p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">From VCAA</span></p><p class="MsoNormal"><i><span style="font-size:11.0pt;color:#1F497D">Relational database management system <br>
The following functions apply to Unit 3:</span></i></p><p><span style="font-size:11.0pt;font-family:Symbol;color:#1F497D"><span>·<span style="font:7.0pt "Times New Roman""> </span></span></span><i><span style="font-size:11.0pt;color:#1F497D">create tables</span></i></p>
<p><span style="font-size:11.0pt;font-family:Symbol;color:#1F497D"><span>·<span style="font:7.0pt "Times New Roman""> </span></span></span><i><span style="font-size:11.0pt;color:#1F497D">create relationships between tables</span></i></p>
<p><span style="font-size:11.0pt;font-family:Symbol;color:#1F497D"><span>·<span style="font:7.0pt "Times New Roman""> </span></span></span><i><span style="font-size:11.0pt;color:#1F497D">use a range of data types</span></i></p>
<p><span style="font-size:11.0pt;font-family:Symbol;color:#1F497D"><span>·<span style="font:7.0pt "Times New Roman""> </span></span></span><i><span style="font-size:11.0pt;color:#1F497D">electronic validation</span></i></p>
<p><span style="font-size:11.0pt;font-family:Symbol;color:#1F497D"><span>·<span style="font:7.0pt "Times New Roman""> </span></span></span><i><span style="font-size:11.0pt;color:#1F497D">create, edit and use queries</span></i></p>
<p><span style="font-size:11.0pt;font-family:Symbol;color:#1F497D"><span>·<span style="font:7.0pt "Times New Roman""> </span></span></span><i><span style="font-size:11.0pt;color:#1F497D">use of calculated fields</span></i></p>
<p><span style="font-size:11.0pt;font-family:Symbol;color:#1F497D"><span>·<span style="font:7.0pt "Times New Roman""> </span></span></span><i><span style="font-size:11.0pt;color:#1F497D">sort records or index on different fields.</span></i></p>
<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"> </span></p><p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">Can someone confirm that:</span></p><p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"> </span></p>
<p><span style="font-size:11.0pt;font-family:Symbol;color:#1F497D"><span>·<span style="font:7.0pt "Times New Roman""> </span></span></span><span style="font-size:11.0pt;color:#1F497D">formatting (apart from sorting) is not a part of this SAC?<br>
<br></span></p><p><span style="font-size:11.0pt;font-family:Symbol;color:#1F497D"><span>·<span style="font:7.0pt "Times New Roman""> </span></span></span><span style="font-size:11.0pt;color:#1F497D">drop down lists are not appropriate for tables (only forms)</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"> </span></p><p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">Mark Scott</span></p><p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">Luther College</span></p>
</div></div><br>_______________________________________________<br>
<a href="http://www.edulists.com.au" target="_blank">http://www.edulists.com.au</a> - FAQ, resources, subscribe, unsubscribe<br>
IT Applications Mailing List kindly supported by<br>
<a href="http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html" target="_blank">http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html</a> - Victorian Curriculum and Assessment Authority and<br>
<a href="http://www.vitta.org.au" target="_blank">http://www.vitta.org.au</a> - VITTA Victorian Information Technology Teachers Association Inc<br></blockquote></div><br><br clear="all"><br>-- <br>Mark Kelly<br>Manager of ICT, Reporting, IT Learning Area<br>
McKinnon Secondary College<br>McKinnon Rd McKinnon 3204, Victoria, Australia<br>Direct line / Voicemail: +613 8520 9085, Fax +613 9578 9253<br><a href="mailto:kel@mckinnonsc.vic.edu.au" target="_blank">kel@mckinnonsc.vic.edu.au</a><br>
VCE IT Lecture Notes: <a href="http://vceit.com" target="_blank">http://vceit.com</a><br>Moderator: IT Applications Edulist<br><br><font>Want a good time? Call 0112358. Ask for Mr </font>Fibonacci.<br>