Want a NOOK? Explore Now
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.
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.
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;
Overview
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 ...