|
Brilliant Access Forms, Reports & Queries
Brilliant Access 2007 Forms, Reports & Queries
What you need to know and how to do it
Access is one of the most powerful office and business productivity tools available - but do you know how to harness its full potential? Do you want to get a better understanding of its full capabilities and potential, and develop the Access
skills that you need to produce solutions to all of your business needs? Brilliant Access 2007 Forms, Reports & Queries will deliver increased office productivity and improved results by unleashing your inner Access expert! This book is for the savvy Access user who wants to understand and then use the advanced features of Access but doesn't want to dedicate their life to it.
Develop your Access 2007 expertise instantly with proven techniques
Let's face it - Microsoft Access 2007 is a large, intimidating program. Most people using it, even on a daily basis,never progress beyond creating simple tables and using wizards to build basic forms and reports. At the same time, most users need to access, manipulate and organize information, and know that what they are looking for is embedded somewhere in their Access database. Without a more sophisticated knowledge of how to extract and present that data, most users are forced to rely on in-house office "gurus", unwieldy and no-user friendly manuals and overworked IT people to provide canned reports or one-size-fits-all solutions.
This book changes all that by giving users 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 that they need (queries). This book shuns the big Access picture and instead focuses intently on forms, reports, and queries. This in-depth approach provides the knowledge and understanding needed to get at data and prove the old saw that knowledge is power.
Brilliant Access 2007 Forms, Reports & Queries
* Focuses on the three technologies that need mastering to get the most out of Access: forms, reports, and queries.
* Avoids database theory in favor of practical know-how that can be put to use right away.
* Packed full of real-world examples and techniques to help the reader learn and understand the importance of each section.
* Covers what's new and changed in Microsoft Access 2007.
Paul McFedries is well-known as a teacher of Windows and Office, particularly Excel, and is the president of Logophilia Limited, a technical writing company. Paul has been working with spreadsheets for more than 20 years and has been developing Excel solutions since the late 1980s. Now primarily a writer, Paul has written more than 50 books that have sold more than three million copies worldwide. These books include Brilliant Access 2007 Forms, Reports, and Queries; Brilliant Office 2007 Tips and Tricks; and Microsoft Windows Vista Unleashed.
Visit us on the web at
www.pearson-books.com
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
|
