Explore Our Courses

SQL in Microsoft Access

 14 Hours
This SQL training course is for people who want to gain the necessary skills to extract and analyse data using Microsoft Access. Course members will learn:
  • how to write SQL queries
  • what relational databases are and how we can use them
  • what are relations and how to create them
  • the structure of data
  • differences between SQL dialects (Oracle, T-SQL, ANSI)
  • practical skills for writing queries
This SQL course deals with Microsoft Access dialect of SQL.
Read more...

VBA For Access & Excel

 21 Hours
The objective of the course is to enable participants to gain a mastery of the fundamentals and usages of VBA for Access & Excel.
Read more...

Access Intermediate

 14 Hours
The course participants will learn the terminology of relational databases, acquire the skills to design database applications, know the basic principles of creating forms and reports.
Read more...

Access VBA

 21 Hours
The training discusses issues related to programming in Visual Basic for Applications and presents ways of accessing data using VBA. The training participants also learn the mechanisms that allow them to write a professional database application.
Read more...

Access Advanced

 21 Hours
The course participants will learn how to speed up the operation of the database, how to write advanced queries, create a convenient system of forms and reporting. The course introduces the participant to automate all operations using macros and VBA.
Read more...

Microsoft Access – Downloading Data

 14 Hours
This instructor-led, live training in Hong Kong (online or onsite) is aimed at beginner-level to intermediate-level professionals who wish to enhance their skills in extracting, analyzing, and manipulating data within Microsoft Access using queries and SQL.By the end of this training, participants will be able to:
  • Understand different types of queries in Microsoft Access.
  • Use query design tools to extract and analyze data effectively.
  • Write SQL queries to retrieve and manipulate data.
  • Perform data aggregation, filtering, and sorting using queries.
  • Apply advanced query techniques for troubleshooting and optimization.
Read more...

Access - podstawy

 14 Hours
The Microsoft Access course is an intensive learning of using the database engine, focusing on practical skills. Master table design, creating queries, relationships between them, and effective collaboration with Excel. The course also covers creating forms, reports and automating work using macros.
Read more...

Access - Data Base Designing

 21 Hours
The course participants will learn how to design a database and how to adapt it to work with the end user.
Read more...

Last Updated:

Testimonials (5)

The trainings by our self

Andreas - Diehl

Course - Access Advanced

Our group was not that big so every time we asked a question we received an extensive answer with examples. So everything was well explained and it can be noticed that trainer has a great knowledge.

Iwona - Universal-Investment-Gesellschaft mit beschrankter Haftung

Course - Access Intermediate

Training Room and quite location and all the stuff.

Abdullah Adelyar - USAID - Kabul Afghanistan

Course - Access VBA

The training started for the early beginners, so everybody could get to know what all is about.

Amanda Dzida

Course - Access - podstawy

I liked the examples and the way he explained.

Sandeep Parashar

Course - VBA For Access & Excel

Provisional Upcoming Courses (Require 5+ participants)

Microsoft Access – Downloading Data

2025-05-12 09:30
14 hours
Online
HK$ 25100 (Online)

Access VBA

2025-05-26 09:30
21 hours
Online
HK$ 37650 (Online)

Access VBA

2025-06-09 09:30
21 hours
Online
HK$ 37650 (Online)

Access Intermediate

2025-06-23 09:30
14 hours
Online
HK$ 25100 (Online)

VBA For Access & Excel

2025-07-07 09:30
21 hours
Online
HK$ 37650 (Online)

Access Advanced

2025-07-21 09:30
21 hours
Online
HK$ 37650 (Online)

Other regions in Hong Kong

Other Countries

These courses are also available in other countries
Online Microsoft Access training, Online Ms Access training courses, Online Weekend Access courses, Online Evening Ms Access training, Online Microsoft Access instructor-led, Online Microsoft Access private courses, Online Ms Access training, Online Microsoft Access boot camp, Online Microsoft Access classes, Online Weekend Microsoft Access training, Online Evening Access courses, Online Access on-site, Online Access instructor, Online Access trainer, Online Ms Access one on one training, Online Access instructor-led, Online Ms Access coaching