Kolonnawa Classroom

B87, Kolonnawa, Colombo, Sri Lanka, Colombo, sri lanka, 10600

The Centre located in Colombo, within 2.1 km of R Premadasa Stadium and 5 km of Khan Clock Tower. Please contact us by e-mail or phone at least one day earlier to make an appointment with one of our consultants at our corporate offices.

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 Kolonnawa (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

Upcoming Courses

Access - podstawy

2025-06-16 09:30
14 hours
Kolonnawa Classroom
168661 LKR (Online)
188661 LKR (Classroom)

Access VBA

2025-06-30 09:30
21 hours
Kolonnawa Classroom
252991 LKR (Online)
282991 LKR (Classroom)

Access - podstawy

2025-07-14 09:30
14 hours
Kolonnawa Classroom
168661 LKR (Online)
188661 LKR (Classroom)

Access Intermediate

2025-07-28 09:30
14 hours
Kolonnawa Classroom
168661 LKR (Online)
188661 LKR (Classroom)

Access Intermediate

2025-08-11 09:30
14 hours
Kolonnawa Classroom
168661 LKR (Online)
188661 LKR (Classroom)

Other regions in Sri Lanka

Other Countries

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