Synopses & Reviews
You're beyond the basics, so dive right in and build sophisticated and elegant business solutions with Access—using Microsoft® Visual Basic® for Applications (VBA). This supremely organized reference is packed with hundreds of timesaving 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!
- Gain a deep understanding of how to design effective Access applications
- Get started with client-server design and cloud computing
- Broaden your skill set by developing applications linked to Microsoft SQL Server
- Support existing applications that contain a large amount of programming code
- Tame complex controls such as the TreeView, Tab, and ListView
- Use a variety of approaches to design your user interface
- Automate the integration of data from different sources
- Extend Access applications by connecting to Microsoft SharePoint® and other Microsoft Office® applications
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
About the Author
Andrew Couch is a Microsoft Access MVP. He has been programming with VBA since it was introduced into the Access product, and uses VBA on a daily basis in commercial applications. As a director and founding member of the UK Access User Group, he has been involved with developers and software companies using VBA. Andrew is also an experienced instructor, and has taught Introductory, Advanced, and VBA programming courses.
Table of Contents
; Introduction; Who This Book Is For; Assumptions About You; How This Book Is Organized; Features and Conventions Used in This Book; Text Conventions; Design Conventions; About the Companion Content; Access Versions; Acknowledgments; Support and Feedback; Errata & Support; We Want to Hear from You; Stay in Touch; How to Access Your Online Edition Hosted by Safari; How to Download the Online Edition to Your Computer; VBA Environment and Language; Chapter 1: Using the VBA Editor and Debugging Code; 1.1 Debugging Code on a Form; 1.2 Creating Modules and Procedures; 1.3 Debugging Code in a Module; 1.4 Breakpointing Code; 1.5 Using the Object Browser and Help System; 1.6 Summary; Chapter 2: Understanding the VBA Language Structure; 2.1 VBA Language Settings; 2.2 Working with Constants and Variables; 2.3 Functions and Procedures; 2.4 Control Statements and Program Flow; 2.5 Summary; Chapter 3: Understanding the VBA Language Features; 3.1 Using Built-In Functions; 3.2 Domain Functions; 3.3 SQL and Embedded Quotes; 3.4 Objects and Collections; 3.5 Creating Maintainable Code; 3.6 VBA and Macros; 3.7 Error Handling; 3.8 Summary; Access Object Model and Data Access Objects (DAO); Chapter 4: Applying the Access Object Model; 4.1 The Application Object Methods and Properties; 4.2 The CurrentProject and CurrentData Objects; 4.3 The DoCmd Object; 4.4 Manipulating the Forms and Reports Collections; 4.5 Using the Screen Object; 4.6 Enhancing the User Interface; 4.7 Summary; Chapter 5: Understanding the Data Access Object Model; 5.1 The DAO Model; 5.2 Working with Databases; 5.3 Manipulating Data with Recordsets; 5.4 Working with Queries in Code; 5.5 Investigating and Documenting Objects; 5.6 Sample Applications; 5.7 Summary; Working with Forms and Reports; Chapter 6: Using Forms and Events; 6.1 Displaying Records; 6.2 Filtering by Using Controls; 6.3 Interacting with Records on a Form; 6.4 Editing and Undo on a Record; 6.5 Summary; Chapter 7: Using Form Controls and Events; 7.1 Control Events; 7.2 Combo Boxes; 7.3 List Boxes; 7.4 The TreeView Control; 7.5 The Tab Control; 7.6 Summary; Chapter 8: Creating Reports and Events; 8.1 Report Event Sequences; 8.2 Report Layout Control; 8.3 Summary; Advanced Programming with VBA Classes; Chapter 9: Adding Functionality with Classes; 9.1 Improving the Dynamic Tab Control; 9.2 Creating a Hierarchy of Classes; 9.3 Summary; Chapter 10: Using Classes and Events; 10.1 WithEvents Processing; 10.2 Abstract and Implementation Classes; 10.3 Friend Methods; 10.4 Summary; Chapter 11: Using Classes and Forms; 11.1 Opening Multiple Instances of a Form; 11.2 Classes and Binding Forms; 11.3 ActiveX Controls and Events; 11.4 Summary; External Data and Office Integration; Chapter 12: Linking Access Tables; 12.1 Linking Access to Access; 12.2 Linking to Excel and Text Files; 12.3 Linking to SQL Server; 12.4 Linking to SQL Azure; 12.5 Linking to SharePoint Lists; 12.6 Linking Access Web Databases; 12.7 Summary; Chapter 13: Integrating Microsoft Office; 13.1 Working with Objects and Object Models; 13.2 Connecting Access to Word; 13.3 Connecting Access to Excel; 13.4 Connecting Access to Outlook; 13.5 Summary; SQL Server and SQL Azure; Chapter 14: Using SQL Server; 14.1 Introducing SQL Server; 14.2 Getting Started with the SQL Server Management Studio; 14.3 Creating Tables and Relationships; 14.4 Working with Views; 14.5 Working with Stored Procedures; 14.6 Introducing T-SQL; 14.7 Working with Triggers; 14.8 Working with Transactions; 14.9 User-Defined Functions; 14.10 Getting Started with SQL Server Security; 14.11 Summary; Chapter 15: Upsizing Access to SQL Server; 15.1 Planning for Upsizing; 15.2 The Upsizing Wizard and the SQL Server Migration Assistant; 15.3 Developing with Access and SQL Server; 15.4 Summary; Chapter 16: Using SQL Azure; 16.1 Introducing SQL Azure; 16.2 Migrating SQL Databases; 16.3 The Data Sync Feature; 16.4 Planning and Managing Security; 16.5 Building Multi-Tenanted Applications; 16.6 SQL Server Migration Assistant and Access to Azure; 16.7 Summary; Application Design; Chapter 17: Building Applications; 17.1 Developing Applications; 17.2 Completing an Application; 17.3 Deploying Applications; 17.4 Summary; Chapter 18: Using ADO and ADOX; 18.1 ActiveX Data Objects; 18.2 Working with SQL Server; 18.3 ADOX; 18.4 Summary; About the Author;