Beginning Access 2007 VBA
Beginning Access 2007 VBA
ISBN: 0470046848
EAN: 2147483647
EAN: 2147483647
Year: 2004
Pages: 143
Pages: 143
Authors: Denise M. Gosnell
- Table of Contents
- Back Cover
- Beginning Access 2007 VBA
- Introduction
- What This Book Covers
- How This Book Is Structured
- What You Need to Use This Book
- Conventions
- Source Code
- Errata
- p2p.wrox.com
- Chapter 1: Introduction to Access 2007 VBA
- What Is Access 2007 VBA?
- Whats New in Access 2007 VBA?
- Access 2007 VBA Programming 101
- Summary
- Exercises
- Chapter 2: The Basics of Writing and Testing VBA Code
- Creating Modules
- Standard Modules versus Class Modules
- Creating and Calling Procedures
- Using Variables and Constants to Store Values
- Controlling Program Flow
- Documenting Your Code
- Error Debugging
- Error Handling
- Summary
- Exercises
- Chapter 3: Programming Applications Using Objects
- Viewing Objects Using the Object Browser
- Ways to Refer to Objects
- Using Access Collections and Objects
- Summary
- Exercises
- Chapter 4: Creating Your Own Objects
- Create Custom Properties for Existing Objects
- Create Custom Methods for Existing Objects
- Summary
- Exercises
- Chapter 5: Interacting with Data Using ADO and SQL
- Using ADODB to Work with Data
- Introduction to SQL
- Using ADOX to Manipulate Data Objects
- Summary
- Exercises
- Chapter 6: Building Interactive Forms
- Form Navigation and Flow
- Working with Controls
- Building User Interaction
- Adding Polish to Your Forms
- Summary
- Exercises
- Chapter 7: Importing, Linking, and Exporting Using External Data Sources
- Linking, Importing, and Exporting Overview
- Access and Other Databases
- Transferring Complete SQL Server Database
- Spreadsheets
- Text Files
- XML Files
- E-mails and Outlook
- Other Ways to Export Data
- Summary
- Exercises
- Chapter 8: Using Access with Web Services and SharePoint Lists
- Introduction to Web Services
- Using Data from Web Services
- Introduction to SharePoint Lists
- Using Data from SharePoint Lists
- Summary
- Exercises
- Chapter 9: Creating Reports and Web-Enabled Output
- Exporting Access Data to Web Formats
- Summary
- Exercises
- Chapter 10: Building SQL Server Applications with Access Projects
- Setting Up SQL Server
- Creating Access Projects (ADPs)
- Working with SQL Server Objects from Access
- Migrating an Existing Access Database to an Access Project
- Summary
- Exercises
- Chapter 11: Advanced Access Programming
- Using Dynamic Link Libraries (DLLs)
- Automation
- ActiveX Controls
- Libraries
- Add-Ins
- Transactions
- Summary
- Exercises
- Chapter 12: Finishing the Application
- Multiuser Considerations
- Optimizing Your Applications
- Securing Your Application
- Distributing Your Application
- Maintaining the Application
- Summary
- Exercises
- Chapter 13: Case Study 1-Project Tracker Application
- Design Specifications
- Building the Database
- Building the User Interface
- Building the Class Modules for the Objects
- Building the Standard Modules
- Connecting the User Interface to the Code
- Touring the Finished Project Tracker Application
- Summary
- Chapter 14: Case Study 2-Customer Service Application
- Design Specifications
- Building the Database and Database Objects
- Building the User Interface
- Building the Class Module for the Objects
- Building the Standard Modules
- Connecting the User Interface to the Code
- Touring the Finished Customer Service Application
- Summary
- Index
- B
- C
- D
- E
- F
- G
- H
- I
- J
- K
- L
- M
- N
- O
- P
- Q
- R
- S
- T
- U
- V
- W
- X
- Y
- List of Try It Outs
Beginning Access 2007 VBA
ISBN: 0470046848
EAN: 2147483647
EAN: 2147483647
Year: 2004
Pages: 143
Pages: 143
Authors: Denise M. Gosnell