[Year 12 IT Apps] U3O1 Advanced Access Tutorials

[Lappin, Jason M]

Hi List
I am currently in the middle of my Yr 12 Headstart program for 09 and I was wondering if there was anyone out there who has an advanced tutorial/s for Access. My students have some experience and I was hoping to give them a reasonably challenging task to complete over the break. Any help would be appreciated.
Jason Lappin
Year 10 Coordinator 
Rutherglen High School

________________________________

From: itapps-bounces at edulists.com.au on behalf of Mark Kelly
Sent: Thu 13/11/2008 2:45 PM
To: Year 12 IT Applications Teachers' Mailing List
Subject: [Year 12 IT Apps] Q12 redux



I've been pondering Q12 and I've worked out where we've differed.  I've
been thinking of the dropdown list more as a tool for selecting an
existing ID, rather than entering a NEW record.

The exam question does not explain the principal purpose of the form -
is it for data entry or editing?  If it's for entry of new records, I
agree that it would be pretty useless to use a dropdown list.  However
for editing existing data, a dropdown list with matching "Find" button
would be useful.

So in that sense, I'm changing my mind.

But I still don't accept that a dropdown list is suitable as the sole
means of entering a title.

Sure, provide a list stacked with common titles to save time for data
entry, but there should be some other way of entering titles that are
not in the list. (e.g. a simple "Other..." plus a textbox.)

But, examiners being examiners, B is the best of a bad bunch of options.


--
Mark Kelly
Manager - Information Systems
McKinnon Secondary College
McKinnon Rd McKinnon 3204, Victoria, Australia
Direct line / Voicemail: 8520 9085
School Phone +613 8520 9000
School Fax +613 9578 9253
kel at mckinnonsc.vic.edu.au

Webmaster - http://www.mckinnonsc.vic.edu.au <http://www.mckinnonsc.vic.edu.au/> 
IT Lecture notes: http://vceit.com <http://vceit.com/> 
Moderator: IT Applications Mailing List

Most people don't realise that small kitchen sponges, when nailed to the
forehead, can really REALLY hurt.

_______________________________________________
http://www.edulists.com.au <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 and
http://www.vitta.org.au <http://www.vitta.org.au/>   - VITTA Victorian Information Technology Teachers Association Inc



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 --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 5325 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20081117/4dfb8775/attachment.bin