| |
| |
|
|
|
Access
Developer
Level 3
Developer-Level
Microsoft Access Tutorial - 1 Hour, 23 Minutes |
| |
|
|
| |
Access
Developer 3 continues our focus on learning how to program the
Visual Basic for Applications programming language (VBA) in
Microsoft Access.
Topics include:
 |
-
Variables, Dim, Initializing
- MsgBox as a
Function
-
Random Numbers, Rnd, Randomize
- Constants,
Const Keyword
- InputBox Function
- Math Quiz Form
- For Next Loops
- Data Types in VBA
- Quick Add Sales Rep
-
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
3 |
| 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 2 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, 23 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 exploring Variables, which are blocks of
memory you can allocate to keep track of values in your code without
having to use a table or form field. We will learn the OpenTable
command, do more with DLOOKUP, Exit Sub, learn how to properly
DIM our variables, learn a little more about error handling
with On Error Resume Next and On Error Goto 0, we'll see how
MsgBox can be used as a Function to return a
value, either vbYes, vbNo, or vbCancel.
Next, we'll learn how to
generate random numbers in VBA using the Rnd
and Randomize commands. We'll build a math quiz form
where the system will generate two random numbers to be added. The user
will then enter the answer and your program will check to see if they
are correct. We'll learn about Const (constants) that
are like variables but have a fixed value.
Next we will learn about
For Next Loops, which you can use to repeat actions a
specific number of times. We'll make another math quiz form that asks
the user X number of math questions and calculates how many they got
correct. We'll use the InputBox function to collect the
answers. We'll learn about the Format function, and we'll see what all
of the different data types are that can be used in VBA
including Boolean, Integer, Long, Single, Double, Currency, Date,
String, and Variant.
Finally, we'll create a
form to quickly add a sales rep from the commission
form. This is handy if you're entering a bunch of commission records,
and need to add a sales rep who isn't on the list. You don't have to
find the employee form, open it, add the rep, close the commission form
so it refreshes, and then pick the sales rep. This is one quick routine
that does it for you. We'll use InputBox to collect the
sales rep's info, store it in the table with an SQL statement, and
refresh the combo box automatically.
This is the 3rd 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
3
00. Intro (3:07)
01.
Variables (22:12)
Docmd.OpenTable
DLOOKUP
Exit Sub
Line Continuation Character
Variables
DIM ID As Long
On Error Resume Next
On Error Goto 0
Initializing Variables
MsgBox as a Function
vbYesNoCancel
vbYes, vbNo, vbCancel
02.
Random Numbers (9:33)
Rnd
Randomize
Int()
Const - Constants |
03. For Next Loops (21:47)
Looping Math Quiz
Set NumLoops
For Next
InputBox
Format Function, Percent
Format Function, 0.0%
Data Types
in Access VBA
Boolean
Integer, Long Integer
Single,
Double
Currency
Date, Date Time
String
Variant
04. Quick Add Sales Rep (21:10)
Add Link on Commission Form
InputBox First, Last, Com Rate
DCount, DMax, CDbl
Run Another Objects Event
05. Review (5:43) |
|
| |
| Keywords:
Access VBA, Visual Basic for Applications, microsoft access tutorial, microsoft access tutorial, microsoft access training, OpenTable, DIM variables, on error resume next, on error goto 0, vbYesNoCancel, vbYes, vbNo, vbCancel, Rnd, Randomize, Const, Int, Math Quiz, Random Numbers, InputBox, Format Function, Data Types |
| |
|
|
