Brilliant Microsoft Access

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, most users need to access, manipulate and organise 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 non-user friendly manuals and overworked IT people to provide canned reports or one-size-fits-all solutions. http://www.dropshippers.co.za/

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. Throughout the book there are no-nonsense, step-by-step tutorials and lots of practical examples aimed directly at business users. http://www.dropshippers.co.za/

About the Author

Paul McFedries http://www.dropshippers.co.za/

is well-known as a teacher of Windows and Office, particularly Excel, and is the president of Logophilia Limited, a technical writing company. Now primarily a writer, Paul has written more than 50 books that have sold more than three million copies worldwide. These books include Microsoft Office Excel 2007 Pivot Tables; Tricks of the Microsoft Office 2007 Gurus (all from Que); and Microsoft Windows Vista Unleashed (Sams). http://www.dropshippers.co.za/

Table of Contents

Introduction

Part I: Creating Forms

• Chapter 1 Creating and Using a Form
• Chapter 2 Working with Form Controls
• Chapter 3 Designing Forms for Efficient and Accurate Data Entry
• Chapter 4 Designing Forms for Business Use
• Chapter 5 Creating Specialized Forms
http://www.dropshippers.co.za/

Part II: Designing and Customizing Reports

• Chapter 6 Creating and Publishing a Report
• Chapter 7 Designing Effective Business Reports
• Chapter 8 Designing Advanced Reports
• Chapter 9 Creating Specialized Reports
http://www.dropshippers.co.za/

Part III: Creating Powerful Queries

• Chapter 10 Creating a Basic Query
• Chapter 11 Building Criteria Expressions
• Chapter 12 Working with Multiple-Table Queries
• Chapter 13 Creating Advanced Queries
• Chapter 14 Creating PivotTable Queries
• Chapter 15 Querying with SQL Statements
http://www.dropshippers.co.za/

Index