Home > Courses Certifications > Programming > Access 2007 VBA synopsis

Access 2007 VBA

Duration: 5 days

Chapter 1: Introduction to Microsoft Access 2007

• A Brief History of Access
• Is Access the Only Database System?
• Developing Databases Without VBA Code

Chapter 2: Access, VBA, and Macros

• VBA in Access
• VBA versus Macros in Access

Chapter 3: New Features in Access 2007

• Who Benefits
• New Look
• Development Environment
• Forms
• Reports
• Embedded Macros
• Access Data Engine
• Integration with SharePoint
• External Data Sources
• Security
• Convert with Confidence
• ADE and Creating Runtime Files
• What’s Gone or Deprecated

Chapter 4: Using the VBA Editor

• Anatomy of the VBA Editor
• Using the Object Browser
• Testing and Debugging VBA Code

Chapter 5: VBA Basics

• VBA Objects
• Variables and VBA Syntax
• Other VBA Structures

Chapter 6: Using DAO to Access Data

• Data Access Objects
• Why Use DAO?
• New Features in DAO
• Referring to DAO Objects
• The DBEngine Object
• The Databases Collection
• DAO Object Properties
• Creating Schema Objects with DAO
• Database Encryption with DAO
• Managing Access (JET) Security with DAO
• Data Access with DAO
• Append Only Fields

Chapter 7: Using ADO to Access Data

• Ambiguous References
• Referring to ADO Objects
• Connecting to a Data Source
• Rolling Your Own Connection String
• Data Access with ADO
• Creating ADO Recordsets
• Creating Schema Recordsets
• Using ADO Events
• Testing the State Property
• Creating Schema Objects with ADOX
• Managing Security with ADO

Chapter 8: Executing VBA

• When Events Fire
• VBA Procedures
• Evaluating Expressions in VBA
• Using Recordsets
• Using Multiple Recordsets
• Using VBA in Forms and Reports
• Debugging VBA
• Investigating Variables
• Common VBA Techniques
• String Concatenation Techniques

Chapter 9: VBA Error Handling

• Why Use Error Handling?
• Two Kinds of Errors: Unexpected and Expected
• Basic Error Handling
• Cleaning Up After an Error
• More on Absorbing Expected Errors
• Issues in Error Handling

Chapter 10: Using VBA to Enhance Forms

• VBA Basics
• Creating Forms the 2007 Way

Chapter 11: Enhancing Reports with VBA

• Introduction to Reports
• Creating a Report
• Working with VBA in Reports
• Important Report Events and Properties
• Report Properties
• Working with Charts
• Common Report Requests
• Layout View
• Report View

Chapter 12: Customizing the Ribbon

• Ribbon Overview
• Custom Menu Bars and Toolbars
• Ribbon Customization
• Saving a Custom Ribbon
• Specifying the Custom Ribbon
• Creating an Integrated Ribbon
• Creating a Ribbon from Scratch
• Customizing the Office Menu
• Customizing the Quick Access Toolbar
• More Ribbon Tips

Chapter 13: Creating Classes in VBA

• A Touch of Class
• Why Use Classes?
• Creating a Class Module
• Naming Objects
• Using Class Events
• Forms as Objects
• Variable Scope and Lifetime
• The Me Property
• Creating a Clone Method
• Creating and Using Collection Classes
• The Three Pillars

Chapter 14: Extending VBA with APIs

• Introducing the Win32 API
• Introducing Linking
• Linking Libraries in Access 2007
• Understanding C Parameters
• Err.LastDLLError
• Distributing Applications That Reference
• Type Libraries and Custom DLLs

Chapter 15: SQL and VBA

• Working with SQL Strings in VBA
• Using SQL When Opening Forms and Reports
• Using SQL to Enhance Forms
• The ReplaceOrderByClause and ReplaceWhereClause Functions

Chapter 16: Working with Office Applications

• Sharing Information Is a Two-Way Street
• Working with Outlook
• Sending Information from Access to Excel
• Exchanging Data with Microsoft Word
• Sending Data to PowerPoint
• Pulling Data from Access

Chapter 17: Working with SharePoint

• Overview
• Access Features on SharePoint
• SharePoint Features in Access

Chapter 18: Database Security

• Security for the ACCDB File Format
• Security for the MDB File Format

Chapter 19: Understanding Client-Server Development with VBA

• Client-Server Applications
• Choosing the Correct File Format
• Controlling the Logon Process
• Binding ADODB Recordsets
• Using Unbound Forms

Chapter 20: Working with the Win32 Registry

• About the Registry
• Using the Built-In VBA Registry Functions
• Using the Win32 Registry APIs 709

Chapter 21: Using the ADE Tools

• The Redistributable Access Runtime
• The Package Solution Wizard
• Save as Template
• Source Code Control Support

Chapter 22: Protecting Yourself with Access 2007 Security

• The Office Trust Center
• Disabled Mode
• Digital Signatures and Certificates
• Access Database Engine Expression Service