Microsoft Access  - QueriesDownload Course Outline

This is the outline of our Microsoft Access Queries course - Duration: 1 day

If you want to use Microsoft Access as your database query tool, linking into external databases and extracting data to analyse, this is the course for you.

You don’t need any previous experience of using Microsoft Access or database manipulation but you should be reasonably confident in general computer use.

We specialise on on-site training and can come to you to run our course either on your PC's or provide our own high specification equipment. If you want specific training for your staff, we're happy to customise this course to your requirements, adding or removing topics as necessary.

Microsoft Access  - Queries course content

Download a PDF course outline using the link on the right.

Relational Database Concepts

  • Explain the use of table relationships correctly.

ODBC Connections

  • Identify and connect to an ODBC data source.
  • The use of pass-through queries to send commands directly to an ODBC database server.

Constructing Criteria

  • Find records in tables based on single criteria.
  • Find records in tables based on multiple criteria.
  • Find records where you enter the criteria when you run the query.
  • Use Queries to find data across linked tables.

Constructing Expressions

  • Create calculated expressions in queries.
  • Use queries to find totals, averages and how many.
  • Use the Where expression.
  • Construct the IIF function correctly to return values into a query based on the result of a test.
  • Use other functions in a query.

Changing Join Types

  • Explain the correct use of an Equi-Join.
  • Explain the correct use of Inner Joins.
  • Change the join type to find where there are no related records.

Crosstab Queries

  • Use the Crosstab query to analyse totals.

Action Queries

  • Delete all or specific records from tables.
  • Update all or specific record from tables.
  • Use queries to create new tables of data.
  • Append all or specific records from one table to another.

Using Sub-Queries and Nested Queries

  • Design nested queries.
  • Design a sub-query to construct more complex criteria.

Using Structured Query Language (SQL)

  • Use the SQL view to edit queries.
  • Use the SQL view to create Union Queries 

We can customise any element of this course to fit your training requirements.