|
|
|
Access
Developer
Level 2
Developer-Level
Microsoft Access Tutorial - 1 Hour, 22 Minutes |
|
|
|
Access
Developer 2 continues our focus on learning how to program the
Visual Basic for Applications programming language (VBA) in
Microsoft Access.
Topics include:
 |
-
Building a Calculator Form
- Basic Debug,
On Error Resume Next -
Creating Subs with Parameters
- Select Case
Statements - Creating Functions -
Returning Values from Functions - Comments, Line
Continuation - More MsgBox Options
- RunSQL, Insert Into -
Lots more |

Order Now |
If you would like a preview of what's covered in this class,
click here to watch the first
and last lessons of
this course (free of charge), or scroll down for more information.


|
Access Developer Level
2 |
Versions: |
This class was recorded with Microsoft
Access 2016. The material is valid for Access 2007 up to 2021. Access has not changed that much over the years. |
Pre-Requisites: |
Access
Developer Level 1 strongly recommended, as you should watch all of my
classes in order. However, if you're skipping around, you should
have at least completed the Beginner series and the first 3 or 4
levels of the Expert series where I start to cover functions. |
Running Time: |
1
Hour, 22 Minutes |
Cost: |
$39.99 |
|
|
This class continues our look at programming in Visual Basic for
Applications in Microsoft Access (VBA, or Access VB). We will
begin by building a calendar form to perform basic arithmetic. We will
learn about the VAL function, create buttons for the basic math
operations, learn how the debugger works, avoid errors
with the On Error Resume Next statement, talk more
about If Then Else blocks, and Exit Sub.

Next we will learn how to
create our own Private Subroutines, learn how
parameters to those subs work, learn about the Select Case
statement as an alternative to If Then blocks, talk about proper code
indentation, and more.

Next we will build a form
to track commissions for our sales reps. You will
select an employee from a combo box, his commission rate will be filled
in automatically, as will the sale date, you enter the sale amount,
click calculate commission, and the exact amount will
be calculated. Add optional notes. You will learn how to use the
DropDown method to automatically open a combo box. We will learn how to
create our own functions, return a value
from those functions, and more.

Finally, we will add a
button to automatically add the calculated commissions from the previous
lesson into a commission table. We will construct an SQL
statement and use the RunSQL command and
INSERT INTO to add that data to our table. We'll learn
about comments, the line continuation character, more about MsgBox,
vbInformation, and lots more.

This is the 2nd class in the Access Developer series. If you're
serious about building quality databases with Access, and you want to
learn how to automate your database with VBA Programming then don't miss out on
this course. Of
course, if you have any questions about whether or not this class is
for you, please contact me.

Complete Outline - Access
Developer Level
2
00. Intro (2:20)
01. Calculator 1 (20:05)
Naming Buttons String Concatenation VAL() Function
Change Button Name, Edit Code Add, Subtract Buttons
Multiply, Divide Buttons Square Root, Exponents Nth Root
Debugger Divide by Zero Error On Error Resume Next If
Then Else Exit Sub
02. Calculator 2 (12:59)
Create Private Sub Parameters to a Sub Right Click >
Definition for Sub Select Case Statement End Select
Proper Indenting Tab / Shift Tab Multiple Lines |
03. Commission Form 1 (27:00)
Sales Rep Combo Box
Commission Rate in Columns
AfterUpdate Event to Copy Rate
Docmd.GoToControl
Combo.DropDown
Calculate Commission Button
Create a Function
Return a Value
Boolean Values
Subs vs. Functions
04.
Commission Form 2 (15:57)
Comments
VB Line Continuation _
MsgBox vbInformation
Warning if Sale Amount $0
DoCmd.RunSQL
INSERT INTO Statement
Set to Null after logging
05.
Review (4:18) |

|
|
Keywords:
Access VBA, Visual Basic for Applications, microsoft access tutorial, microsoft access tutorial, microsoft access training, calculator, val, debugger, on error resume next, if then else, exit sub, private sub, parameters, select case, end select, indenting, gotocontrol, dropdown, create a function, boolean, subs, functions, comments, line continuation, runsql, insert into |
|
|
|