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. 

Course, tutorial Summary Access 2013: Intermediate to advanced queries

Course material to download for free on Access 2013: Intermediate to advanced queries category Database.
This course is intended for a strictly personal use, the file is of format pdf level Intermediate , the size of this file is 590.82 KB.

The site also offers courses in MS Access, SQL language, MySQL, Oracle, PostgreSQL, SQL server, SQL DBMS, NoSQL, NewSQL, SQLite,Design and modeling, Administration, Backup and Restore and many other tutorials. You have to come and see our Database. You will find your happiness without problem!

Download the file

List of similare courses

Access 2013: Intermediate to advanced queries

This document takes you through some intermediate to advanced queries. The assumption is that you are able to build simple one and multi-table queries using wildcards, and simple operators, such as equals, greater than and so on. - type of file pdf and size 590.35 KB, tutorial for level Intermediate .


Access 2013: Reports and Queries

This document has been developed to help you learn more about several useful features in Access including printing, applying queries, and importing Excel files. - type of file pdf and size 1.22 MB, tutorial for level Intermediate .


Access 2016 - Reports & Queries

Download free Microsoft Access 2016 - Reports & Queries, course tutorial, training, PDF file made by Kennesaw State University. - type of file pdf and size 1.28 MB, tutorial for level Advanced .


Creating Queries and Reports (Access)

Download free Access 2010: Creating Queries and Reports course material and training, PDF file on 69 pages. - type of file pdf and size 1.19 MB, tutorial for level Advanced .


Access Queries (Office 2010)

Download free Access Queries (Office 2010) course material and training tutorial, PDF file on 25 pages. - type of file pdf and size 342.23 KB, tutorial for level Advanced .


Access: using operators and functions in queries

This document aims to cover all the query language elements (expressions, functions etc) that are available for you to use in your queries, and on your forms and reports. - type of file pdf and size 100.38 KB, tutorial for level Advanced .


More downloads

Partner sites PDF Tutorials (English) | PDF Manuales (Spanish) | Cours PDF (French)