Automating Microsoft Access with VBA
Devlop your Access 2003 expertise instantly with proven techniques
Susan Sales Harkins, Mike Gunderloy - Collection Business solutions
Résumé
Automating Microsoft Access with VBA builds on the Access skills you've already developed in a business setting and helps you take them to the next level-using VBA to automate things you currently do manually. Access includes the Visual Basic for Applications (VBA) programming language; even if you've never programmed before, you can learn how to use VBA to make your work with Access more productive than ever before.
Automating Microsoft Access with VBA is for professionals who use Microsoft Access in a business setting. You've got real work to get done, and you can't spend all day reading a computer book. This book will teach you the essential skills you need to automate your databases as quickly as possible. Although this book was written using Access 2003, the techniques and concepts covered will work in most versions of Microsoft Access.
Highlights of This Book Include:
- Getting Around in the Visual Basic Editor
- Using Variables, Constants, and Data Types
- Using Procedures
- Choosing the Right VBA Function
- Working with Arrays
- Understanding Objects
- Working with Forms
- Analyzing the Access Event Model
- Working with List and Combo Boxes
- Working with Reports
- Working with the Application Collections
- Retrieving Data with ADO
- Manipulating Data with ADO
- Performing Advanced Data Operations
- Working with Data Files
- Working with XML Files
- Review of Access SQL
L'auteur - Susan Sales Harkins
Susan Sales Harkins has been the Editor-in-Chiefof
Microsoft Access, The Cobb Group's tips and techniques
monthly journal on MS Access since 1994. Ken Hansen is a
principal in HSC Consulting, Inc. and has over 20 years
experience in the Information Systems area. He currently
specializes in developing business solutions with Access,
Visual Basic, Microsoft Office and SQL Server. Before
becoming a consultant, Ken held various management
positions, including that of Information Systems Director
for a Fortune 500, worldwide holding company. Ken is a
Microsoft Certified Solutions Developer. Tom Gerhart has
been an independent consultant since 1993 when he retired
from IBM. His current area of specialty is to design and
develop business solutions based on Microsoft Office with a
primary emphasis on the use of Microsoft Access and
Microsoft SQL Server. He has worked with all releases of
Access, with a number of projects involving backend
databases (including Oracle and Microsoft SQL). He has also
worked with Visual Basic, including the development of
ActiveX components. Tom does some training in addition to
his consulting.
L'auteur - Mike Gunderloy
Mike Gunderloy is the lead developer for Lark Group, Inc., an independent software consultancy in eastern Washington. His other Sybex books include ADO and ADO.NET Programming and Access 2002 Desktop Developer's Handbook. When not writing code or writing about code, Mike raises tomatoes and turkeys on his small farm.
Sommaire
- Laying the Foundation
- Working with the Access User Interface
- Working with Access Data
- Using Advanced VBA Techniques in Access
- Appendix
Caractéristiques techniques
| PAPIER | |
| Éditeur(s) | Que |
| Auteur(s) | Susan Sales Harkins, Mike Gunderloy |
| Collection | Business solutions |
| Parution | 16/11/2004 |
| Nb. de pages | 384 |
| Format | 19 x 23,5 |
| Couverture | Broché |
| Poids | 690g |
| Intérieur | Noir et Blanc |
| EAN13 | 9780789732446 |
| ISBN13 | 978-0-7897-3244-6 |
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
