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.
"synopsis" may belong to another edition of this title.
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.
"About this title" may belong to another edition of this title.
Seller: World of Books (was SecondSale), Montgomery, IL, U.S.A.
Paperback. Condition: Very Good. Offers an introduction to VBA programming, manipulating databases with ADO, using DDL, event programming, and using ASP and XML. This text shows 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; and, more. Seller Inventory # 00110083331
Seller: World of Books (was SecondSale), Montgomery, IL, U.S.A.
Paperback. Condition: Fair. Offers an introduction to VBA programming, manipulating databases with ADO, using DDL, event programming, and using ASP and XML. This text shows 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; and, more. Seller Inventory # 00102315821
Seller: ThriftBooks-Dallas, Dallas, TX, U.S.A.
Paperback. Condition: Good. No Jacket. Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, Spend Less. Seller Inventory # G1936420023I3N00
Seller: Better World Books: West, Reno, NV, U.S.A.
Condition: Good. Pages intact with minimal writing/highlighting. The binding may be loose and creased. Dust jackets/supplements are not included. Stock photo provided. Product includes identifying sticker. Better World Books: Buy Books. Do Good. Seller Inventory # 17390107-6
Seller: Better World Books, Mishawaka, IN, U.S.A.
Condition: Very Good. Former library copy. Pages intact with possible writing/highlighting. Binding strong with minor wear. Dust jackets/supplements may not be included. Includes library markings. Stock photo provided. Product includes identifying sticker. Better World Books: Buy Books. Do Good. Seller Inventory # GRP88246195
Seller: Better World Books, Mishawaka, IN, U.S.A.
Condition: Good. Former library copy. Pages intact with minimal writing/highlighting. The binding may be loose and creased. Dust jackets/supplements are not included. Includes library markings. Stock photo provided. Product includes identifying sticker. Better World Books: Buy Books. Do Good. Seller Inventory # 13053057-75
Seller: Phatpocket Limited, Waltham Abbey, HERTS, United Kingdom
Condition: Good. Your purchase helps support Sri Lankan Children's Charity 'The Rainbow Centre'. Ex-library, so some stamps and wear, but in good overall condition. Our donations to The Rainbow Centre have helped provide an education and a safe haven to hundreds of children who live in appalling conditions. Seller Inventory # Z1-G-008-02003
Quantity: 1 available
Seller: Hay-on-Wye Booksellers, Hay-on-Wye, HEREF, United Kingdom
Condition: Very Good. Unused, some outer edges and corners have scuffs, cover has scratches, book content is in like new condition. Seller Inventory # 087182-21
Quantity: 1 available
Seller: Hay-on-Wye Booksellers, Hay-on-Wye, HEREF, United Kingdom
Condition: Fine. Unused, some outer edges have minor scuffs, cover has light scratches, book content is in like new condition. Seller Inventory # 105929-6
Quantity: 1 available
Seller: Hay-on-Wye Booksellers, Hay-on-Wye, HEREF, United Kingdom
Condition: As New. Seller Inventory # HP-100253
Quantity: 1 available