Welcome to the home page of Microsoft Office Access 2007 Forms, Reports, and Queries! Microsoft Access is a large, intimidating program. Unlike Word or Excel, where you can perform basic tasks without much in the way of training, Access presents challenges from the outset. Most users never progress beyond creating simple tables and using wizards to create basic forms and reports. At the same time, all users — from managers to researchers to administrative assistants — need information and know that what they seek is embedded somewhere in their Access tables. Without a more sophisticated knowledge of how to extract and present that data, they are forced to rely on office gurus and overworked IT people to provide canned reports or one-size-fits-all solutions.
This book will change all that by giving you the skills required to extract the data you need (queries), build efficient front-ends for that data (forms), and publish the results in an attractive and easy-to-read format (reports). To that end, this book shuns the big Access picture and instead focuses intently on queries, forms, and reports. This in-depth approach gives you the skills and understanding you need to get at the data and prove the old saying that knowledge is indeed power. And this book does all that with no-nonsense, step-by-step tutorials and lots of practical, useful examples aimed directly at business users.
Even if you've never been able to get Access to do much beyond storing data in simple tables, you'll still find this book to your liking. I show you how to build useful, powerful queries, forms, and reports from the ground up, so no experience with these aspects of Access is necessary.
Please click freely on the links below to learn more about the book. (For some of the links you'll need a program that can open PDF files, such as Adobe Reader.)
 |
Table of Contents |
| Want to know what's in the book? Check out the Table of Contents, which includes the Contents at a Glance (just the chapters) as well as the complete contents of each chapter. |
| |
Introduction |
| Want to know more about the book? Check out the Introduction, which tells you why I wrote the book and who I wrote it for, and also gives you an overview of the book's content and features. |
| |
Sample Chapter |
| Want to take the book for a test drive? Read the full text of Chapter 3, "Designing Forms for Efficient and Accurate Data Entry," which offers a number of useful techniques for designing Access 2007 forms to ensure fast and accurate data entry. |
| |
Index |
| Want to know whether the book covers a specific topic? No problem. Check out the detailed Index, which lists every last topic that I cover in the book. |
 |
Example Files |
| Want to download the example databases that I use in the book? Sure! I've crammed everything into examples.zip, a compressed file that includes both Northwind 2003.accdb and Northwind 2007.accdb. |
 |
Forum |
| Want to ask a question about the book or let the world know what you thought of it? Have your say in The Dialogue Box. | |