About the Book
This book addresses an unmet need in this topic area. It is a complete beginner's tutorial resource to tips, troubleshooting, techniques, and program development for Access 2002. The book covers fundamentals such as database normalization, query design, object manipulation, and optimization and custom programming for forms and reports. It makes the reader more efficient, productive, and knowledgeable in Access VBA. Speed techniques are mentioned. Shortcuts, tips, and techniques increase productivity. This book deals with getting data from outside sources and using VBA to ensure data integrity and consistency, which no other Access VBA book does. It also tackles problems in a variety of day-to-day situations that programmers often face.Table of Contents:
I. TABLES AND QUERIES
1. Planning and Designing Your Access Database.
2. Joins and Cascades.
3. The Table—The Heart of Any Database.
4. Unleashing the Power of Queries.
II. FORMS FOR INPUT AND REPORTS FOR OUTPUT.
5. Exploring Forms and Controls.
6. Exploring Reports.
III. AUTOMATE YOUR ACCESS DATABASE USING CODE.
7. Exploring Objects.
8. Writing Your Own Visual Basic for Applications Code.
9. Macros, Modules, and Messages.
10. Using Procedures to Customize Your Database.
11. Handling Access Error Codes.
12. Access Visual Basic Tools, Tips, and Techniques. .
IV. TAKING ADVANTAGE OF THE LATEST ACCESS FEATURE.
13. Publishing Your Access Database.
14. SQL Server Integration.
15. User-Friendly Enhancements.
V. OVERCOMING ACCESS DEVELOPMENT OBSTACLES.
16. Overcoming the Limitations of Queries.
17. Getting the Most from Your Queries.
18. Working with Data from External Sources. .
19. Bringing Together and Separating Data.
20. Conquering Big Problems that Come In Small Packages. .
21. Taking Charge of Forms. .
22. Taking Charge of Reports. .
23. Using Replication.