Synopses & Reviews
When an application is part of the Microsoft Office suite, it's sure to be a leader in its field. In the realm of desktop database management, Access is top dog with millions of users. But this is one dog that can bite. Although Access is a powerful, relational tool with the fetching talents of a Labrador, it's not an easy beast to train.
Still, millions of users count on Access for everything from managing parts databases to running Web catalogs to working as a front end to mondo SQL databases. But Access is chockablock with annoyances---report hassles, query conundrums, VBA bugs, arcane error messages, and more.
O'Reilly's Annoyances series offer real-world help, right now, and Fixing Access Annoyances continues tradition. You'll not only squash bugs and workaround Access' limits, but you'll learn how to use Access to the max, whether you're a newbie or a seasoned pro. Coverage includes install/configuration annoyances, building better tables and queries, creating forms that work right, generating reliable and sophisticated reports, pulling in data from a variety of sources, crafting macros and VBA code to customize Access, and much more.
You could grab those other books for help, but do they solve problems from page one? Meet a book of a different stripe. The authors come armed with knowledge of the program's quirks, design hurdles and interface snags. They provide you with battle plans in Fixing Access Annoyances to save you time and bouts of hair pulling.
Stop information from spiraling out of control when working with Access and trying to make this #$@@#$ thing work! Don't let its quirks, bugs, and troublemaking features beat you. Who you gonna call for help? Instead of waiting on the line for tech support or searching for the answer on the Internet with its too many resources to find exactly what you need, take control of databases with Fixing Access Annoyances, your partner on database adventures.
Synopsis
Our intriguing solutions make this the book for Access users of all stripes!
Synopsis
With "Access Annoyances," readers will not only squash bugs and work around the application's limits, but they'll learn how to use Access to the max, whether they're newbies or seasoned pros.
About the Author
Phil Mitchell is an Access wiz and instructor. He's been a software developer for a dozen years, focusing on data modeling and developing database applications. He also has a Ph.D. in cognitive psychology and a passion for design usability.
Evan Callahan is President of Callahan Software Solutions, a consultancy focusing on database and other software solutions and technical communications. Clients have included Microsoft, General Dynamics, Online Training Solutions, and a variety of accounting, real estate, and environmental firms. He is the author of "Troubleshooting Your Web Page" and "Microsoft Access Visual Basic for Applications Step by Step", published by Microsoft Press. Evan worked for Microsoft Corporation from 1989 to 1995, where he created documentation and sample applications for Microsoft Access and Visual Basic. His background includes extensive experience in database design, technical communications, web-based marketing, and management.
Table of Contents
Copyright; Dedication; Introduction; How to Use This Book; Access Versions; MSKB 123456; Conventions Used in This Book; Using Code Examples; I Did Exactly What You Said, and It Still Doesn't Work!; Safari® Enabled; Acknowledgments; Chapter 0: Access Basics; 0.1 The Database Window; 0.2 Wizards; 0.3 Design View and User Views; 0.4 Setting Properties; 0.5 Bound Versus Unbound Objects; 0.6 Multi-User Databases and Split Design; 0.7 How to Create an Event Procedure; 0.8 How to Add Code to Your Application; 0.9 DAO Versus ADO; Chapter 1: General Annoyances; 1.1 CUSTOMIZING ACCESS; 1.2 ACCESS RUNS AMOK; 1.3 ERROR MESSAGES; Chapter 2: Performance, Versions, Security, and Deployment; 2.1 PERFORMANCE; 2.2 VERSIONS, UPGRADES, AND CONVERSION; 2.3 SECURITY; 2.4 ENTERPRISE DEPLOYMENT AND NETWORKED DATABASES; Chapter 3: Data, Tables, and Database Design; 3.1 DATABASE DESIGN AND DATA INTEGRITY; 3.2 IMPORTING, LINKING, AND EXPORTING DATA; Chapter 4: Queries; 4.1 QUERY BASICS; 4.2 QUERY MISFIRES; 4.3 PARAMETER AND CROSSTAB QUERIES; 4.4 TECHNIQUES FOR DIFFICULT QUERIES; Chapter 5: Forms; 5.1 WORKING IN DESIGN VIEW; 5.2 FORM DESIGN; 5.3 CREATE FORMS YOUR USERS WILL LOVE; Chapter 6: Reports, Mailing Labels, and Charts; 6.1 GENERAL REPORT ANNOYANCES; 6.2 PAGE LAYOUT AND PRINTING; 6.3 SORTING, GROUPING, AND SUBREPORTS; 6.4 MAILING LABELS; 6.5 CHARTS AND GRAPHS; Chapter 7: Expressions, Macros, Code Modules, and Custom Controls; 7.1 EXPRESSIONS; 7.2 MACROS AND CODE MODULES; 7.3 CUSTOM CONTROLS AND EXTERNAL APPLICATIONS; Appendix A: Appendix; A.1 Installation Checklist; A.2 Access Newsgroups; A.3 Visual Basic Functions; A.4 Macro Actions; A.5 Events; Glossary; About the Authors; Colophon;