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

Mon Apr 23 12:47:20 EST 2012

Hi Kate,

It depends on how quickly my kids get the hang of Access.

Last year I did not teach forms and they just entered directly into tables, but my kids this year seem to be able to handle a little more, so I'll probably teach them how to do things properly.

Regards,

Jackson Bates
Waverley Christian College

-----Original Message-----
From: itapps-bounces at edulists.com.au [mailto:itapps-bounces at edulists.com.au] On Behalf Of itapps-request at edulists.com.au
Sent: Monday, 23 April 2012 12:00 PM
To: itapps at edulists.com.au
Subject: itapps Digest, Vol 86, Issue 27

Send itapps mailing list submissions to
        itapps at edulists.com.au

To subscribe or unsubscribe via the World Wide Web, visit
        http://www.edulists.com.au/mailman/listinfo/itapps
or, via email, send a message with subject or body 'help' to
        itapps-request at edulists.com.au

You can reach the person managing the list at
        itapps-owner at edulists.com.au

When replying, please edit your Subject line so it is more specific than "Re: Contents of itapps digest..."

Today's Topics:

   1. Re: U3O2 - Relational Databased + Access (Smallacombe, Kate B)

----------------------------------------------------------------------

Message: 1
Date: Mon, 23 Apr 2012 00:18:53 +0000
From: "Smallacombe, Kate B" <smallacombe.kate.b at edumail.vic.gov.au>
Subject: Re: [Year 12 IT Apps] U3O2 - Relational Databased + Access
To: "Year 12 IT Applications Teachers' Mailing List"
        <itapps at edulists.com.au>
Message-ID:
        <170B6517444950479B8C6C39F171C98801312A60 at EDUMBX09.education.vic.gov.au>

Content-Type: text/plain; charset="us-ascii"

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<http://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<mailto: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<mailto: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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20120423/1866f42c/attachment-0001.html

------------------------------

_______________________________________________
itapps mailing list
itapps at edulists.com.au
http://www.edulists.com.au/mailman/listinfo/itapps

End of itapps Digest, Vol 86, Issue 27
**************************************

________________________________

[WCCSIG]

------------------------------------------
DISCLAIMER: This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please delete it immediately and notify the system administrator on srvadm at wcc.vic.edu.au.
WARNING: Although the college has taken reasonable precautions to ensure no viruses are present in this email, the college cannot accept responsibility for any loss or damage arising from the use of this email or attachments.
------------------------------------------