Book Description
Access 2000 is the database of choice for the home and small business user. While its intuitive interface makes data storage and manipulation incredibly simple, you really need its underlying language to make the most of its features. The focus of the book is the programming language that underlies Access 2000 - Visual basic for Applications (VBA). VBA is the language that Microsoft is making standard across the whole Office suite of applications. VBA allows you to automate and secure your database, so your end-user need never know what goes on underneath. Its simple style allows even complete novices to programming to achieve impressive results with very little effort.
From the Publisher
This book is for the Access user who already has a knowledge of databases, and the basic objects of an Access database, who now wants to learn how to program with VBA. No need of prior knowledge of programming required.
From the Back Cover
Access 2000 is the fifth version of the hugely successful desktop database from Microsoft. When it was first released in 1992, Access immediately gained praise for its ease of use and power. Each release of Access has added features and increased usability, and with Access 2000 we now have a unified development environment for the whole of the Office 2000 suite of applications. Visual Basic for Applications (VBA) is the programming language that gives Access its real power, allowing you to automate complex tasks and create applications with more scope and flexibility than is possible with its default forms and macros. VBA has a simple syntax allowing even complete novices to learn programming with very little effort, and this book illustrates the concepts with plenty of examples and exercises.
Who is this book for?
This book is for users who already have a basic knowledge of databases and the basic Access objects, such as tables, queries, forms and reports. You now want to expand on your existing knowledge of Access and wish to learn how to program in VBA. You don’t need any prior programming experience, although a basic knowledge of Access macros would be helpful.
What does this book cover?
- Constructing a substantial example application with VBA
- Mastering the foundations of Visual Basic for Applications
- Understanding the concepts behind classes and objects
- How Automation can be used to link Office applications
- Creating custom objects using the Class Module feature
- How to debug your programs and implement robust error handling
- Adding support for multiple users
- Publishing your Access database on the Internet
- How to optimize and add polish to your finished database application
--This text refers to an alternate
Paperback
edition.
About the Author
Robert Smith
Robert Smith is a graduate of Oxford University who has been working for Anthony Coook Associates since 1994. He has been developing with Access since its first release in 1992. About half of his time is psent developing with Access and SQL Server anf the remainder is spent on consultancy in client/server design and development issues.
David Sussman
David 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.
