Book Recommendations

Microsoft Access Small Business Solutions

by Teresa Hennig, Truitt Bradly, Larry Linson, Leigh Purvis, and Brent Spaulding
Foreword by Luke Chung

Written by our friend Teresa who is an Access MVP and president of the Pacific Northwest Access Developer Group and the Seattle Access Group. She is the lead author of the Access VBA Programmer's Reference series and is a lead on three national committees for INETA. Her company, Data Dynamics Northwest, provides data management solutions and consulting services.

Teresa's book shows how to take control with database models developed by a team of leading Microsoft Access MVPs that provide ready-to-use solutions for sales, marketing, customer management and other key business activities for most small businesses. As the most popular relational database in the world, Microsoft Access is widely used by small business owners. This book responds to the growing need for resources that help business managers and end users design and build effective Access database solutions for specific business functions.

Professional Access 2013 Programming

by Teresa Hennig, Ben Clothier, George Hepworth, and Dagi (Doug) Yudovich

This is a complete guide on the latest tools and techniques for building Access 2013 applications for both the web and the desktop so that developers and businesses can move forward with confidence. Whether you want to expand your expertise with Client/Server deployments or start developing web apps, you will want this book as a companion and reference.

Therea starts with the fundamentals of the new Access 2013 web app and then takes you step by step through building a robust application. Examples and techniques are provided to create and deploy professional solutions for both traditional and web applications. It demonstrates how to automate other programs using macros, VBA, API calls, and more. Techniques are shared for using macros to create solutions that will run in a web browser and perform tasks on SQL Server®. Special emphasis is placed on creating cost-effective solutions based on real-work scenarios.

Access 2013 Absolute Beginner's Guide

by Alison Balter

Friendly, direct, and patient, this book reveals Access 2013's power, and helps you quickly master its updated interface. World-renowned Access tutorial author Alison Balter provides step-by-step instructions for every task requiring more than one step. She presents screenshots guiding you through complex processes, and illustrations demonstrating the touch gestures you need to run Access on the latest tablets and Windows 8 devices. Along the way, she covers key Access 2013 improvements that make it easier to build web-based apps and SharePoint-integrated database solutions that are consistent, manageable, flexible, and exceptionally usable.

Microsoft Access 2010 Programmer's Reference

by Teresa Hennig, Rob Cooper, Geoffrey Griffith, and Jerry Dennison

Another great book written by Teresa. This is a comprehensive guide to programming for Access 2010 and 2007. With in-depth coverage of VBA, macros, and other programming methods for building Access applications, this book also provides real-world code examples to demonstrate each topic. Access 2010 Programmer's References a comprehensive guide to the best-of-breed techniques for programming Access applications.

Microsoft Access VBA: Programmer's Reference  (Contributions from FMS's Steve Clark)

by Teresa Hennig, Rob Cooper, Geoffrey L. Griffith, and Armen Stein

This book shows you how to take control of Access using VBA. You’ll learn to create and name variables, use DAO and ADO to manipulate data, handle errors correctly, create classes and use APIs, and more. An entire chapter is devoted to the changes in Access, including new wizards and GUI features that previously required VBA code as well as new VBA features. You will discover how to access data with VBA, execute and debug VBA code, and use VBA with Access objects. Finally, you will learn more about the relationship between Access and SQL Server, and how to use VBA in Access to control and enhance other Office applications.

2007 Version

2003 Version

The Rational Guide to Microsoft Office Access 2007 Templates

by Zac Woodall, Microsoft Corporation

Our friend Zac Woodall is a Program Manager and lead developer on the Microsoft Access development team. In this book, he shares his experience and provides templates to create tracking applications incorporating the rich user interface of MS Access. In particular, the design, creation and sharing of Access templates.

Topics include customization, personalization, branding, and working with SharePoint. Advanced topics include template file anatomy, template collections, enterprise templates, generating templates without running Access, and integrating templates with add-ins.

The book includes sample code, sample templates, and a bonus chapter on how to install and use .accfl field template XML files to customize the Access Field Templates task pane. Learn from one of the best Access experts.

More info

Real World Microsoft Access Database Protection and Security

by Garry Robinson

This book focuses on issues that help protect your database. Written from an experienced developer's point of view, the author discusses protection and security task-by-task. This book is even recommended among Microsoft TechNet Security Topics: Threats and Countermeasures.

You will learn to hide tables as system tables, produce databases difficult to crack, and back up databases. You will learn how to keep staff from viewing salary tables, prevent customers from peeking at your distributed software design, and become a better judge of worthwhile security options (versus time-consuming choices).

Microsoft Access Developer's Guide to SQL Server

by Mary Chipman, Andy Baron

Microsoft Access Developer's Guide to Microsoft SQL Server provides much needed information and guidance for the Access power user or developer who wants to exploit the power of SQL Server. Written by Access experts and Microsoft MVPs Mary Chipman and Andy Baron, this hands-on guide provides you with the practical knowledge you need to harness the enterprise-level power and scalability SQL Server offers, while using the Access tools you are familiar with. More than just a migration guide, you will benefit from the authors' expert discussions of topics including the new Microsoft Database Engine (MSDE), Transact SQL, building stored procedures and views, converting your applications to SQL Server, working with SQL Server security, and building Access interfaces to SQL Server databases.

Microsoft Access 2003 : Your visual blueprint for creating and maintaining real-world databases

by F. Scott Barker

This is the only guidebook series that takes a visual approach to professional-level computer topics. You will discover step-by-step screen shots that demonstrate over 140-key techniques to help you make the most of Access 2003, including: building charts and graphs, setting up database relationships, writing and using classes, managing databases, and more ...

Microsoft Jet Database Engine Programmer's Guide

by Dan Haught and Jim Ferguson

This is the official technical reference on Microsoft Jet, the powerful database engine used in Microsoft Access and Microsoft Visual Basic. If you write code that creates and manipulates a database in one of these products, you can easily use that same code in the other, or use both products together to create custom database applications. You'll learn what Jet is, how to use it, and how it compares to other database engines. Each chapter includes a simple Visual Basic program that is built upon to illustrate points throughout the discussion.

Microsoft SQL Server Unleashed (2nd Edition)

by Ray Rankins, Paul Bertucci, Chris Gallelli, Alex T. Silverstein

Microsoft SQL Server Unleashed offers a variety of topics for system and database administrators to help them learn new features of the product and to solve problems they face on a daily basis. It shows them how to build upon their working knowledge of the product and take their experience and knowledge to a higher level. This new edition of Microsoft SQL Server Unleashed covers the latest updates and service packs to SQL Server 2000 or 2005, including full support for XML, notification services, and SQL Server CE.

Professional SQL Server Programming

by Rob Vieira

In addition to providing a thorough treatment of SQL Server 2000 development, Rob Vieira's extensive reference also devotes quite a lot of space to covering SQL in general and issues relating to database design. Included is a complete introduction to Transact-SQL and an excellent chapter on normalization that will help demystify an over-referenced but much misunderstood database design concept. There is also in-depth information on the new features of SQL Server 2000, including indexed views, user-defined functions, and support of XML.

Microsoft ADO.NET (Core Reference)

by David Sceppa

This core reference demonstrates how to use ActiveX Data Objects.NET (ADO.NET) to access, sort, and manipulate data in enterprise-wide, Web-enabled applications. Readers learn best practices for writing, testing, and debugging database application code using the new tools and wizards in Microsoft Visual Studio .NET-with code on a companion CD, plus insider tips. The book also describes the ADO .NET object model, its XML features for Web extensibility, integration with Microsoft SQL Server 2000, and more.

Professional UML with Visual Studio .NET

by Tony Loton, Kevin McNeish, Andrew Filev, Ben Schoellmann

If you want to use Visio to create enterprise software, this is the book for you. The integration of Visual Studio .NET Enterprise Architect and Visio for Enterprise Architects provides a formidable combination. Visio offers powerful diagramming capabilities, including such things as creating UML models, mapping out databases with Entity Relationship diagrams, and aiding the development of distributed systems. Its integration with Visual Studio .NET Enterprise Architect means that C# or Visual Basic .NET code can be generated from the UML diagrams, and Visual Studio .NET projects can be reverse engineered to UML models. For the developer already familiar with UML and looking to get the best out of Visio, the Visual Studio .NET and Visio for Enterprise Architects combination is weakly documented, and the quality information needed to realize the time-saving features of Visio just doesn't seem to be available, until now. This book presumes that you are already familiar with the basic concepts of UML notation - this book will not teach you UML. Instead, this book will take you forward into the Visio environment, showing you how to make the most of its software-related features.

Refactoring: Improving the Design of Existing Code

by Martin Fowler, Kent Beck (Contributor), John Brant (Contributor), William Opdyke, Don Roberts

Your class library works, but could it be better? Refactoring: Improving the Design of Existing Code shows how refactoring can make object-oriented code simpler and easier to maintain. Today refactoring requires considerable design know-how, but once tools become available, all programmers should be able to improve their code using refactoring techniques.

Besides an introduction to refactoring, this handbook provides a catalog of dozens of tips for improving code. The best thing about Refactoring is its remarkably clear presentation, along with excellent nuts-and-bolts advice, from object expert Martin Fowler. The author is also an authority on software patterns and UML, and this experience helps make this a better book, one that should be immediately accessible to any intermediate or advanced object-oriented developer.

Shared Source CLI Essentials

by David Stutz, Ted Neward, Geoff Shilling

Microsoft's Shared Source CLI (code-named "Rotor") is the publicly available implementation of the ECMA Common Language Infrastructure (CLI) and the ECMA C# language specification. Loaded with three million lines of source code, it presents a wealth of programming language technology that targets developers interested in the internal workings of the Microsoft .net Framework, academics working with advanced compiler technology, and people developing their own CLI implementations. The CLI, at its heart, is an approach to building software that enables code from many independent sources to co-exist and interoperate safely.

Shared Source CLI Essentials is a companion guide to Rotor's code. This concise and insightful volume provides a road map for anyone wishing to navigate, understand, or alter the Shared Source CLI code. This book illustrates the design principles used in the CLI standard and discusses the complexities involved when building virtual machines. Included with the book is a CD-ROM that contains all the source code and files.

Programming Microsoft Visual Basic .NET (Core Reference)

by Francesco Balena

Useful for VB developers of all levels, Programming Microsoft Visual Basic .NET offers a massive and comprehensive guide to the new VB .NET. While concentrating on "traditional" programming techniques brought up to speed with .NET, this book also covers essential Web development, making it a solid choice for those making the leap from VB 6.

Mastering Visual C# .NET

by Jason Price, Mike Gunderloy

C# is Microsoft's brand-new object-oriented language for the .NET platform, designed to make it easy for developers to create Web applications. Mastering Visual C# .NET is aimed at experienced C++, Visual Basic, and Java programmers who want a comprehensive resource to Visual C#. It delivers complete coverage of the essentials of the C# language, plus writing Windows and web applications. Topics include using the .NET base class library for basic programming operations like I/O and threads; database programming with ADO.NET; Web programming with ASP.NET; and creating XML Web Services. There is also a chapter on programming security with C#, including permissions and encryption. Author Jason Price has more than ten years' experience in the software industry and has worked with C#, .NET, Java, and Oracle. Coauthor Mike Gunderloy has written numerous books on Microsoft programming topics for Sybex, including ADO and ADO.NET Programming and .NET E-Commerce Programming.

ASP.NET Developer's JumpStart

by Paul D. Sheriff, Ken Getz

The purpose of ASP.NET JumpStart is to show readers the practical applications of .NET and ASP.NET by illustrating how to build Web-based applications using Web Forms and Web Services. Emphasis will be on good programming standards and practices. The reader will be taken from an introduction of the VB .NET language to intermediate topics through a step-by-step approach, which gives the reader the opportunity to try out the practices presented in each chapter.

Professional ASP.NET Server Controls: Building Custom Controls w/ C#

by Matt Butler, Thiru Thangarathinam, Matt Milner, Michael Clark, Ryan O'Keefe, Angelo Kastroulis, Jan Narkiewicz, Daniel Cazzulino

This book is designed to be a complete reference on how to create Custom Server Controls using C#. In essence, it's a definitive guide to what they're used for, how they are created, and the benefits that they can provide. The first part of the book will be concentrating on the code itself, and is designed to be editor-neutral, concentrating on the raw code involved in creating controls and making use of these controls. The second part of the book will have more coverage of visual designers like Visual Studio .NET, talking about why using IDEs is so helpful, and examining the powerful features of Visual Studio .NET that are useful when creating custom controls.

Database Developer's Guide with Visual Basic 6 (Technical Editor: FMS's Jim Ferguson)

by Roger Jennings

A perennial best-selling title for VB Database application, this is a "must buy" for all serious VB developers. The book has been completely updated for the latest release of VB, ActiveX controls, Microsoft's new Internet database technologies, and Microsoft's newest client server technology: Microsoft Transaction Server. The CD features source code and demonstration databases.

Hitchhiker's Guide to Visual Basic and SQL Server (Technical Editor: FMS's Jim Ferguson)

by William R. Vaughn

A hands-on resource for developers, development managers in medium-sized to large MIS development shops, and everyone else who wants to use Visual Basic to tap the power of SQL Server. The enclosed CD-ROM contains sample code from the book, a sample database, code "building blocks" for users' own applications, white papers, and more.

Focusing on Visual Basic 6's data-access resources, this is the definitive guide to Microsoft's database development tools. If you're concerned with creating a way for a Visual Basic application or control to talk to an SQL Server back end, this book most likely has the answers you need.

Understanding and Using Networks for Law Practice Development (chapter written by FMS's Dan Wasser)

by Ginsburg, Krishnan, Levey, McLean, Pierce, Pomfret, FMS's Dan Wasser
Publisher: American Law Institute - American Bar Association (ALI-ABA)

Law firm networks are organizations consisting of independent law firms. These networks offer member firms the opportunity to increase referrals among members, exchange information with lawyers throughout the world, and better serve clients. The network headquarters typically serves as the central hub that links the members and distributes information and referrals among member firms. Networks offer lawyers and potential clients alternatives to establishing multiple offices or joining global firms. By offering members the opportunity to collaborate with multiple firms while preserving their independence, law firm networks continue to expand.

Sample of Dan Wasser's chapter on Visualizing Networks for Practice Development and Case Management and how Sentinel Visualizer helps find hidden relationships among people, places and events.