[Year 12 IT Apps] Suggestion for a teacher resource..

[Roland Gesthuizen]

Interestingly enough, the bit of SQL code that Kevork quoted here is an
appropriate and universal way to design and build a database query. It works
with OpenOffice Base as well as Access and Mark can confirm that it can work
with FileMaker Pro.

Whilst we can use a drag and drop interface to build these bits of code, it
is certainly worth showing your students the underlying SQL query that is
being built up.

Regards Roland

On 14/03/07, Kent Beveridge <kbeveridge at stbc.vic.edu.au> wrote:
>
> Hi all,
> Obviously, there are many of you guys and gals out there who have great
> skills with database queries, validation techniques etc, so...
> how about if a 'database of subroutines', using for example, some of the
> query routines just posted in answer to other's questions, could be created.
> Would this be in breach of any rules Kevork? This way, we could allow
> those who use 'non-proprietary' database programs(non-Access!) as well as
> Access to be able to access some quick solutions that we are coming across.
> After all, professional programmers store a database of subroutines and call
> them up then modify them to suit the project or application.
> Surely this is encouraging good practice whilst assisting others at the
> same time.  What do you think folks?
>
> This could also apply to some of the other software based applications we
> need to teach our students during the year for the other outcomes too.
> Hopefully, this does not breach any VCAA rules.
> This does not need to be subject specific.
>
> Kent Beveridge,
> I.T. to years 8-12
> St. Brigids Catholic Sec. College
> Horsham
>
> "This email and any attachments may be confidential.  You must not
> disclose or use the information in this email if you are not the intended
> recipient.  If you have received this email in error, please notify us
> immediately and delete the email and all copies.  The School does not
> guarantee that this email is virus or error free.  The attached files are
> provided and my only be used on the basis that the user assumes all
> responsibility for any loss, damage or consequence resulting directly or
> indirectly from the use of the attached files, whether caused by the
> negligence of the sender or not.  The content and opinions in this email are
> not necessarily those of the School."
>
> ________________________________
>
> From: itapps-bounces at edulists.com.au on behalf of Kevork Krozian
> Sent: Tue 13/03/2007 10:26 PM
> To: Year 12 IT Applications Teachers' Mailing List
> Subject: Re: [Year 12 IT Apps] Access question
>
>
> Hi Mark,
>
> A table ( Table1) with 4 fields ( ID, name, surname, suburb and postcode
> ).
> We want to count how many times a suburb occurs and order from highest to
> lowest.
>
> Create a new query, Add the table to the grid,  click on View , SQL view,
> paste in the following:
>
> SELECT Table1.suburb, Count(*) AS num_suburbs
> FROM Table1
> GROUP BY Table1.suburb
> ORDER BY Count(*) DESC;
>
> Run and the output is attached as well as screen grabs of the table and
> the query grid in design view.
>
> Desc stands for descending, so order by most numerous to least numerous.
> Hope this helps
>
>
> Kevork Krozian
> Mailing List Creator and Administrator
> kevork at edulists.com.au
> www.edulists.com.au <http://www.edulists.com.au/>
> Tel: 0419 356 034
>
>         ----- Original Message -----
>         From: Jones, Mark A <mailto:jones.mark.a at edumail.vic.gov.au>
>         To: itapps at edulists.com.au
>         Sent: Tuesday, March 13, 2007 2:14 PM
>         Subject: [Year 12 IT Apps] Access question
>
>         Dear all
>
>         I'm looking for a function (for a query or report) that will
> search a list of names then provide the name of the most numerous one. Any
> ideas would be appreciated.
>
>         regards
>         Mark Jones
>         Cann River P-12 College
>
>
>
>         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.
>
>         _______________________________________________
>         http://www.edulists.com.au - FAQ, resources, subscribe,
> unsubscribe
>         IT Applications Mailing List kindly supported by
>         http://www.vcaa.vic.edu.au - Victorian Curriculum and Assessment
> Authority and
>         http://www.vitta.org.au - VITTA Victorian Information Technology
> Teachers Association Inc
>
> _______________________________________________
> 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 <http://www.vcaa.vic.edu.au/> - Victorian
> Curriculum and Assessment Authority and
> http://www.vitta.org.au <http://www.vitta.org.au/> - VITTA Victorian
> Information Technology Teachers Association Inc
> _______________________________________________
> http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
> IT Applications Mailing List kindly supported by
> http://www.vcaa.vic.edu.au - Victorian Curriculum and Assessment Authority
> and
> http://www.vitta.org.au  - VITTA Victorian Information Technology Teachers
> Association Inc
>



-- 
Roland Gesthuizen - ICT Coordinator - Westall Secondary College
http://www.westallsc.vic.edu.au

"Never doubt that a small group of thoughtful, committed citizens can change
the world; indeed it is the only thing that ever has." --Margaret Mead
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20070316/3eaf72bf/attachment.html