<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.emailstyle17
{mso-style-name:emailstyle17;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Arial","sans-serif";
color:navy;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:595.3pt 841.9pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
/* List Definitions */
@list l0
{mso-list-id:699159710;
mso-list-template-ids:-171793270;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-AU link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";
color:black'>Can anyone help me with functions to do the following?</span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>Create
the following calculated queries in ACCESS:</span><o:p></o:p></p>
<ul type=disc>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l0 level1 lfo1'><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>Total
Cost$ - The total cost of the booking, including the booking fee<o:p></o:p></span></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l0 level1 lfo1'><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>Disc$
- The total discount amount off the Total Cost$<o:p></o:p></span></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l0 level1 lfo1'><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>Actual
Cost$ - the final cost deducting any discount amount<o:p></o:p></span></li>
</ul>
<p class=MsoNormal><span style='color:#1F497D'>Peter Dall<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>
<p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:
"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'> yr11it-bounces@edulists.com.au
[mailto:yr11it-bounces@edulists.com.au] <b>On Behalf Of </b>PIKE Philip<br>
<b>Sent:</b> Tuesday, 2 March 2010 3:55 PM<br>
<b>To:</b> Year 11 Information Technology Teachers' Mailing List<br>
<b>Subject:</b> RE: [Yr11 Information Technology] System Architecture
presentation<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>Thanks Adrian, A very good resource for SD<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'><o:p> </o:p></span></p>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>Philip Pike</span><span style='color:navy'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>Director of ICT</span><span style='color:navy'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>Bacchus Marsh Grammar</span><span style='color:navy'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>Sth Maddingley Rd</span><span style='color:navy'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>Bacchus Marsh 3340</span><span style='color:navy'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>Ph 53664800 Ext 849</span><span style='color:navy'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>Fax 53664850</span><span style='color:navy'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>email: pikep@bmg.vic.edu.au</span><o:p></o:p></p>
</div>
<div>
<div class=MsoNormal align=center style='text-align:center'><span lang=EN-US
style='font-size:12.0pt;font-family:"Times New Roman","serif"'>
<hr size=2 width="100%" align=center>
</span></div>
<p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:
"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'> yr11it-bounces@edulists.com.au
[mailto:yr11it-bounces@edulists.com.au] <b>On Behalf Of </b>Kent Beveridge<br>
<b>Sent:</b> Tuesday, 2 March 2010 4:05 PM<br>
<b>To:</b> Year 11 Information Technology Teachers' Mailing List<br>
<b>Subject:</b> RE: [Yr11 Information Technology] System Architecture
presentation</span><span lang=EN-US style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p></o:p></span></p>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";
color:black'>Hi AJ,<o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";
color:black'>just had a quick look at the presentation ..<o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";
color:black'>very nice!<o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";
color:black'>Kent.<o:p></o:p></span></p>
</div>
<div>
<div class=MsoNormal align=center style='text-align:center'><span
style='font-size:12.0pt;font-family:"Times New Roman","serif";color:black'>
<hr size=2 width="100%" align=center>
</span></div>
<div id=divRpF14713>
<p class=MsoNormal style='margin-bottom:12.0pt'><b><span style='font-size:10.0pt;
font-family:"Tahoma","sans-serif";color:black'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:black'>
yr11it-bounces@edulists.com.au [yr11it-bounces@edulists.com.au] on behalf of
Adrian Janson [janson.adrian.a@edumail.vic.gov.au]<br>
<b>Sent:</b> Tuesday, 2 March 2010 2:45 PM<br>
<b>To:</b> sofdev@edulists.com.au; yr11it@edulists.com.au<br>
<b>Subject:</b> [Yr11 Information Technology] System Architecture presentation</span><span
style='font-size:12.0pt;font-family:"Times New Roman","serif";color:black'><o:p></o:p></span></p>
</div>
<div>
<div>
<p class=MsoNormal><span style='color:black'>Hi everyone,<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:black'> <o:p></o:p></span></p>
<p class=MsoNormal><span style='color:black'>I have just uploaded a
presentation on System Architecture to my site here:<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:black'><a
href="http://www.adrianjanson.com.au/index.php?option=com_docman&task=doc_download&gid=75&Itemid=4"
target="_blank">http://www.adrianjanson.com.au/index.php?option=com_docman&task=doc_download&gid=75&Itemid=4</a><o:p></o:p></span></p>
<p class=MsoNormal><span style='color:black'> <o:p></o:p></span></p>
<p class=MsoNormal><span style='color:black'>The presentation discusses
motherboards, architecture, memory and ports.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:black'> <o:p></o:p></span></p>
<p class=MsoNormal><span style='color:black'>Cheers,<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:black'>Adrian <o:p></o:p></span></p>
<p class=MsoNormal><span style='color:black'> <o:p></o:p></span></p>
<p class=MsoNormal><span style='color:black'>Adrian Janson<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:black'>VITTA President<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:black'>Director of ICT, Melbourne High
School<o:p></o:p></span></p>
</div>
<p><b><span style='color:black'>Important - </span></b><span style='color:black'>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.<o:p></o:p></span></p>
<p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-size:12.0pt;
font-family:"Times New Roman","serif";color:black'>_______________________________________________
<br>
<a href="http://www.edulists.com.au" target="_blank">http://www.edulists.com.au
</a>- FAQ, resources, subscribe, unsubscribe <br>
Year 11 IT Mailing List kindly supported by <br>
<a href="http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html%20"
target="_blank">http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html
</a>- Victorian Curriculum and Assessment Authority and <br>
<a href="http://www.vitta.org.au" target="_blank">http://www.vitta.org.au</a> -
VITTA Victorian Information Technology Teachers Association Inc<span
style='background:white'><o:p></o:p></span></span></p>
<p align=center style='text-align:center'><span style='color:black;background:
white'>Click <a href="https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg=="
target="_blank">here</a> to report this email as spam.<o:p></o:p></span></p>
</div>
</div>
</div>
<p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-size:12.0pt;
font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<p align=center style='text-align:center'><span style='background:white'>This
message has been scanned for malware by Websense. </span><a
href="http://www.websense.com/"><span style='color:black;background:white'>www.websense.com</span></a><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'>_______________________________________________
<br>
<a href="http://www.edulists.com.au">http://www.edulists.com.au </a>- FAQ,
resources, subscribe, unsubscribe <br>
Year 11 IT Mailing List kindly supported by <br>
<a href="http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html%20">http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html
</a>- Victorian Curriculum and Assessment Authority and <br>
<a href="http://www.vitta.org.au">http://www.vitta.org.au</a> - VITTA Victorian
Information Technology Teachers Association Inc<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'>_______________________________________________
<br>
<a href="http://www.edulists.com.au">http://www.edulists.com.au </a>- FAQ, resources,
subscribe, unsubscribe <br>
Year 11 IT Mailing List kindly supported by <br>
<a href="http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html%20">http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html
</a>- Victorian Curriculum and Assessment Authority and <br>
<a href="http://www.vitta.org.au">http://www.vitta.org.au</a> - VITTA Victorian
Information Technology Teachers Association Inc<o:p></o:p></span></p>
</div>
</body>
</html>