|
|
Microsoft Access
Introduction
Intermediate
Level 1
Intermediate
Level 2
Queries
Advanced
VBA Level 1
VBA Level
2
Version
2007 Upgrade
Register Now
View Course Outline PDF
(all Access Courses show in one PDF file)
|
|
Course Dates (9am to 4pm)
Course Prerequisites
Required:
Solid understanding of all Access Introduction & Intermediate Level I
topics. Recommended: Understanding of Queries course topics and
Advanced Level I topics.
Course Description
This course looks at using Access Visual Basic for
Applications. Topics include: form, report and database modules, events,
writing procedures, and using memory variables.
Detailed List of Topics
Overview
Macros
vs. Code
Module
Types
Understanding Events
Events
Click
BeforeUpdate
AfterUpdate
NotInList
Close
Events
Open
Events
Delete
Events
Cancel
Events
Form
Current
Procedures & Modules
Understanding Wizard Code
Module
Window
Deleting
Procedures
Comments
About
Control & Object Names
Procedure Level Variables
Creating General Procedures
Creating Database Modules
Debug/Immediate Window
Intrinsic Constants
|
Commands
Closing
Objects
Setting
Values in Controls (text, numbers, formulas)
If,
Else, ElseIf, Endif
Select
Case
Displaying a MsgBox
SendKeys
Delete
Records
Showing/Hiding Controls
Setting
Control Properties
Calling
Procedures
Passing
Parameters
Setting
Input Masks
Find
Combo Box
Email
Command Button
Moving
Through Records
Requery
Controls
Referencing Forms
Is a
Form Open?
Error
Handling
Case
vs. If
Null
vs. ""
Creating Labels
Functions
MsgBox()
CurrentUser()
Format()
IsNull()
Dlookup()
Dmax()
DCount()
InputBox()
|
|
