Microsoft Access 2013 Programming By Example with VBA, XML, and ASP

  • 14h 53m
  • Julitta Korol
  • Mercury Learning
  • 2014

Updated for Access 2013 and based on the bestselling editions from previous versions, Microsoft Access 2013 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. 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.
  • 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
  • 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.

About the Author

JULITTA KOROL is a software consultant who delivers custom-tailored hands-on training and develops advanced database and spreadsheet applications. She has written a dozen computer books including Microsoft Excel 2010 with VBA, XML and ASP (Mercury Learning). She lives on Long Island, New York.

In this Book

  • Writing Procedures in Modules
  • Exploring the Visual Basic Editor (VBE)
  • Using Variables, Data Types, and Constants
  • Passing Arguments to Procedures and Functions
  • Decision Making with VBA
  • Repeating Actions in VBA
  • Working with Arrays
  • Working with Collections and Class Modules
  • VBE Tools for Testing and Debugging
  • Conditional Compilation and Error Trapping
  • Data Access Technologies in Microsoft Access
  • Creating and Accessing Database Tables and Fields
  • Setting up Primary Keys, Indexes, and Table Relationships
  • Finding and Reading Records
  • Working with Records
  • Creating and Running Queries with DAO/ADO
  • Using Advanced ADO/DAO Features
  • Implementing Database Security
  • Creating, Modifying, and Deleting Tables and Fields
  • Enforcing Data Integrity and Relationships Between Tables
  • Defining Indexes and Primary Keys
  • Database Security
  • Views and Stored Procedures
  • Enhancing Access Forms
  • Using Form Events
  • Events Recognized by Controls
  • Enhancing Access Reports and Using Report Events
  • Advanced Event Programming
  • Programming the User Interface
  • Macros and Templates
  • Access and Active Server Pages
  • XML Features in Access 2013
SHOW MORE
FREE ACCESS