[Year 12 IT Apps] U3O2 - Relational Databased + Access

[Mark KELLY]

I used Filemaker so it wasn't the same for me.
IMO, creating forms isn't too onerous, and it's a very basic and vital
skill.

On 23 April 2012 10:18, Smallacombe, Kate B <
smallacombe.kate.b at edumail.vic.gov.au> wrote:

>  Hi all,****
>
> ** **
>
> I’ve read the list below of what’s required for U3O2. Just wondering, do
> you teach forms as part of this outcome or can students just enter the data
> directly into the tables?****
>
> ** **
>
> Cheers,****
>
> ** **
>
> Kate Smallacombe****
>
> Brighton Secondary College****
>
> 120 Marriage Road****
>
> Brighton East 3187****
>
> ** **
>
> *From:* itapps-bounces at edulists.com.au [mailto:
> itapps-bounces at edulists.com.au] *On Behalf Of *Mark KELLY
> *Sent:* Thursday, 19 April 2012 11:00 AM
>
> *To:* Year 12 IT Applications Teachers' Mailing List
> *Subject:* Re: [Year 12 IT Apps] U3O2 - Relational Databased + Access****
>
> ** **
>
> You could look at Greg Bowden's Guided computer tutorials. (gct.com.au)
>
>
> As for level of difficulty, here are VCAA's mandated skills...****
>
> The following functions apply to ITA Unit 3:****
>
>    - create tables****
>    - create relationships between tables****
>    - use a range of data types****
>    - electronic validation****
>    - create, edit and use queries****
>    - use of calculated fields****
>    - sort records or index on different fields.****
>
> If students use a relational database management system in Unit 4 ITA, the
> following additional functions apply:****
>
>    - import/export of data****
>    - format data for display****
>    - create and edit a range of forms, including different data types and
>    controls****
>    - create and edit a range of formatted reports.****
>
> ** **
>
> On 19 April 2012 09:07, POLLOCK, Benn(POL) <POL at wantirnacollege.vic.edu.au>
> wrote:****
>
> 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. ****
>
>  ****
>
> Cheers****
>
>  ****
>
> Benn Pollock****
>
> Information Technology Teacher****
>
> Wantirna College****
>
> *Ph:* 9801 9700****
>
>  ****
>
>  ****
>
>
> _______________________________________________
> http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
> IT Applications Mailing List kindly supported by
> http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html -
> Victorian Curriculum and Assessment Authority <br>
> http://www.vitta.org.au  - VITTA Victorian Information Technology
> Teachers Association Inc <br>
> http://www.swinburne.edu.au/ict/schools - Swinburne University****
>
>
>
>
> --
> Mark Kelly
> Manager of ICT, Reporting, IT Learning Area
> McKinnon Secondary College
> McKinnon Rd McKinnon 3204, Victoria, Australia
> Direct line / Voicemail: +613 8520 9085, Fax +613 9578 9253
> kel at mckinnonsc.vic.edu.au (don't use my Edumail account!)
> VCE IT Lecture Notes: http://vceit.com
> Moderator: IT Applications Edulist
>
> --
> An E-flat, a C, and a G go into a bar. The bartender says, "I'm sorry, but
> I can't serve minors."
>
> ****
>
> *Important - *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 Early
> Childhood Development.
>
> _______________________________________________
> http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
> IT Applications Mailing List kindly supported by
> http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html -
> Victorian Curriculum and Assessment Authority <br>
> http://www.vitta.org.au  - VITTA Victorian Information Technology
> Teachers Association Inc <br>
> http://www.swinburne.edu.au/ict/schools - Swinburne University
>



-- 
Mark Kelly
Manager of ICT, Reporting, IT Learning Area
McKinnon Secondary College
McKinnon Rd McKinnon 3204, Victoria, Australia
Direct line / Voicemail: +613 8520 9085, Fax +613 9578 9253
kel at mckinnonsc.vic.edu.au (don't use my Edumail account!)
VCE IT Lecture Notes: http://vceit.com
Moderator: IT Applications Edulist

--
An E-flat, a C, and a G go into a bar. The bartender says, "I'm sorry, but
I can't serve minors."
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20120423/518a208f/attachment.html