Microsoft Access 2016 Programming by Example with VBA, XML, and ASP
- 14h 57m
- Julitta Korol
- Mercury Learning
- 2017
Microsoft Access 2016 Programming by Example with VBA, XML, and ASP takes nonprogrammers through detailed steps of creating Access databases from scratch and shows them how to retrieve and manage their data programmatically using various programming languages and techniques. With more than 275 applied examples and 10 projects, Access users can quickly build database solutions with Data Access Objects (DAO) and ActiveX Data Objects (ADO); define database objects and manage database security with Structured Query Language (SQL); enhance and alter the way users interact with database applications with Ribbon customizations and event programming in forms and reports; and program Microsoft Access databases for Internet access with Active Server Pages (ASP) and Extensible Markup Language (XML). The book, which covers the latest release of Access 2016 and earlier versions, is divided into nine parts (32 chapters) that progressively introduce you to programming Access .mdb and .accdb databases.
FEATURES
- Updated for MS Access 2016 and previous versions
- Includes more than 275 applied examples and 10 projects
- Covers Office Web Apps
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 over 20 computer books including Microsoft Excel 2013 Programming with VBA, XML and ASP (Mercury Learning).
In this Book
-
Introduction
-
Getting Started with Access VBA
-
Getting to Know Visual Basic Editor (VBE)
-
Access VBA Fundamentals
-
Access VBA Built-in and Custom Functions
-
Adding Decisions to Your Access VBA Programs
-
Adding Repeating Actions to Your Access VBA Programs
-
Keeping Track of Multiple Values Using Arrays
-
Keeping Track of Multiple Values Using Object Collections
-
Getting to Know Built-in Tools for Testing and Debugging
-
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 2016
