McGraw Hill - Access VBA Programming

• Table of Contents
• BackCover
• Access VBAProgramming
• Introduction
  • Who Should Read This Book?
• Part I: Understanding the MS Access Environment
  • Chapter 1: Introduction toVBA for Applications
    • History of Microsoft Access
    • Developing in Access
    • The Future of Microsoft Access
    • Summary
  • Chapter 2: Designing anAccess Application
    • Steps in the Development Process
    • Definition and Analysis of Requirements
    • Evaluation of Requirements
    • Development of the Design
    • Implementation and Testing
    • Documentation
    • Maintenance
    • Summary
  • Chapter 3: Access DevelopmentWithout VBA
    • System Architecture
    • Understanding a Database Application
    • Working Without VBA
    • Events
    • Naming Conventions
    • Predefined Templates
    • Switchboard Manager
    • Summary
  • Chapter 4: Customizing theAccess Environment
    • Customizing Shortcut Menus
    • Creating Menus
    • Attaching Code to a Custom Menu Item
    • Summary
• Part II: Understanding the Visual Basic forApplications Environment
  • Chapter 5: Introducing the VBAProgramming Environment
    • Introduction to VBA
    • The VBA Model
    • The Concept of Objects
    • The VBA Editor
    • Summary
  • Chapter 6: Programming Fundamentals Using VBA
    • Control Structures
    • Arrays
    • Summary
  • Chapter 7: Understanding theVisual Basic Editor
    • Highlights of the Menu System
    • The Debug, Edit, and UserForm Toolbars
    • The Project Explorer
    • Managing Modules
    • Properties Window
    • The Object Browser
    • References
    • Using VBA Editor Options
    • Getting Help
    • Starting a New Procedure in the VBA Editor
    • Summary
  • Chapter 8: VBA LanguageComponents
    • Objects in VBA
    • Intrinsic Constants
    • Basic VBA Programs Using Forms
    • Connecting with Microsoft Access
    • SQL (Structured Query Language)
    • SQL and VBA
    • Output
    • Summary
  • Chapter 9: Sub Procedures
    • Declaring a Procedure
    • Functions
    • Parameters
    • Design and Scope
    • Global and Static Variables
    • Using Procedures to Change a Database Structure
    • Summary
  • Chapter 10: Debugging VBACode
    • The Err Object
    • The Errors Collection
    • Tools for Debugging Code
    • Summary
  • Chapter 11: FunctionProcedures
    • Subs vs. Functions
    • Built-in Functions
    • Date and Time Functions
    • Payment Function
    • Summary
• Part III: Interacting with VBA
  • Chapter 12: Forms
    • Assigning Recordsets Dynamically
    • Appending and Editing Data
    • Controlling Controls in Forms
    • Summary
  • Chapter 13: Reports
    • Anatomy of a Report
    • Report Wizard
    • Specialized Reports
    • Calling the Report from VBA
    • Creating a Report Programmatically
    • Summary
  • Chapter 14: Menus andToolbars
    • Creating a Toolbar
    • Menus
    • Submenus
    • Summary
  • Chapter 15: Changing theAccess Environment
    • Changing Options
    • Summary
• Part IV: Advanced Access Programming Techniques
  • Chapter 16: DatabaseSecurity
    • Access and Security
    • User-Level Security
    • Security and Access 2003
    • Summary
  • Chapter 17: Access and theMicrosoft Office Environment
    • Shared Objects
    • Connecting with Other Microsoft Office Products
    • Summary
  • Chapter 18: Access and theWeb
    • The Mechanics of the Web
    • Data Access Pages
    • XML (Extended Markup Language)
    • Summary
  • Chapter 19: Upgrading
    • Microsoft Access vs. SQL Server
    • Access Data Projects
    • Working with an ADP File
    • Summary
• Part V: Application Development
  • Chapter 20: MultiuserApplications
    • Sharing the Database
    • Handling Resource Contention and Conflicts
    • Improving Application Performance
    • Summary
  • Chapter 21: BeyondMicrosoft Access
    • VBA and Microsoft Office
    • Visual Basic
    • VBScript
    • Transition to Microsoft .NET
    • Summary
• Appendix: The DoCmd Object
  • AddMenu
  • ApplyFilter
  • Beep
  • CancelEvent
  • Close
  • CopyDatabaseFile
  • CopyObject
  • DeleteObject
  • DoMenuItem
  • Echo
  • FindNext
  • FindRecord
  • GoToControl
  • GoToPage
  • GoToRecord
  • Hourglass
  • Maximize
  • Minimize
  • MoveSize
  • OpenDataAccessPage
  • OpenDiagram
  • OpenForm
  • OpenFunction
  • OpenModule
  • OpenQuery
  • OpenReport
  • OpenStoredProcedure
  • OpenTable
  • OpenView
  • OutputTo
  • PrintOut
  • Quit
  • Rename
  • RepaintObject
  • Requery
  • Restore
  • RunCommand
  • RunMacro
  • RunSQL
  • Save
  • SelectObject
  • SendObject
  • SetMenuItem
  • SetWarnings
  • ShowAllRecords
  • ShowToolbar
  • TransferDatabase
  • TransferSpreadsheet
  • TransferSQLDatabase
  • TransferText
• Index
  • Index_B
  • Index_C
  • Index_D
  • Index_E
  • Index_F
  • Index_G
  • Index_H
  • Index_I
  • Index_J
  • Index_L
  • Index_M
  • Index_N
  • Index_O
  • Index_P
  • Index_Q
  • Index_R
  • Index_S
  • Index_T
  • Index_U
  • Index_V
  • Index_W
  • Index_X
• List of Figures
• List of Tables