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.
Adobe Dreamweaver is the industry leading web design and HTML editor software. Learn at our London studios or live online from home. First-time Dreamweaver users may feel intimidated by the plethora of menus and property panels,
WordPress is a web-based free to use by anyone to build a website. It is easy to customise and along with the many plugins and themes makes it extremely easy to use.
If you are a looking to expand your skills to create great looking websites or blogs we have the WordPress course to suit you!
Full Stack developing is a business where the developer works with both Front End or the Client Side of the applications, as well as the Back End or the Server Side of the application. Design and development of a software, debugging, writing clean code
This course explains how to use React to create front-end applications. After completing our React training course you will be able to create React based web user interfaces.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy