This instructor-led course looks at the critical aspects of application development using Microsoft Access. You'll dig deep into forms, tables, queries, and reports, and explore modules as you learn to use Visual Basic for Applications (VBA). You'll learn how to programmatically display and manipulate data on forms and reports.
What is Access VBA
VBA stands for Visual Basic for Applications. Visual Basic is, by far, the most widely used programming language in the world. It has been estimated that Visual Basic programmers outnumber every other programmer added together!
VBA is no different from regular Visual Basic except that it can only be used to add features to Microsoft Office applications (such as Access, Excel, PowerPoint, Word, Project and Visio) rather than to write free-standing applications.
To get the most out of Programming in Microsoft Access, you should understand how to create and use all the interactive Access objects: Tables, queries, forms, and reports. You should have taken Access Level 1, Level 2 and Level 3 or the associated knowledge. Programming experience in any language is helpful, but not required. Access Level 1: Introduction to Microsoft Access Access Level 2: Intermediate Topics Access Level 3: Advanced Topics.
Much of what you learn in our VBA course will also be relevant to writing custom VBA extensions to other office applications too.
If you are an Expert-level Access user and still can't make Access do what you need then this course is definitely for you.
If you want to develop robust, professional and polished Access applications for re-sale this course will show you how.
Prerequisites
Must have Expert Access skills.
Appropriate introductory and advanced courses plus several weeks of practice. No programming experience is required.
*Course cost listed does not include the cost of courseware ($46.49). Course is subject to a minimum enrollment to run the class. Please contact us at learn@vtec.org or 207-775-0244 for additional pricing information, or if you have any questions.