Access 2002 Programming by Example

Bob Villareal

556 pages, parution le 05/03/2002

Ajouter à une liste

Indisponible

Résumé

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.

Contents

Introduction.

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.

Index.

L'auteur - Bob Villareal

Bob Villareal is a contributor and a resident expert for the "Inside Microsoft Access" Web journal and an Access instructor at a Tulsa Community College. He also does freelance programming and instruction. Bob has been developing databases in a large insurance firm for more than 15 years. He has more than seven years' experience of VBA programming in both Access and Excel and has written many tracking and management applications.

Caractéristiques techniques

	PAPIER
Éditeur(s)	Que
Auteur(s)	Bob Villareal
Parution	05/03/2002
Nb. de pages	556
Format	18,5 x 23,2
Couverture	Broché
Poids	954g
Intérieur	Noir et Blanc
EAN13	9780789725943

Avantages Eyrolles.com

Livraison à partir de 0,01 € en France métropolitaine

Paiement en ligne SÉCURISÉ

Livraison dans le monde

Retour sous 15 jours

+ d'un million et demi de livres disponibles

Nouveautés "Access 2002"

Initiation à Access 2002

Access 2002 Programming by Example

Résumé

L'auteur - Bob Villareal

Caractéristiques techniques

Nouveautés "Access 2002"

Consultez aussi