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.
Upon successful completion of this course, students will have proficient knowledge of Php And MySQL. Our PHP And MySQL certification training online can be done live, online or in class.
WordPress Custom Themes Training is a practical course delivered in the style of a workshop. The web design training course teaches candidates how to customise and integrate their own design ideas using WordPress.
Our Adobe certified training team will take you through the journey of understanding the Animate environment, through to using basic animation, layer control, effects and more. You’ll leave the course with the experience and know-how to create professional looking animations for different intents...
The use of Visual Basic in Excel unlocks the true power of this application. Create powerful yet user friendly applications that will be capable of running critical business processes.
If you are a looking to expand your skills to create great looking websites or blogs we have the WordPress course to suit you!
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy