Access Hacks: Tips & Tools for Wrangling Your Data

Access Hacks: Tips & Tools for Wrangling Your Data

3.2 4
by Ken Bluttman
     
 

View All Available Formats & Editions

As part of the Microsoft Office suite, Access has become the industry's leading desktop database management program for organizing, accessing, and sharing information. But taking advantage of this product to build increasingly complex Access applications requires something more than your typical how-to book. What it calls for is Access Hacks from O'Reilly

Overview

As part of the Microsoft Office suite, Access has become the industry's leading desktop database management program for organizing, accessing, and sharing information. But taking advantage of this product to build increasingly complex Access applications requires something more than your typical how-to book. What it calls for is Access Hacks from O'Reilly.This valuable guide provides direct, hands-on solutions that can help relieve the frustrations felt by users struggling to master the program's various complexities. For experienced users, Access Hacks offers a unique collection of proven techniques and tools that enable them to take their database skills and productivity to the next level. For Access beginners, it helps them acquire a firm grasp of the program's most productive features.A smart collection of insider tips and tricks, Access Hacks covers all of the program's finer points. Among the multitude of topics addressed, it shows users how to:

  • work with Access in multi-user environments
  • utilize SQL queries
  • work with external data and programs
  • integrate Access with third-party products
Just imagine: a learning process without the angst. Well, Access Hacks delivers it with ease, thanks to these down-and-dirty techniques not collected together anywhere else.Part of O'Reilly's best-selling Hacks series, Access Hacks is based on author Ken Bluttman's two decades of real-world experience in database programming and business application building. It's because of his vast experiences that the book is able to offer such a deep understanding of the program's expanding possibilities.

Product Details

ISBN-13:
9780596552954
Publisher:
O'Reilly Media, Incorporated
Publication date:
04/17/2005
Series:
Hacks
Sold by:
Barnes & Noble
Format:
NOOK Book
Pages:
352
File size:
17 MB
Note:
This product may take a few minutes to download.

Meet the Author

Ken Bluttman has been working as a software developer for over 15 years. He works with many technologies, including Office/VBA, Visual Basic .NET, SQL Server, as well as ASP.NET and other Web goodies. He is the author of "Excel Formulas and Functions For Dummies, Access Hacks," and "Developing Microsoft Office Solutions."

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >

3.3 out of 5 based on 0 ratings. 4 reviews.
Anonymous More than 1 year ago
Not what I expected
Anonymous More than 1 year ago
Anonymous More than 1 year ago
Guest More than 1 year ago
Microsft Access is a little of a strange beast. From the vantage of a SQL user, it is a dumbed down SQL implementation. But it has a very nice GUI that pure SQL engines like SQL Server or DB2 lack. So most of the hacks in the book relate to GUI issues. But a minority pertain to the SQL limitations, compared to SQL Server. Access cannot make an outer join, for example. But hack 53 provides a workaround, just in case you need to do so. Another group of hacks illustrate how Access can be used in combination with Microsoft Office. Microsoft has cleverly provided ways for Access users to integrate their tasks with Word and Excel. In one case, Excel can reorient your Access data. Or, more broadly, many of Excel's functions can be used within Access. These methods key off Microsoft's strengths in a mature Office suite.