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

  • Course types: Calendar course / In company
  • Version: Office 2010/2013/2016
  • Takes place in: Antwerp, Brussels
  • Duration: 1 day
  • Price: € 365 VAT excl. / Cheaper course?

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).

Choose a date and location

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

Choose a date and location

  • Dates
  • Days
  • Timing
  • Language
  • Location
  • Planning
  •  

Request an offer



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

Practical info

The practical info and applicable cancellation conditions related to this training course.

 

Choose a date and location

€ 365 VAT excl.
Cheaper course?

Requesting a quotation

Would you like to organize this training course for your employees? At your offices or at a Xylos training centre? We transform your requirements into the perfect solution.

Request

Discount

SEVERAL PARTICIPANTS
If you enrol several employees for the same course on the same date, you will get a discount:

  • 2 employees: 15% discount on the 2nd subscription
  • 3 or more employees: 15% discount on the 2nd subscription and 40% on further participants

Questions?

Contact Inès Vansteenkiste

+32 2 264 13 20
xylos@xylos.com