Access 2007

Access 2003 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 2003 or 2002 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 2003, 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 2007 development team. In this book, he shares his experience and provides templates to create tracking applications incorporating the rich user interface of Access 2007. In particular, the design, creation and sharing of Access 2007 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 2007 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.

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.

Books for Microsoft Visual Basic 6.0