You could look at Greg Bowden's Guided computer tutorials. (<a href="http://gct.com.au">gct.com.au</a>)<br><br>As for level of difficulty, here are VCAA's mandated skills...<br><p>The following functions apply to ITA Unit 3:</p>
<ul><li>create tables</li><li>create relationships between tables</li><li>use a range of data types</li><li>electronic validation</li><li>create, edit and use queries</li><li>use of calculated fields</li><li>sort records or index on different fields.</li>
</ul>
<p>If students use a relational database management system in Unit 4 ITA, the following additional functions apply:</p>
<ul><li>import/export of data</li><li>format data for display</li><li>create and edit a range of forms, including different data types and controls</li><li>create and edit a range of formatted reports.</li></ul><br>
<br><div class="gmail_quote">On 19 April 2012 09:07, POLLOCK, Benn(POL) <span dir="ltr"><<a href="mailto:POL@wantirnacollege.vic.edu.au">POL@wantirnacollege.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">Currently, my students are completing some in-class tutorials on creating relational databases for their SAC. We have 2010 Access at our school however I can’t seem to find many good tutorials to help teach them. I’m also new to access so trying to wrap my head around everything at the same time has been a little daunting. I’m also not sure about the complexity of the required relational database that the students are required to complete. Can someone give me an insight into the complexity that they’re expecting from their students? – Also If anyone has any links to resources or wants to share some of their class tutorials with me – I would be very grateful. <u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">Cheers<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal"><span style="font-size:14.0pt;font-family:"Tw Cen MT Condensed","sans-serif";color:#c4163f">Benn Pollock<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:"Tw Cen MT Condensed","sans-serif";color:#e36c0a">Information Technology Teacher<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:14.0pt;font-family:"Tw Cen MT Condensed","sans-serif";color:#2a13b5">Wantirna College<u></u><u></u></span></p>
<p class="MsoNormal"><u><span style="font-size:8.0pt;font-family:"Arial","sans-serif";color:red">Ph:</span></u><span style="font-size:8.0pt;font-family:"Arial","sans-serif""> </span><span style="font-size:8.0pt;font-family:"Arial","sans-serif"">9801 9700<u></u><u></u></span></p>
<p class="MsoNormal"><span><u></u> <u></u></span></p><p class="MsoNormal"><u></u> <u></u></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 <br><br>
<a href="http://www.vitta.org.au" 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" target="_blank">http://www.swinburne.edu.au/ict/schools</a> - Swinburne University<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> (don't use my Edumail account!)<br>
VCE IT Lecture Notes: <a href="http://vceit.com" target="_blank">http://vceit.com</a><br>Moderator: IT Applications Edulist<br><br>--<br>An E-flat, a C, and a G go into a bar. The bartender says, "I'm sorry, but I can't serve minors."<br>
<br><br>