Microsoft Excel 2003 Programming Inside Out

By Curtis Frye, Wayne S. Freeze, Felicia K. Buckingham
700 pages
Publisher: Microsoft Press; Pap/Cdr edition (November 12, 2003)
ISBN-10: 0735619859
ISBN-13: 978-0735619852

Book Description

Dig in-and discover how to put the built-in programming power in Excel 2003 to work! This supremely organized reference packs all the information you need to automate spreadsheets, write your own functions and procedures, and create other custom business solutions. Its all muscle and no fluff. Topics include programming with Microsoft Visual Basic® for Applications (VBA), using the Excel object model, manipulating and customizing Excel objects, exploiting new XML capabilities, and integrating Excel functions with other Microsoft Office programs and the Web. Youll gain hundreds of timesaving solutions, tips, and workarounds in concise, fast-answer format. Plus, youll get sample code; a trial version of "Spreadsheet Assistant," a popular third-party tool; a complete eBook; a catalog of Excel resources; demos; and more on CD. With INSIDE OUT, youll discover the best and fastest ways to perform everyday programming tasks with Excel-and challenge yourself to new levels of mastery!

Key Book Benefits:

• Discover the best and fastest ways to build custom business solutions with Excel, and challenge yourself to new levels of mastery!
• Get a comprehensive programming reference and tutorial-but no fluff-in a single volume.
• Learn to program with VBA and explore the Excel object model.
• Customize and manipulate any Excel objects.
• Integrate Excel with other Office applications, the Web, and ADO.
• CD-ROM features complete eBook; code samples; and other productivity resources.

Download Microsoft Excel 2003 Programming Inside Out

Read More..

Microsoft Office Access 2007 The Complete Reference

Complete Reference Series
By Virginia Andersen 
775 pages
McGraw-Hill Osborne Media; 1 edition (January 26, 2007)
ISBN-10: 0072263504
ISBN-13: 978-0072263503

Book Description

The Ultimate Microsoft Office Access 2007 Resource

Build a highly responsive a database so you can track, report, and share information and make more informed decisions. This comprehensive resource shows you how to design and develop custom Access 2007 databases--even if you have little or no programming experience. Youll learn to collect data from a variety of sources, share it securely with others, and integrate it with other Office applications.

Filled with detailed, easy-to-follow instructions, Microsoft Office Access 2007: The Complete Reference shows you how to take full advantage of all the new features, including the new ribbon user interface and navigation pane, new field types, and more. Create a reliable and versatile information management solution with help from this all-inclusive guide. As a bonus, you can gain hands-on experience by following along with the books sample databases on the CD-ROM.

* Customize the user interface to suit your preferences
* Use the built-in database templates or design your own
* Create, modify, and relate tables
* Enter and edit data
* Write advanced queries to extract and manipulate information
*Create customized forms and reports
*Improve performance and back up your database
*Develop macros to carry out automated responses to user actions
*Import, link, and export data
*Enable a multiple-user environment
*Secure your database

Download Microsoft Office Access 2007: The Complete Reference

Read More..