The course provides an introduction to programming in MS Access using Visual Basic for Applications (VBA). Students learn language syntax, discover how to automate tasks in Access, create custom functions and perform activities not easily available in any other way from Access.
The course provides an introduction to programming in MS Access using Visual Basic for Applications (VBA). Students learn language syntax, discover how to automate tasks in Access, create custom functions and perform activities not easily available in any other way from Access.
Agenda
Introducing MS Access – Quick review of the basics
How it all works? Forms, Tables, Queries, Reports.
Working with macros.
Recording a macro.
Running a macro.
Understanding events and event handlers.
Introducing Visual Basic for Applications (VBA).
Data types. Variables. Operators.
Flow-control instructions. Conditional instructions. Loop instructions.
Procedures and Functions.
Introduction to object-oriented programming.
Classes.
Objects.
Attributes, Methods, Events.
Data manipulations in VBA.
Creating queries.
Transactions.
Importing data from various sources.
Error handling. Good practices.
Audience And Prerequisites
The course is intended for experienced Access users who feel that standard functions and features of program are insufficient for their needs.
Before attending this course, students must have:
An intermediate level of experience in using Microsoft Access 2007.
Basic knowledge of SQL language is useful, but not necessary.
No prior programming experience is necessary.
Certificates
Course participants receive completion certificates signed by ALX.
We offer IT training courses in: operating systems (among others, Linux), programming languages, modelling and analysis tools, databases (for programmers and analysts), computer networks and safety, and office software.
Our company has been founded in 2002. Through high-quality trainings and ever-increasing offer we gained trust of numerous companies; we enjoy long-term, stable business relationships with many of our Clients.
We are experienced both in conducting single trainings and in longer courses. We have also conducted numerous on-site trainings - including many that were custom-made to fit our customer's particular needs - for a large number of companies dealing in various trades.
Authorizations And certifications
We are an authorized Linux Professional Institute (LPI) partner. We are an authorized Microsoft partners for Learning Solutions.
Among our staff are certified trainers such as:
MS Office, MS Project, project management:
Microsoft Certified Trainer (MCT), PRINCE2 Foundation
Linux:
Linux Proffessional Institute (LPIC),
Red Hat Certified Engineer (RHCE),
Novell Certified Linux Administrator (CLA)
Programming languages:
Sun Certified Java Programmer (SCJP),
Zend Certified Engineer (ZCE)
When we design our courses and training, we pay particular attention to actual business demands and needs and the situation in the job market.
Example:
The market needs reliable system administrators who have both the practical skills and the familiarity with theoretical fundamentals (such as: how does protocol X actually work? why does it work?).
We often saw that, in spite of the existence of many postgraduate courses, training and IT schools it is difficult to find a good Linux system administrator.
College graduates who majored in IT often have extensive knowledge - and problems with putting it into practice and dealing with the technical part of the job.
On the other hand, graduates of postgraduate schools or hurried preparatory courses often have incomplete, obsolete or otherwise inaccurate knowledge that is out of touch with the realities of IT professional's life.
During course design we are also using the experience we have gained as an employer. The knowledge our students acquire is the knowledge we ourselves would expect from job candidates.
Other Projects, Deployment, Consulting
ALX also offers: deployment of tailor-made IT systems (among others, CRM systems and document systems), consulting and system and network outsourcing.
This course covers the essentials of programming and coding side of web site production and design. It includes Hypertext Markup Language (HTML), Cascading Style Sheets (CSS), JavaScript, PHP, Drupal and MySQL.
React is a popular client-side development library from Facebook. React makes it easy to create reusable components and render them in a web page or in a native mobile application.
This introductory course is designed for those who wish to use Visual Basic and the .NET Framework to create applications and utilities.
Our web development short courses are designed for both beginners and more experienced learners. Whether you're about to take your first steps in the world of web design or just want to learn how to update a company website,
CCW Offer a variety of Web Development courses that cover everything that is required for new developers of websites and web services. With web services becoming essential for organisations of all kinds and varieties, there is high demand for these services.
© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy