Microsoft Access 2016 Programming By Example : : with VBA, XML, and ASP / / Julitta Korol.

• VerfasserIn: Korol, Julitta,
• Place / Publishing House: Dulles, VA : : Mercury Learning and Information, , [2016]; ©2016
• Year of Publication: 2016
• Language: English
• Physical Description: 1 online resource (900 p.)

Updated for Access 2016 and based on the bestselling editions from previous versions, Microsoft Access 2016 Programming by Example with VBA, XML and ASP is a practical how-to book on Access programming, suitable for readers already proficient with the Access user interface (UI). If you are looking to automate Access routine tasks, this book will progressively introduce you to programming concepts via numerous illustrated hands-on exercises. More advanced topics are demonstrated via custom projects. Includes a comprehensive disc with source code, supplemental files, and color screen captures (Also available from the publisher for download by writing to [e-mail]). With concise and straightforward explanations, you learn how to write and test your programming code with the built-in Visual Basic Editor; understand and use common VBA programming structures such as conditions, loops, arrays, and collections; code a "message box"; reprogram characteristics of a database; and use various techniques to query and manipulate your Access .mdb and .accdb databases. The book shows you how you can build database solutions with Data Access Objects (DAO) and ActiveX Data Objects (ADO); define database objects and manage database security with SQL; enhance and alter the way users interact with database applications with Ribbon customizations and event programming in forms and reports. You also learn how to program Microsoft Access databases for Internet access with Active Server Pages (Classic ASP), HTML, and XML. Features: + Contains over thirty chapters loaded with illustrated hands-on exercises and projects that guide you through the VBA programming language. Each example tells you exactly where to enter code and how to test it and then run it. + Includes a comprehensive disc with source code, supplemental files, and color screen captures (Also available from the publisher for download by writing to [e-mail]). + Explains how to store data for further manipulation in variables, arrays, and collections while teaching you to write both simple and complex VBA programming routines and functions. + Teaches you how to programmatically create and access database tables and fields. + Shows you how to insert, update, and delete data via programming code using various data access techniques. + Gets you proficient creating and running simple and parameterized queries against your Access databases. + Gets you comfortable using external data sources with Access (Excel, Word, flat files, XML, and SQL Server). + Teaches you how to take control of your forms and reports by writing programming code known as event procedures. + Shows you how to use various types of macros and templates. + Takes your programming skills to the Web by introducing you to dynamic XML and Classic ASP pages.On the disc:(Also available from the publisher for download by writing to [e-mail]). + All source code and supplemental files for the Hands-On exercises and custom projects + All images from the text (including 4-color screenshots)

Table of Contents

Frontmatter -- Dedication -- CONTENTS -- Acknowledgments. -- Introduction -- PART I ACCESS VBA PRIMER -- Introduction -- Chapter 1 Getting Started with Access VBA -- Chapter 2 Getting to Know Visual Basic Editor (VBE) -- Chapter 3 Access VBA Fundamentals -- Chapter 4 Access VBA Built-In and Custom Functions -- Chapter 5 Adding Decisions to Your Access VBA Programs -- Chapter 6 Adding Repeating Actions to Your Access VBA Programs -- Chapter 7 Keeping Track of Multiple Values Using Arrays -- Chapter 8 Keeping Track of Multiple Values Using Object Collections -- Chapter 9 Getting to Know Built-In Tools for Testing and Debugging -- PART II ACCESS VBA PROGRAMMING WITH DAO AND ADO -- Introduction -- Chapter 10 Data Access Technologies in Microsoft Access -- Chapter 11 Creating and Accessing Database Tables and Fields -- Chapter 12 Setting Up Primary Keys, Indexes, and Table Relationships -- Chapter 13 Finding and Reading Records -- Chapter 14 Working with Records -- Chapter 15 Creating and Running Queries with DAO/ADO -- Chapter 16 Using Advanced ADO/DAO Features -- Chapter 17 Implementing Database Security -- PART III PROGRAMMING WITH THE JET DATA DEFINITION LANGUAGE -- Introduction -- Chapter 18 Creating, Modifying, and Deleting Tables and Fields -- Chapter 19 Enforcing Data Integrity and Relationships between Tables -- Chapter 20 Defining Indexes and Primary Keys -- Chapter 21 Database Security -- Chapter 22 Views and Stored Procedures -- PART IV ENHANCING THE USER EXPERIENCE -- Introduction -- Chapter 23 Enhancing Access Forms -- Chapter 24 Using Form Events -- Chapter 25 Events Recognized by Controls -- Chapter 26 Enhancing Access Reports and Using Report Events -- Chapter 27 Advanced Event Programming -- Chapter 28 Programming the User Interface -- PART V VBA AND MACROS -- Introduction -- Chapter 29 Macros and Templates -- PART VI TAKING YOUR VBA PROGRAMMING SKILLS TO THE WEB -- Introduction -- Chapter 30 Access and Active Server Pages -- Chapter 31 XML Features in Access 2016 -- Index