Preface

Access really is an amazing product. Its power is vast, and yet its maintenance is low. In fact, in most installations it sits on the desktop and is maintenance-free. It's flexible enough to be used by one person or to run an entire company. It's a rapid application development (RAD) tool that outshines other such tools (such as Visual Basic) in time to development and ease of use.

Access is also a complete database application system. It incorporates both the back-end and front-end elements of a database, thereby eliminating the need to use two products to get your work done. Even so, its flexibility allows an Access database file to be just a back end or just a front end. Access can control data in external database systems such as SQL Server and Oracle.

Need I say more? I don't think you need any convincing to know what a great product Access is. Either you are using it already, or you are about to start. Well, here is some great news: this book is going to show you even more ways to use Access. Whether it's how to run Union queries, play video files in Access, view web sites within Access, or even control Access from another product, there are hacks here to tickle every fancy.

Access Hacks lets you move beyond the familiar tables, forms, and reports paradigm and get new insights into making your database applications more valuable and exciting. It's my pleasure to show you new ways to work with your favorite database product. So, fire up your computer, and let's get started!

Why Access Hacks?

The term hacking has a bad reputation in the press. They use it to refer to someone who breaks into systems or wreaks havoc with computers as their weapon. Among people who write code, though, the term hack refers to a "quick-and-dirty" solution to a problem, or a clever way to get something done. And the term hacker is taken very much as a compliment, referring to someone as being creative, having the technical chops to get things done. The Hacks series is an attempt to reclaim the word, document the good ways people are hacking, and pass the hacker ethic of creative participation on to the uninitiated. Seeing how others approach systems and problems is often the quickest way to learn about a new technology.

Get Access Hacks now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.