Access: 2. Working with tables (queries and filters)

Description

Retrieving data? It’s simple with our 'Access Queries' training course!

There is no better program than Access for structured storage of data. But if you don't know how to retrieve specific information, then it's not going to be of much help. For this reason Xylos developed the 'Access Queries' training course to teach you how to quickly retrieve all the desired information.

Would you like to get the most out of your databases? And become a master at working with queries? Enrol now for our Access training course. And search through tables with a flick of your wrist and a click of your mouse. In our other Access training courses, you can learn how to design databases (module 1) and make reports and forms (module 3).

Objectives

What will you get from our 'Access: Queries’ training course?

Do you want ready-to-use information from your Access databases? Then our 'Access: Queries' training course would be an excellent choice. After completing the course you are able to:

  • Filter tables
  • Use the different query types
  • Combine queries with each other

Target Group

Anyone who wants to – or needs to – retrieve data from an existing database.

Prerequisites

You have already followed Module 1 ‘Access: Creating Databases’. Or you are familiar with the Windows environment and have a basic knowledge of databases (such as tables and primary keys, relationships and relationship types).

Attention: this Access training course only discusses the default databases, not the web databases, as these have limited functionality.

Content

Performing simple searches in a table

  • Use of Search
  • Making use of the autofilter

Simple selection queries

  • Adding tables to a query
  • Adding/deleting/moving fields in a query
  • Influence of relationships on queries
  • Influence of multi-value look-up fields in a query
  • Sorting in a query
  • Adding simple criteria to a query (And, Or, In, Between, Null,)
  • The use of Wildcards

More complex selection queries

  • Parameter queries
  • Grouping queries
  • Cross tables
  • Calculations in queries
  • The use of in-built functions
  • Join types (inner join, left join, right join)
  • Union queries

Action queries

  • Update queries
  • Append queries
  • Delete queries
  • Make-table queries

Request an offer







Share this course on Facebook, Twitter, LinkedIn or e-mail

Offer in-company training

Would you like to organize this training course for your employees? With this content or with adapted content? We transform your requirements into the perfect solution.

Request