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.
“"This particular book is an updated edition of Korol's popular Microsoft Access book (previous editions are available for Access 2003, 2007 and 2010). If you have one of the earlier editions and have moved along to Access 2013, it would be a wise move to get the latest edition of Korol's book, too. And if you are just learning how to program using Microsoft Access, this is probably one of the best books to use to do so. The books assume that you have some familiarity with the Access user interface, but even for novice users the book is very straightforward and explanatory. If you want to automate some of your day-to-day tasks in Access, this book can help. It introduces programming concepts using simple-to-follow, hands-on lessons. The exercises are thorough and well-written. By following the explanations provided in this book, you can learn how to write and test code with the built-in Visual Basic Editor, use common VBA programming structures, code a message box, reprogram characteristics of a database, among many other useful explanations. If you are looking for help building solutions with Data Access Objects (DAO) and ActiveX Data Objects (ADO), look no further -- Korol offers up tactics and techniques to help you learn. Overall, the material is presented systematically, with good examples, and helpful descriptions. I recommend this book to anybody looking to learn VBA with Microsoft Access."”
Kay Ewbank:
This book starts off by assuming the reader knows no programming, has never seen a variable or a loop. If you are in that position, and you want to go from being a non-programmer to developing full Access applications, you would be able to get there using this book.
If you already know how to write code, and want to know how to work with the mess that is Access VBA, this book is still worth reading as when Korol is writing on this, she writes well. You can simply skip the first half that works through more basic programming.
Kay Ewbank:
This book starts off by assuming the reader knows no programming, has never seen a variable or a loop. If you are in that position, and you want to go from being a non-programmer to developing full Access applications, you would be able to get there using this book.
If you already know how to write code, and want to know how to work with the mess that is Access VBA, this book is still worth reading as when Korol is writing on this, she writes well. You can simply skip the first half that works through more basic programming.
Korol Julitta :
Since 1993, Julitta Korol has published two dozen computer books on using and programming Microsoft Excel and Microsoft Access. She has completed professional certifications by Microsoft Corporation and the Computing Technology Industry Association (CompTIA).
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.
This item is eligible for simple returns within 30 days of delivery. Return shipping is the responsibility of the customer. See our returns policy for further details.