Overview of Access Automation
Macros v Modules
Keyboard shortcuts
Writing Expressions v Modules
Toolbars and Menus - Customising
Converting Macros to Modules
Responding to Events
Event-Driven v Traditional Methods
Handling Events with Macros
Handling Events with VBA
Public and Private Events
Forms and Modules
Creating Code
Procedures (Sub and Function)
Built-in Functions
Variable Declaration and Data Types
Variable Scope and Lifetime
Control Structures
If...Then...Else...ElseIf
Logical Operators and Precedence
Select Case Statement
Loops and For...Next Statements
Arrays
Working with Objects
Properties, Methods and Classes
Collections (Container and Documents)
Error Collections
Object Browser Tool
Working with Recordsets
Types of Recordsets
Navigating through records
Counting and Finding data
Editing records
Memory Management
Working with External Data
Copying data (Excel and Text Files)
Mail Merge (Word)
Electronic Mail (Outlook)
Linked Tables
ODBC (DSN)
Reports
Expressions in reports
Handling Totals
Controlling Events
Formatting Reports
Error Handling
Debugging Tools
Error Numbers and Descriptions
Types of Errors
Advanced Topics
DAO Object
Dynamic Link Libraries (DLL)
Add-Ins
Optimising Databases
OLE and Other Applications |
