<div dir="ltr"><div class="gmail_default" style="font-family:'trebuchet ms',sans-serif;font-size:small">Hi Daryl</div><div class="gmail_default" style="font-family:'trebuchet ms',sans-serif;font-size:small"><br></div><div class="gmail_default" style="font-family:'trebuchet ms',sans-serif;font-size:small">If you just need to know the VCAA-mandated RDBMS <a href="http://www.vcaa.vic.edu.au/Documents/vce/computing/InformaticsSoftwareToolsFunctions.docx">functions for 2016+</a>, they are:</div><div class="gmail_default" style="font-family:'trebuchet ms',sans-serif;font-size:small"><p class=""></p><ul><li><span lang="EN-GB">create
tables</span><br></li><li><span lang="EN-GB">create
relationships between tables</span><br></li><li><span lang="EN-GB">use a
range of data types</span><br></li><li><span lang="EN-GB">electronically
validate data</span><br></li><li><span lang="EN-GB">create,
edit and use queries</span><br></li><li><span lang="EN-GB">search
and filter records</span><br></li><li><span lang="EN-GB">perform
calculations</span><br></li><li><span lang="EN-GB">create
and edit formatted reports</span><br></li><li><span lang="EN-GB">sort
records or index on different fields.</span><br></li></ul><p></p>
<p class=""><span lang="EN-GB">That would include (IMHO)</span></p><p class=""></p><ul><li>MS Access, <br></li><li><span lang="EN-GB">Filemaker Pro (but be conscious of examiners' inbuilt antipathy to </span>Filemaker's calculated fields and - maybe - lack of a "maintain referential integrity" option, and lack of input masks [which may have been implied in the 2015 ITA exam]), <br></li><li>MySQL with a GUI front-end, and <br></li><li>OpenOffice or LibreOffice (have not tried them in recent years. Can't speak for their functionality or ease of use)<br></li><li>KellyBase (a new and exciting RDBMS written in 'Scratch' and available sometime in 2020 for only $600,000 per seat. Order NOW! Pre-payment is <b>mandatory</b>. Delivery is <b>not</b> guaranteed.)</li></ul><p></p><p class="">Cheers<br></p><p class=""><span lang="EN-GB">Mark</span></p></div><div class="gmail_extra"><br><div class="gmail_quote">On 18 November 2015 at 13:21, Croke, Daryl D <span dir="ltr"><<a href="mailto:croke.daryl.d@edumail.vic.gov.au" target="_blank">croke.daryl.d@edumail.vic.gov.au</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div>
<div style="direction:ltr;font-family:Verdana;color:rgb(0,0,0);font-size:12pt">
Hi all
<div><br>
</div>
<div>We are running Informatics in 2016 for the first time. </div>
<div><br>
</div>
<div>Needs some advice on software requirement for databases. What options are there? Class will run in a PC lab. <br>
<div><br>
<div style="font-family:Tahoma;font-size:13px">
<div style="font-family:Tahoma;font-size:13px">
<div style="font-family:Tahoma;font-size:13px">
<div style="font-family:Tahoma;font-size:13px">Cheers<br>
<br>
Daryl Croke<br>
<br>
</div>
<div style="font-family:Tahoma;font-size:13px">Senior School eLearning Leader<br>
Mount Ridley College<br>
8338 3600<br>
<a href="http://mountridleycollege.vic.edu.au/" target="_blank">http://mountridleycollege.vic.edu.au/</a><br>
</div>
<div style="font-family:Tahoma;font-size:13px"><br>
</div>
<div style="font-family:Tahoma;font-size:13px"><i><b>keep on coding</b></i></div>
<div><i><a href="http://geekstuff.global2.vic.edu.au/" target="_blank">http://geekstuff.global2.vic.edu.au/</a><br>
<a href="http://physicalcomputing.global2.vic.edu.au/" target="_blank">http://physicalcomputing.global2.vic.edu.au/</a></i></div>
<div><i><br>
</i></div>
<div><i><br>
</i></div>
</div>
</div>
</div>
</div>
</div>
</div>
<p></p><p><b>Important - </b>This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education and Training.</p>
</div>
<br>_______________________________________________<br>
<a href="http://www.edulists.com.au" rel="noreferrer" 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" rel="noreferrer" target="_blank">http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html</a> - Victorian Curriculum and Assessment Authority <br><br>
<a href="http://www.vitta.org.au" rel="noreferrer" target="_blank">http://www.vitta.org.au</a> - VITTA Victorian Information Technology Teachers Association Inc <br><br>
<a href="http://www.swinburne.edu.au/ict/schools" rel="noreferrer" target="_blank">http://www.swinburne.edu.au/ict/schools</a> - Swinburne University<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div><i><br></i></div><div><span style="font-size:12.8px">Mark Kelly</span><br></div><div><br></div><div><a href="mailto:mark@vceit.com" style="font-size:12.8px" target="_blank">mark@vceit.com</a><br></div><div><a href="http://vceit.com" target="_blank">http://vceit.com</a></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>
</div></div>