Book description
You're beyond the basics, so dive right in and customize, automate, and extend Access—using Visual Basic for Applications (VBA). This supremely organized reference is packed with hundreds of time-saving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. Discover how the experts use VBA to exploit the power of Access—and challenge yourself to new levels of mastery!
Enhance your application with VBA built-in functions and SQL code
Use the Access Object Model to work with data in forms and reports
Manipulate data using SQL, queries, and recordsets with Data Access Objects (DAO)
Create classes for handling form and control events
Connect your Access database to different sources of data
Effectively plan how to upsize an existing Access database to Microsoft SQL Server
Dynamically update Microsoft Excel spreadsheets from the database
Migrate your Access database directly to the cloud using SQL Azure
Table of contents
- Dedication
- Introduction
- Features and Conventions Used in This Book
- About the Companion Content
- Acknowledgments
- Support and Feedback
-
I. VBA Environment and Language
- 1. Using the VBA Editor and Debugging Code
- 2. Understanding the VBA Language Structure
- 3. Understanding the VBA Language Features
-
II. Access Object Model and Data Access Objects (DAO)
- 4. Applying the Access Object Model
-
5. Understanding the Data Access Object Model
- The DAO Model
- Working with Databases
- Manipulating Data with Recordsets
- Working with Queries in Code
- Investigating and Documenting Objects
- Sample Applications
- Summary
-
III. Working with Forms and Reports
- 6. Using Forms and Events
- 7. Using Form Controls and Events
- 8. Creating Reports and Events
- IV. Advanced Programming with VBA Classes
-
V. External Data and Office Integration
- 12. Linking Access Tables
- 13. Integrating Microsoft Office
-
VI. SQL Server and SQL Azure
- 14. Using SQL Server
-
15. Upsizing Access to SQL Server
-
Planning for Upsizing
- Text Data Types and UNICODE
- Date and Time Data
- Boolean Data
- Integer Numbers
- Real Numbers, Decimals, and Floating-Point Numbers
- Hyperlinks
- IMAGE, VARBINARY(Max), and OLE Data
- Memo Data
- Currency
- Attachments and Multi-Value Data
- Required Fields
- Cycles and Multiple Cascade Paths
- Mismatched Fields in Relationships
- Replicated Databases and Random Autonumbers
- Unique Index and Ignore Nulls
- Timestamps and Row Versioning
- Schemas and Synonyms
- The Upsizing Wizard and the SQL Server Migration Assistant
- Developing with Access and SQL Server
- Summary
-
Planning for Upsizing
- 16. Using SQL Azure
- VII. Application Design
- A. About the Author
- Index
- About the Author
- Copyright
Product information
- Title: Microsoft® Access® 2010 VBA Programming Inside Out
- Author(s):
- Release date: July 2011
- Publisher(s): Microsoft Press
- ISBN: 9780735661639
You might also like
book
Programming Excel with VBA and .NET
Why program Excel? For solving complex calculations and presenting results, Excel is amazingly complete with every …
book
Excel 2016 Power Programming with VBA
Maximize your Excel experience with VBA Excel 2016 Power Programming with VBA is fully updated to …
book
VB & VBA in a Nutshell: The Language
The online documentation of VB/VBA language components seems to follow the 80/20 rule: the basic facts …
book
Excel 2016 VBA and Macros
This is the Rough Cut version of the printed book. SAVE TIME AND SUPERCHARGE EXCEL 2016 …