Choose Access VBA when simple tables, forms, or reports just won't do. ..
When Macros aren't quite enough. ..
And when creating your own applications from scratch is overkill. ..
Are you experienced with Access, but not with VBA programming?
This course introduces VBA programming concepts with easy to follow examples, and lessons.
First, you will learn the difference between Macros and VBA, and create a simple Macro.
Then you will get familiar with the Visual Basic Editor, your home for programming Access, and basic concepts of Visual Basic for Applications.
During this course you will learn VBA concepts that you can apply to your job, and add functionality to your Access databases:
What to know before you enroll:
You will have unlimited, lifetime access to the course!
You will have instant, and free access to any updates I add to the course.
Don't forget, you are covered by a 30 day money back guarantee.
Get started programming VBA for your Access databases today.
When programming your Access databases, you have a choice of Macros, or VBA.
Which should you choose?
Learn the difference with this lecture.
Learn how to create a simple macro in your Access database.
There are multiple ways to access the Visual Basic Editor.
Take a few seconds to learn them now.
Get familiar with the different windows that you will be using when programming your Excel VBA code.
You will see Option Compare Database, and Option Explicit a lot throughout this course, but what do they mean?
You will need to create your own code modules, and it is as easy as a couple of mouse clicks. Learn how to here.
Keep your code modules organized by naming any module that you create.
To be comfortable writing VBA, you need to be comfortable in the VBE.
Learn how to customize the VBE to meet your needs.
Browse through your project's available objects, and see their properties, methods, and events.
Learn how you can password protect your VBA code modules.
When programming VBA, knowing a few time savers can go a long way.
If you get an error while programming your VBA that stops your code from running, don't stress.
Reset your code, and edit your code if you can.
Key Points for the Section: Getting Familiar with the VBE (Visual Basic Environment)
Get a brief overview of OOP, and how it plays a major role in this VBA programming course.
Learn how VBA accesses an object's properties, and methods.
Procedures are the container that you will be storing your code in.
A quick lecture on how to structure your sub procedures.
Learn how the structure of a function differs from the structure of a sub procedure.
Being able to use procedures throughout your module has many benefits.
Learn how to call your procedures in your VBA code.
How do you call one procedure with the same name as another?
A click of a mouse, or the loading of a form, these are both events that can trigger your code to run.
In this lecture, learn about, and how to create, event procedures.
Collections are a group of similar object.
Using collections can save you time when programming in VBA.
You can use comments to make notes in your code. It is very helpful, and highly recommended.
Key Points for the Section: Object Oriented Programming
An introduction to topics covered in this section
Declaring a variable lets VBA know that you want to store a value in the computer's memory.
Data types are a key component to programming. In this lecture find out why.
A list of VBA's built-in data types.
You can also declare variable's data types with Identifier Type Characters
Learn how to speed up the programming of your code by using Me.
Constants are placeholders for information that do not change through the life of your code.
Learn how Object Variables can save you time when writing your VBA.
An exercise in using arithetic operators.
You type a number in a text box, but is it really seen as a numeric value?
Bring multiple strings together with String Contatenation
An exercise on string concatenation.
When you want to wrap your VBA code around to multiple lines, use the Line Continuation Operator
Learn how to use the Colon operator in VBA
Use the Carriage Return Line Feed to display strings on multiple lines.
Using the With statement is a real time saver, find out why.
Setting the scope of your variables determines where those variables can be used.
An explanation of Arrays used in VBA
Test the skills you learned in this section with this exercise.
Key Points for the Sections: The Essentials to Programming in VBA
An introduction to this section.
Learn to extract data with the Left, Right, and Mid functions.
Change the case of your strings with UCase, and LCase
Locate characters in a string with the InStr function.
The simple Date, and Now functions can be used as time stamps in your databases.
Learn how to extract the Day, Month, and Year from a date parameter.
Calculate the difference between two dates.
Learn the simple function to display the time of day.
Learn how to extract the second, minute, and hour, from a time parameter.
Learn how to format your numbers with these common functions.
Learn to create your own custom number formatting.
Learn how to create custom date and time formats.
Learn how to create custom string formats.
Learn how to use the FormatCurrency function.
Learn how to use the FormatNumber function.
Learn how to use the FormatDateTime function.
Learn how to use the FormatPercent function.
Test the skills you have learn in the Formatting section, and apply them to this exercise.
An overview of Object events
Learn about using click events to trigger your code to run.
Learn about using focus events to trigger your code to run.
Learn about using mouse events to trigger your code to run.
Learn about using keyboard events to trigger your code to run.
Learn about using text box events to trigger your code to run.
Combo box Events
Learn about using form events to trigger your code to run.
Learn about using report events to trigger your code to run.
Test the skill you learned in this section to complete the exercise in this lecture.
Learn how much easier the DoCmd object will make your programming.
Learn how to filter records with the ApplyFilter method.
Learn how to copy objects in your database with the CopyObject method.
Learn how to quickly open forms with the OpenForm method.
Learn how to quickly open reports with the OpenReport method.
Learn how to quickly open tables with the OpenTable method.
Learn how to turn objects into PDFs or other formats with the OutputTo method.
Learn how to access menu commands with the RunCommand option.
An exercise on using a DoCmd method to create an Outlook contact.
Learn how to run SQL in your VBA code with the RunSQL method.
Learn how to e-mail objects with the SendObject method.
Learn to use the TransferDatabase method.
Use TransferSpreadsheet to import, export, or link Excel worksheets to Access.
Key points for the Introductions to DoCmd Methods section.
Learn how to branch your VBA code, by using If... then...else
An exercise using If Then Else
The Select Case statement is another way to branch your VBA code.
An exercise using Select Case.
Test your If..Then skills with this exercise.
Test your Select Case skills with this exercise.
Key Points for the Section: Decisions Structures
How are you enjoying the course so far?
Learn the syntax for creating message boxes in VBA.
Learn the syntax for creating Input Boxes in VBA
An exercise using input boxes and message boxes.
Key Points for the Section: Creating User Interactions with Message Boxes & Input Boxes
Inspiring and Empowering People to Achieve Their Goals through Learning.
Sharing the strategies, and tips you need to regain control at work, and optimize productivity.
IsaBel has been serving students since 1999. Successfully self-employed, she is a trusted consultant for businesses large and small. She is a publisher, and author of several highly-rated eBooks.
IsaBel has been certified many times over as a Database Administrator, IT Professional, Developer, Network Administrator, and even Certified Ethical Hacker. Even with a technical background, she is a down to earth half-marathoner, who enjoys her family, good food, and sports.
IsaBel grew up around teachers, so education was always important to her.
All her life she has seen how gaining even a little more knowledge can make such a big difference in everything from the way you speak, to the way you cook, the way you parent, to the way you fix a leaky faucet, the speed in which you perfect your spreadsheets, to the upgrade your resume can get by learning SQL.
She was taught the importance of always learning, and works hard daily to help others, like you, meet your goals.
Enroll Now, because Change Matters, Growth Matters.