| |
| |
|
|
|
Access
Advanced
Level 2
Expert
Microsoft Access Tutorial - 1 Hour, 3 Minutes |
| |
|
|
| |
Access Advanced 2 focuses on more Macros and
Events.
Topics include:
 |
-
Open a Form to a New Record
- GoToRecord
Command
-
Adding Child Records Before Parent
- GoToControl,
RefreshRecord Commands
- Quote / Invoice
Toggle Button
- SetValue v. SetProperty
Commands
- On Click Event, RunMacro Command
-
Change Caption Property with Macro
- On Current
Event
-
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 Advanced 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
Advanced 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, 3 Minutes |
|
Cost: |
$37.99 |
|
|
|
This class continues our exploration of Macros and
Event Handling. We will begin with one of the more popular
topics I get asked about: how do you open a form and go directly to a
new record without using Data Entry mode? I'll show you how to do that
with a macro. You'll learn about OpenForm and
GoToRecord.
Next we'll tackle another
popular problem: what happens when you open a form with a subform (for
example, our order form) and the user tries to add a CHILD
record before there is a parent record in place? For example, they try
to add a line item detail before there is an OrderID. This is a little
more complicated, and we'll need to learn how to check for a missing
Parent ID field, and use the GoToControl, SetValue,
RefreshRecord, and GoToRecord commands to handle this one.
Finally, we'll design a
toggle button where we can change the caption (and
other properties) of the button so that it says "INVOICE" or "Quotation"
depending on what kind of order this is. We have to learn how to
dynamically change that caption for each record using the On
Click Event and the On Current Event. We'll learn about the Caption
property, external macros, the RunMacro command, and the Enabled
property.
This is the 2nd class in the Access Advanced series. If you're
serious about building quality databases with Access, and you want to
learn how to automate your database with Macros
and Events, which is a good pre-cursor to 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
Advanced Level
2
00. Intro (2:33)
01. Add
New Order Button (7:28)
Open Form to New Record
OpenForm
GoToRecord, New
Add New Order Button on CustomerF
Add New Order Button on OrderListF
02. Add
Details Before Order (20:29)
Adding Child Records Before
Parent
Missing Parent ID
Before Insert Event
GoToControl
SetValue
RefreshRecord
GoToRecord |
03. Quote or Invoice Caption (28:23)
Toggle Button
Bind Button to Data
SetProperty Command
On Click Event
Caption Property
Change from Record to
Record
Change on Form Open
On Current Event
External
Macros
RunMacro Command
Reusing Code / Macros
SetValue
Command
Enabled Property
04. Review (4:05)
|
|
| |
| Keywords:
Macros, Events, microsoft access tutorial, microsoft access tutorial, microsoft access training, GoToRecord, New Order Button, Child Records, GoToControl, SetValue, RefreshRecord, SetProperty, On Click Event, On Current Event, External Macros, RunMacro, SetValue, Enabled Property |
| |
|
|
