Beginning Access 2002 VBA
Robert Smith, David Sussman, Ian Blackburn, John R Colby, Mark Horner, Martin W.P. Reid, Paul Turley, Helmut Watson - Collection Beginning
Résumé
If you are using Access and want to go to the next level, you need to learn VBA. As part of Visual Basic, VBA allows you to use some tremendously powerful programming techniques. In this book, we show you how VBA gives you complete control over the way your users view and interact with your Access databases. This is the next level of Access skills, presented to you here in a clear tutorial style.
This book is a revision of the best-selling "Beginning Access 97 VBA" and "Beginning Access 2000 VBA" books, reworked to provide a rich and comprehensive guide to programming Access 2002 with VBA.
Who is this book for?
This book is designed for people with experience of
using Access databases, who now want to learn how to
program them with VBA. No prior knowledge of programming is
needed.
This book is also a useful reference and tutorial for those
with some VBA experience or with knowledge of other
programming languages.
In this book you will learn how to:
- Write your first VBA program - how to structure code, control programs, respond to events, and use objects
- Create powerful Access user interfaces
- Publish your data on the internet, using the improved functionality of Access 2002
- Debug your programs, and increase their performance and usability with robust error handling
- Improve the performance and security of your database by using the SQL Server Desktop Engine
- Access your data efficiently with SQL, DAO, and ADO
- Add support for multiple users and integrate with other Office XP applications
Contents
- Introduction
- Designing Applications
- Introduction to Event-Driven Programming
- Creating Code
- Controlling the Program
- Using Access Objects
- Using DAO
- Data Management Techniques
- Working with Tables
- External Data
- Reports
- Advanced Programming Techniques
- Finding and Dealing with Errors
- Using Classes
- WithEvents and RaiseEvent
- Libraries and Add-Ins
- Automation
- Multi-User
- The Internet
- Optimizing Your Application
- Moving to Client-Server
- ActiveX Data Objects - ADO
- Index
L'auteur - David Sussman
David Sussman gained experience in BASIC, Pascal, COBOL and OCCAM, before joining a UNIX system house where he stayed for 4 years, becoming the chief UNIX/C guru. For the last 3 years he has been working for a Microsoft Solution Provider, specializing in Access, VB and SQL Server, as well as playing extensively with every Beta product that comes his way.
Dave Sussman speaks frequently at Microsoft development conferences and has been writing about ASP since its earliest releases.
Autres livres de David Sussman
Caractéristiques techniques
PAPIER | |
Éditeur(s) | Wrox Press |
Auteur(s) | Robert Smith, David Sussman, Ian Blackburn, John R Colby, Mark Horner, Martin W.P. Reid, Paul Turley, Helmut Watson |
Collection | Beginning |
Parution | 15/05/2003 |
Nb. de pages | 956 |
Format | 18 x 23 |
Couverture | Broché |
Poids | 1575g |
Intérieur | Noir et Blanc |
EAN13 | 9781861008213 |
ISBN13 | 978-1-86100-821-3 |
Avantages Eyrolles.com
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse