Absolutely Australia's Lowest Prices

Sell Your Old Stuff for Cash. It's Easy & Free to List. Get Started Now.

Microsoft(r) Access(r) 2010 Programming by Example

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; and, query and manipulate your database from a Web browser with Active Server Pages (ASP) and many more practical techniques. There are thirty-two chapters loaded with illustrated hands-on projects and exercises that demonstrate programming concepts. Each exercise/project tells you exactly where to enter code and how to debug it and then run it. This title includes a comprehensive CD-ROM with tips, shortcuts, and tutorials. It is updated for Access 2010 and based on the bestselling editions from previous versions. Store data for further manipulation in variables, arrays, and collections, write simple and complex VBA programming routines and functions. Create custom database forms, reports, and details on controlling and customizing the Ribbon. Use DAO and ADO methods to access and manipulate database records (insert, update, and delete data via code), work with Access database files in.MDB and.ACCDB formats. Use external data sources with Access (SQL Server, flat files, Excel, Word, and XML) and generate dynamic XML and ASP documents from any Access database and display data on the Web.
Product Details

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 a dozen computer books including Microsoft Excel 2010 with VBA, XML and ASP (Mercury Learning). She lives on Long Island, New York.


This practical how-to manual for programming in Access 2010 using VBA XML and ASP introduces concepts with multi-step, illustrated, and hands-on exercises with 275 applied examples and 10 projects designed to let the reader quickly build solutions using Data Access Objects (DAO), ActiveX Data Objects (ADO) and SQL. 33 chapters progressively introduce concepts that build on skills used in previous chapters to use both the latest version of Access as well as earlier versions to integrate Access with web displays, import data and to write and debug queries, routines and functions. Other topics include templates, macros and customizing interfaces. The guide includes a CD-ROM with source code and supplemental files for projects.

How Fishpond Works
Fishpond works with suppliers all over the world to bring you a huge selection of products, really great prices, and delivery included on over 25 million products that we sell. We do our best every day to make Fishpond an awesome place for customers to shop and get what they want — all at the best prices online.
Webmasters, Bloggers & Website Owners
You can earn a 5% commission by selling Microsoft(r) Access(r) 2010 Programming by Example: With VBA, XML, and ASP on your website. It's easy to get started - we will give you example code. After you're set-up, your website can earn you money while you work, play or even sleep! You should start right now!
Authors / Publishers
Are you the Author or Publisher of a book? Or the manufacturer of one of the millions of products that we sell. You can improve sales and grow your revenue by submitting additional information on this title. The better the information we have about a product, the more we will sell!
Item ships from and is sold by Fishpond.com, Inc.
Back to top