×

Uh-oh, it looks like your Internet Explorer is out of date.

For a better shopping experience, please upgrade now.

Access Hacks
     

Access Hacks

3.2 4
by Ken Bluttman, Bluttman Ken
 

See All 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

Customer Reviews

Average Review:

Post 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.