With more than 275 applied examples and 10 projects, Access users can quickly build database solutions with ActiveX Data Objects, perform database tasks with Jet/Access Structured Query Language and export/import Access data to and from XML both manually and programmatically.

Microsoft Access 2013 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 2013 and earlier versions, is divided into nine parts (32 chapters) that progressively introduce you to programming Access.mdb and.accdb databases. 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"; reprogram characteristics of a database; and use various techniques to query and manipulate your database. Features: Updated for MS Access 2013 and previous versions; includes more than 275 applied examples and 10 projects; covers Office Web Apps; and a CD with color screen captures, source code, and supplemental files for projects in the text.