[Year 12 IT Apps] (no subject)

[Kent Beveridge]

Oh, can I also add, that the Cert 3 VET course also contains some units involving DB stuff and I am doing this with my 10's right now. We are creating lists of data, (records) and merging into a word doc for a form letter and doing queries and reports for obtaining and using filtered output.





Kent Beveridge
ICT Co-ordinator, St.Brigids CSC, HORSHAM,Vic,Aus.
kbeveridge at stbc.vic.edu.au<mailto:kbeveridge at stbc.vic.edu.au>

________________________________
From: itapps-bounces at edulists.com.au [itapps-bounces at edulists.com.au] on behalf of Mark KELLY [kel at mckinnonsc.vic.edu.au]
Sent: Saturday, 28 May 2011 11:15 AM
To: Year 12 IT Applications Teachers' Mailing List
Subject: Re: [Year 12 IT Apps] (no subject)

People might laugh at Access users, but think of us Filemaker users.

In the street, dogs laugh at us, children bite us, and accountants poke us with sticks  :-(

On 27 May 2011 19:51, Jenny Gielb <Tafe at imaginethis.biz<mailto:Tafe at imaginethis.biz>> wrote:
Hi,
A lot of IT people laugh at MS Access, they view it as puny and inconsequential. As someone who has made quite a bit of money out of developing MS Access databases for many different businesses, I laugh at them.
It is not as secure or reliable as SQL or MYSQL, or as relevant in terms of internet development but it is a very powerful tool. It has the benefit of being already available to anyone with Office, it has a fantastic GUI interface which PHP, .NET, VB, Crystal Reports and SQL do not have. It also has everything in the one package, which none of the others have. It is basically the best available software to train anyone in databases and system development. Once a student understands the concepts of database design, VBA code and front-end screen development, they can easily pick up any other database tool.
I agree, it would be more beneficial to teach the students web-based coding and databases, but that is very complex, is changing constantly, and there is so many choices there that you can't decide what to use.
I think teaching them the basics of databases and websites is more important, they can take it further if they want later.

As an Access developer I have never ever, and wouldn't ever use drop-down boxes on tables. Drop-down boxes are for forms and data entry. Don't confuse the issue. Tables are for storing data, forms are for entering and displaying, reports are for displaying data. You have to set up basic forms for data entry anyway.
Jenny



--
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>
VCE IT Lecture Notes: http://vceit.com
Moderator: IT Applications Edulist

Want a good time? Call 0112358. Ask for Mr Fibonacci.



Click here<https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg==> to report this email as spam.


This message has been scanned for malware by Websense. www.websense.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20110528/092bb94c/attachment.html