Access 2013: Intermediate to advanced queries in pdf

Aims and Learning Objectives

This document shows you how to do things with queries that take you slightly ‘beyond the norm’. It is not supposed to be exhaustive – no Access query workbook ever could be – but it shows you some of the less-trodden paths. The intention is to give you some hints and tips as to what can be done with queries so as to make you experiment further on your own. The core learning objectives for this course are to:

• explain what you can do with Access queries beyond viewing subsets of data; 
• create queries using a range of operators, functions and expressions; 
• create a query to calculate totals; 
• customise a crosstab query in the Query Design window;
• use different table joins to alter query results; 
• create queries to sort data into ranges (e.g. age: 1 – 10, age: 11 – 20 and so on); 
• join two sets of query results together using SQL.