Microsoft Access 2013 Programming by Example with VBA, XML, and ASP / / Julitta Korol.

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

With more than 275 applied examples and 10 projects, Access users can quickly build database solutions with ActiveX Data Objects (ADO), perform database tasks with Jet/Access Structured Query Language (SQL) and export/import Access data to and from XML both manually and programmatically. The book, which covers the latest release of Access and earlier versions, is divided into five parts: an introduction to VBA programming, manipulating databases with ADO, using DDL, event programming, and using ASP and XML. The text will show you how to write and debug your programming code with the Visual Basic Editor; understand and use common VBA programming structures such as conditions, loops, arrays, and collections; code a “message box” and reprogram characteristics of a database; query and manipulate your database from a Web browser with Active Server Pages (ASP) and many more practical techniques.Features: Covers in great detail the latest version of Access and all of its features. Includes more than 275 applied examples and 10 projects. Covers Office Web Apps

Table of Contents

Frontmatter -- Dedication -- CONTENTS -- Acknowledgments -- Introduction -- PART 1—INTRODUCTION TO ACCESS 2013 VBA PROGRAMMING -- PART 2—CONTROLLING PROGRAM EXECUTION -- PART 3—KEEPING TRACK OF MULTIPLE VALUES -- PART 4—ERROR HANDLING AND DEBUGGING -- PART 5—ACCESS VBA PROGRAMMING WITH DAO AND ADO -- PART 6— PROGRAMMING WITH THE JET DATA DEFINITION LANGUAGE -- PART 7—ENHANCING THE USER EXPERIENCE -- PART 8—VBA AND MACROS -- PART 9— TAKING YOUR VBA PROGRAMMING SKILLS TO THE WEB -- Index