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
[email protected]). 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
[email protected]). 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
[email protected]). All source code and supplemental files for
the Hands-On exercises and custom projects All images from the text
(including 4-color screenshots)
General
Is the information for this product incomplete, wrong or inappropriate?
Let us know about it.
Does this product have an incorrect or missing image?
Send us a new image.
Is this product missing categories?
Add more categories.
Review This Product
No reviews yet - be the first to create one!