Expert Access 2007 Programming shows experienced developers how to create professional-level Access database applications. The authors--software engineers on the Access development team at Microsoft--show how to apply software engineering methodologies to Access application development. The book is organized to cover all phases of Access development.

The authors demonstrate techniques for creating Access controls, forms, and reports that help streamline development and produce more ...

Build a highly responsive a database so you can track, report, and share information and make more informed decisions. This comprehensive resource shows you how to design and develop custom Access 2007 databases--even if you have little or no programming experience. You'll learn to collect data from a variety of sources, share it securely with others, and integrate it with other Office applications.

Filled with detailed, eas...

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

Transfer Access data seamlessly between Microsoft Office applications—and that's just for starters! In this all-new, comprehensive guide by well-known Access expert Helen Feddema, you'll learn to write Visual Basic® code that automates Access database tasks, creates standalone scripts, extracts and merges data, and allows you to put together powerful solutions that increase your efficiency across the Office family. Whether you're a beginner or...

If you want to take your Access databases to a more robust level of functionality, then this is the book for you. It provides the tools and techniques you'll need in order to build more sophisticated solutions. You'll find plenty of source code and fully developed sample applications to guide you along the way.

After walking through the features of Access 2007 VBA, you'll learn all about object-oriented programming and ADO. You'll then progress to advanced VBA concepts such as workin...

Pro Access 2007 covers the new features of Microsoft Access 2007, including working with SharePoint Office Server and customizing Ribbons. The book is aimed at professional developers and power users who are new to Access 2007. Among other topics, you'll learn about the new Access menu structure, including customization, as well as new SharePoint features.

This book provides good, short, solid information with as little waffle as possible. And the book includes solid examples that t...

Let’s face it: Microsoft Access is a large, intimidating program. Most people never progress beyond creating simple tables and using wizards to build basic forms and reports. At the same time, you need information and you know that what you seek is embedded somewhere in your Access database. Without a more sophisticated knowledge of how to extract and present that data, you’re forced to rely on office gurus and ove...