Microsoft Excel 2000 Visual Basic for Applications Fundamentals


Book Description

A fast, easy way to learn to program with Visual Basic for Applications, to extend and modify Microsoft Excel behavior, and to take full advantage of the Internet. The easy-to-follow lessons include clear objectives and real-world business examples so you can learn exactly what you need to know, at your own speed. The CD-ROMs offer real-world samples to support each lesson.




Microsoft Access 2000 Visual Basic for Applications


Book Description

A teach-yourself guide to using the Access macro language to take control of Access. The easy-to-follow lessons include clear objectives and real-world business examples so you can learn exactly what you need to know, at your own speed. Users learn to create macros and applications for themselves and their business units. The CD offers real-world samples to support each lesson.




Access 2002 VBA Handbook


Book Description

How Far Can You Go with Access 2002? The answer depends on your knowledge of VBA programming. If you really want to get the most out of Access, the Access 2002 VBA Handbook is essential reading. If you are an experienced user of Access, you get the step-by-step instruction you need to be dramatically more productive. And if you are a more experienced developer, you get the advanced VBA programming skills you need to build the Access applications your users require. Coverage includes * Running queries to find specific records * Automating complex and time-consuming procedures * Importing data from existing data sources * Synchronizing forms and tables * Understanding the ADO and DAO models * Understanding the essentials of Visual Basic for Applications (VBA) * Customizing the Access user interface * Creating procedures to change Access's default error-handling processes * Accessing data using OLE DB and ODBC * Creating VBA procedures for navigating a database or project * Writing VBA procedures using object properties and methods * Creating relationships between forms * Executing commands using SQL statements in VBA code * Using ActiveX controls in your VBA procedures




Programming Microsoft Visual Basic .NET for Microsoft Access Databases


Book Description

The Microsoft .NET Framework represents an exciting new world for developers who work with Microsoft Access, Visual Basic, and Visual Basic for Applications. This book provides complete, practical details on how to take advantage of this world by building or upgrading Access-based client applications with Visual Basic .NET. It gives you specific instructions about how the .NET Framework pertains to Access development. Then it explores programming with Visual Basic .NET and ADO.NET, and it puts it all together with examples and code samples that show how to develop robust Web applications and services with these tools. Topics covered include: What's in the Microsoft .NET Framework for Access developers Getting started with Visual Basic .NET and Microsoft Visual Studio .NET Visual Basic.NET techniques for data types, procedures, loops, arrays, classes, class inheritance, event processing, structured exception handling, and file processing Code behind Windows Forms and programming with form controls Form navigation, the Data Form Wizard, and programming the DataGrid control Learning ADO.NET architecture and programming data access and manipulation, plus drilling down on datasets and parent-child relations with ADO.NET A Windows Form sample to browse, manipulate, and handle concurrency violations Learning ASP.NET page design and implementing ADO.NET with ASP.NET pages Using, creating, and deploying XML Web services Securing .NET Windows and Web applications using Access databases Appendix: XML syntax and schema conventions plus Visual Studio .NET XML Designers INCLUDES SAMPLE CODE ON THE WEB! Sample code available at the COMPANION CONTENT link on this page




Microsoft Visual Basic for Applications (VBA).


Book Description

Explore and customize your Office applications with Visual Basic for Applications: Beginning Course. This text provides a thorough introduction to the Visual Basic for Applications language and features step-by-step instructions to guide students in programming the Microsoft Office applications. Extensive end-of chapter exercises also offer plenty of hands on practice and reinforcement.




Microsoft Access 2000


Book Description




New Perspectives on Microsoft Access 2000 with Visual Basic for Applications


Book Description

Part of the New Perspectives Series, this text is designed for a second, more advanced course on Access 2000. Includes extensive coverage of Visual Basic for Applications (VBA).










Beginning Access 2000 VBA


Book Description

What is this book about? Access 2000 is an important part of the Office 2000 program suite, and is available on both the Premium and Professional editions of Office 2000. Access has traditionally been the Office suite database program par excellence. It still remains that way, but with Office 2000 the face of Access is changing. This book will look at the traditional role of Access and its future uses in the Office suite. Using VBA (Visual Basic for Applications), the user can program his or her own programs in what is essentially a subset of the Visual Basic programming languages. This is tremendously powerful, as it allows you to create great User Interfaces (forms etc), as a front end to actual database storage and manipulation. This continues to be one of the great strengths of programming Access VBA. This book updates, expands and improves Beginning Access 97 VBA Programming, in an Office 2000 setting. All the great tutorial content, teaching people how to program with VBA in Access is there, but now majorly rewritten to take account of Office 2000. Updated to take account of the Office 2000 facilities Constructs a substantial example application with VBA Database theory taught in the Wrox Beginning style What does this book cover? In this book, you will learn how to Construct a substantial example application with VBA Master the foundations of Visual Basic for Applications Understand the concepts behind classes and objects Understand how Automation can be used to link Office applications Create custom objects using the Class Module feature Debug your programs and implement robust error handling Add support for multiple users Publish your Access database on the Internet Optimize and add polish to your finished database application 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.