Microsoft Office Access 2007 Forms, Reports, and Queries, 2/e

Paul McFedries

  • 出版商: QUE
  • 出版日期: 2007-05-01
  • 售價: $1,430
  • 貴賓價: 9.5$1,359
  • 語言: 英文
  • 頁數: 408
  • 裝訂: Paperback
  • ISBN: 0789736691
  • ISBN-13: 9780789736697
  • 已過版




“Everything you need to master Access 2007 forms, reports, and queries.”

–Charles Carr, Reviews Editor, ComputorEdge Magazine


Create Forms for Business

Ensure Data Entry Accuracy

Build Elegant Form Interfaces

Collect Data Via Email

Design Effective Business Reports

Make an Invoice Report

Create Mailing Labels

Extract Data

Work with Multiple Tables

Calculate Discounts

Analyze Data


Develop your Microsoft Access expertise instantly with proven techniques


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 overworked IT people to provide canned reports or one-size-fits-all solutions.


This book changes all that by giving you the skills to build efficient front-ends for data (forms), publish the results in an attractive and easy-to-read format (reports), and extract the data you need (queries). This book shuns the big Access picture and instead focuses intently on forms, reports, and queries. This in-depth approach will give you the knowledge and understanding you need to get at the data and prove the old saw that knowledge is power.

·        Focuses on the three technologies that you must master to get the most out of Access: forms, reports, and queries.

·        Avoids database theory in favor of practical know-how that you can put to use right away.

·        Packed full of real-world examples and techniques to help you learn and understand the importance of each section.

·        Covers what’s new and changed in Microsoft Access 2007.

Table of Contents

Introduction 1

Part I: Creating Forms 5

Chapter 1    Creating and Using a Form 7

Chapter 2    Working with Form Controls 29

Chapter 3    Designing Forms for Efficient and Accurate Data Entry 49

Chapter 4    Designing Forms for Business Use 77

Chapter 5    Creating Specialized Forms 95

Part II: Designing and Customizing Reports 111

Chapter 6    Creating and Publishing a Report 113

Chapter 7    Designing Effective Business Reports 141

Chapter 8    Designing Advanced Reports 157

Chapter 9    Creating Specialized Reports 177

Part III: Creating Powerful Queries 197

Chapter 10  Creating a Basic Query 199

Chapter 11  Building Criteria Expressions 231

Chapter 12  Working with Multiple-Table Queries 259

Chapter 13  Creating Advanced Queries 287

Chapter 14  Creating PivotTable Queries 311

Chapter 15  Querying with SQL Statements 341


Index 361