| |
| |
|
|
|
Access
Advanced
Level 3
Expert
Microsoft Access Tutorial - 1 Hour, 22 Minutes |
| |
|
|
| |
Access Advanced 3 focuses on more Macros and
Events.
Topics include:
 |
-
More Control Properties
- ForeColor,
BackColor, FontSize, etc.
- VAL, RGB,
InputBox Functions
- OnGotFocus,
OnLostFocus Events
- Locking Paid Orders
- Enabled vs. Locked Properties
- Adding a
Password to a Form Event
- Using SetTempVar to
Store Variables
- BeforeUpdate, RunMacro
-
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
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
Advanced 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, 22 Minutes |
|
Cost: |
$37.99 |
|
|
|
This class continues our exploration of Macros and
Event Handling. We will begin by learning more about control
properties. We'll learn all about manipulating colors and fonts with the
ForeColor, BackColor properties, the VAL and RGB functions, Access color
codes, hexadecimal values, color constants, theme v. standard colors,
FontSize, and more.
We will learn how to
change many other properties of our forms using our event macros, such
as the font size, the size of text boxes, making
controls visible and invisible, and more. We will use the OnGotFocus and
OnLostFocus events to make our Description notes field get larger when
we click on it, and then smaller when we click (or tab) off of it.
We will learn how to add
some security to our form. For example, when a user marks an order
PAID, we don't want them to be able to go back and mark
it UNPAID without a manager's approval. So this will
require a password. We'll learn about the Enabled and
Locked properties, and how they're different. We'll learn how to lock a
subform and the other controls. We'll learn how to store data in memory
variables with the SetTempVar command. We'll use the InputBox function
to collect the password data from the user. We'll learn why BeforeUpdate
allows us to cancel the event. We'll learn how to run a global macro
using the RunMacro command.
This is the 3rd 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
3
00. Intro (2:48)
01. More Control Properties 1 (19:20)
ForeColor
#FFFFFF Colors
Use VAL() Function
=Val("&H000000")
How Hexadecimal Numbers Work
RGB()
Function
Access Color Codes
Command Button to MessageBox
Color Code
Discussion of Color Constants in VBA
vbRed,
vbBlue, etc.
BackColor
Theme Colors v. Standard Colors
FontSize Property
02. More Control Properties 2 (21:14)
FontName Property
Visible Property
Height, Width
Properties
OnGotFocus, OnLostFocus Events
Make Notes Field
Larger When Clicked On
Top, Left Properties
BackStyle
Property
Have Access Tell You the Numeric Values
BorderStyle Property
Changing Form Background Colors
Forms!MyForm.Detail.BackColor
Forms!MyForm.FormHeader.BackColor
Forms!MyForm.FormFooter.BackColor |
03. Locking Paid Orders (35:14)
Enabled Property for Controls
Lock Subform
Difference
Between Locked and Enabled
Store Data in Temporary Variables
SetTempVar Command
InputBox Function
MessageBox
TempVars!Variable
Check for Password
BeforeUpdate vs.
AfterUpdate
Cancel BeforeUpdate Event
CancelEvent Command
Don't Run Event on PAID only UNPAID
RunMacro Command
04. Review (4:13)
|
|
| |
| Keywords:
Macros, Events, microsoft access tutorial, microsoft access tutorial, microsoft access training, Control Properties, VAL, RGB, Color Codes, MessageBox, FontSize, FontName, OnGotFocus, OnLostFocus, Enabled, Locked, SetTempVar, RunMacro |
| |
|
|
