Access Programming in VBA
9/21/2020 - 9/23/2020COURSE LENGTH:
9:00am - 4:30pm
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
AUDIENCE AND PREREQUISITES
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 2010 Level 1: Introduction to Microsoft Access Access 2010 Level 2: Intermediate Topics Access 2010 Level 3: Advanced Topics.
PREREQUISITE COURSESFOLLOW UP COURSES
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.
Must have Expert Access skills.
*Course cost listed does not include the cost of courseware (required) or lunch (optional). Please contact us at firstname.lastname@example.org or 207-775-0244 for additional pricing information, or if you have any questions.
Course subject to minimum enrollment.
Advantages of Access and VBA Understanding Where Access fits in Office Understanding Access Programming Choices Macros Using SQL Using VBAUsing the Visual Basic Editor First Look at the Visual Basic Editor Explaining VBA Modules Entering and Running Code, Debugging Code, Saving Code Getting Help on Code, Coding Shortcuts Good Coding habits Using a naming Convention Indenting DocumentingUsing Variables, Constants, and Data Types Declaring Variables and Constants VBA Data Types Referencing Syntax Case Study: Using Form ReferencesUsing Built-In Functions What Are Functions? Converting Data Types Working with Date Functions Using Mathematical Functions Using Financial Functions Manipulating Text String Formating Values Domain Aggregate Functions Using the Is Fnctions Interation Case Study: Add Work DaysBuilding Procedures Types of Procedures Passing Arguments Error HandlingConditional and Looping Statements Introduction Flow of control Statements Using If ... Then...Else Using Select Case Using For...Net Using Do Loops Using GoTo Case Study: Calculating BonusesWorking with Arrays Introduction Arrays Declaring a Fixed-Size Array Understanding an Array's Indexx Working with Array Elements Arrays with Multiple Dimensions Expanding to Dynamic ArraysObject and event-Driven Coding Understanding Objects Invoking Methods Using Collections Working with an Object Model Creating Objects Working with EventsUnderstanding Scope and Lifetime Scope Explained Procedure-Level Variables Module-Level Variables and Constants Public Variables and Constants Measuring the Lifetime of a Variable or Constant Using Static Variables Case Study: Tracking the Current UserWorking with Forms Opening and Closing Forms The Form Module Form and Control Properties Form Events Case Study: Adding to a Combo BoxMore on Event-Driven Coding Responding to Events The Event Sequence for Controls Focus Evetns, Data Events, Control Specific Events The Event Sequence for Forms Navigation Events Canceling Events Case Study: Validating DataWorking with Selection Controls Selection Controls Populating a List Control Adding to the List - Or Not Updating a Table/Quer List Working with Option Groups Working with MultiSelect Controls Case Study: Selecting Multiple ItemsWorking with Other Controls Working with Text Boxes Key Properties of Text Boxes Tracking the Focus Working with Check Boxes, Radio Buttons, or Toggle Buttons Working with Subforms Working with the Tag Property Case Study: An Audit TrailWorking with Reports An Introduction to the Report Module and Events Opening and Closing Reports Passing Argument Using OpenArgs Populating the Report Handling Report -Level Errors Working with Subreports Case-Study: Product Catalog