Access: 4. Advanced - Complex queries and macros

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

Description

Challenge yourself to become an Access expert

If you have already acquainted yourself with Access by following the three previous modules offered by Xylos, then sign up for this fourth Access advanced module and further optimize your knowledge.

Can you gather information from tables, optimize your database and automate reports and forms in Access using macros? From now on you will be able to do all this with your hands tied behind your back. In short, join the course ‘Access Advanced: complex queries and macros' and challenge yourself to become an Access expert!

Choose a date and location

Objectives

What will you learn in the advanced course Access?

Our advanced course Access builds on the three basic Xylos Access courses.

Why should you not miss the fourth course? Because you will learn to create more complex queries, and optimize your Access knowledge of tables, queries and macros.

Target Group

Knowledge workers who use databases in Access on a daily basis and already create their own queries, forms and reports.

Prerequisites

Participants of this course must have completed the basic Access courses. Specifically module 1. Creating databases, Module 2. Queries and Module 3. Reports and forms.

Content

Queries

  • Recap query types (parameter queries, group queries, cross tables, calculations in queries, action queries)
  • Frequently used functions in queries
  • Join types (inner join, left join, right join)
  • Union queries
  • Queries in queries
  • Do’s and don’ts in queries
  • Optimizing queries

Macros

  • What are macros
  • 'Safe' and 'unsafe' macros
  • Standalone and embedded macros
  • Macro actions
  • Temp Vars

Database management

  • Compressing a database
  • Splitting a database into a front end and back end
  • Setting up the boot properties

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