If you have large quantities of data in a Microsoft Access database, and need to study that data in depth, this book is a data cruncher's dream. Access Data Analysis Cookbook offers practical recipes to solve a variety of common problems that users have with extracting Access data and performing calculations on it. Each recipe includes a discussion on how and why the solution works. Whether you use Access 2007 or an earlier version, this book will teach you new methods to query data, different ways to move data in and out of Access, how to calculate answers to financial and investment issues, and more. Learn how to apply statistics to summarize business information, how to jump beyond Sql by manipulating data with Vba, how to process dates and times, and even how to reach into the Excel data analysis toolkit. Recipes demonstrate ways to: Develop basic and sophisticated queries Apply aggregate functions, custom functions, regular expressions, and crosstabs Apply queries to perform non-passive activities such as inserting, updating, and deleting data Create and manipulate tables and queries programmatically Manage text-based data, including methods to isolate parts of a string and ways to work with numbers that are stored as text Use arrays, read and write to the Windows registry, encrypt data, and use transaction processing Use the FileSystemObject, use Xml with Xslt, communicate with Sql Server, and exchange data with other Office products Find answers from time-based data, such as how to add time, count elapsed time, work with leap years, and how to manage time zones in your calculations Deal with business and finance problems, including methods for calculating depreciation, loan paybacks, and Return on Investment (Roi) Explore statistical techniques, such as frequency, variance, kurtosis, linear regression, combinations and permutations Access Data Analysis Cookbook is a one-stop-shop for extracting nuggets of

Access Data Analysis Cookbook: Slicing and Dicing to Find the Results You Need

Computers & Technology

Freeze, Wayne S.

Bluttman, Ken

Operating Systems

O'Reilly Media

You’re a sophisticated user of Excel—a real pro with spreadsheets—so now dig into its powerful programming capabilities and really put your data to work! From writing code in Microsoft Visual Basic for Applications (VBA) to taking advantage of new XML data-sharing features, this book packs hundreds of timesaving programming solutions, troubleshooting tips, and handy workarounds all in concise, fast-answer format. Discover the best and fastest ways to build custom business solutions with Excel—and challenge yourself to new levels of mastery! <ul>
<li>From automating simple tasks to building custom solutions, write better code with VBA</li> <li>Learn best practices for writing and debugging your own macros</li> <li>Use VBA code to manage dates and times, reformat worksheets, and locate external files</li> <li>Extend your Excel solutions by developing your own add-ins</li> <li>Get powerful perspectives on data by programmatically manipulating PivotTable and PivotChart dynamic views</li> <li>Create custom command bars, dialog boxes, and user forms</li> <li>Employ ActiveX Data Objects (ADO) to access external databases</li> <li>Exploit the new XML capabilities in Excel 2003</li> </ul>
CD features: <ul>
<li>Complete eBook in PDF format</li> <li>Insider Extras—including all the authors’ sample files and code</li> <li>Catalog of Excel resources with links to third-party tools and demos</li> <li>Microsoft resources and demos, including Insider’s Guide to Microsoft Office OneNote 2003 eBook</li> <li>FREE! Microsoft Computer Dictionary, Fifth Edition, eBook—10,000+ entries</li> </ul>
For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.

Microsoft® Office Excel 2003 Programming Inside Out

Frye, Curtis

Buckingham, Felicia K.

Software

Microsoft Press

Built-in Internet functions are no longer a luxury. You have to keep your programming fresh and innovative to stay competitive. From file transfers to email to writing HTML documents, the controls you need are in this professional guide.

Leveraging Visual Basic With Activex Controls

Web Development & Design

Premier Pr

This is a SQL Server tutorial aimed at improving decision making and simplifying business processes with Microsoft's SQL Server 7 and Visual Basic 6. It includes comprehensive coverage of VB6 in business and on the Web using high-performance solutions presented in a practical, hands-on manner.

Hands on SQL Server 7 With Vb6

Programming

There's so much information inside your database, but how do you get at it and use it successfully? With this guide to Online Analytical Processing (OLAP) tools, you can forego programming and custom data warehousing and tap into the power of Microsoft SQL Server technology. You can build your own data warehouse using the Enterprise Manager tool in SQL Server and pull out what you need using SQL Server Query Analyzer and English Query tools. What's more, Excel 2000, in tandem with these tools, serves up your data in multidimensional, mission-specific reports. 
The CD-ROM includes extensive sample databases and an evaluation edition of Microsoft SQL Server 7.0.

Unlocking OLAP with Microsoft SQL Server and Excel 2000

Computer Science

wiley

Explains how to design and build a wide range of client/server and web-based database applications using Visual Basic 6.0, ActiveX Data Objects 2.5, and SQL Server 7.0, in a handbook that features helpful tutorials, step-by-step directions, code amples, and practice applications. Original. (Intermediate)

Visual Basic 6 Database Programming Bible

Networking & Cloud Computing

John Wiley&Sons, Inc.

Here is the Ultimate Visual Basic "secrets" book--written by a recognized authority! Learn the tricks that turn programmers into gurus; journey far beyond documentation. Advanced Win32 and registry sections lets programmers integrate VB 6's newest features with Windows; Internet sections show VB programmers how to build IIS apps, integrate Transaction Server, FTP and Winsock with their existing VB apps, and create Active Server pages. VBscript coverage shows how to use the Windows 98 Scripting Host with existing VB apps. The CD includes custom applications, source code, ready-to-run examples of advanced VB applets and applications, and a dozen third-party controls and applications for the hardcore VB programmer.

Expert Guide to Visual Basic 6

Programming Languages

Sybex, Inc.

COM (Component Object Model) is Microsoft's standard for building enterprise applications that can be run over the network or the Internet. COM+ is an enhanced version of the standard for Windows 2000. This book gives experienced Visual Basic developers everything they need in order to develop sophisticated applications that take advantage of what COM has to offer. Up to now, COM has been a mysterious topic for VB programmers, but Wayne Freeze (author of Sybex's Expert Guide to Visual Basic 6) makes the topic understandable through practical examples.

Visual Basic Developer's Guide to COM and COM+

Windows Game Programming with Visual Basic and DirectX is the only game programming book on the market that pairs the ease of Visual Basic with the power and flash of DirectX applications. The book is written to teach the skills and thoughts behind game programming, with hands-on examples and a simulation game project that results in a complete application at the end of the book. Topics such as artificial intelligence, animation, sound effects, background music, and multiplayer setups will be covered in detail and put to work in the hands-on game project.

Windows Game Programming with Visual Basic and DirectX

Games & Strategy Guides

Covers all editions of Visual Basic 5. Addresses all Visual Basic language statements, controls and other language aspects, fully documented. Contains encyclopedic format with thumb tabs for easy-to-access referencing. Is written by a Visual Basic programmer for Visual Basic programmers.

The Visual Basic 5 Programmer's Reference: Windows 95/Nt

Ventana Pr

See the best price to sell, buy, or rent books by Freeze, Wayne S.. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Books by Freeze, Wayne S.