Beginning Access 2000 VBA with CD-ROM

( 6 )

Overview

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 ...

See more details below
Available through our Marketplace sellers.
Other sellers (Paperback)
  • All (16) from $1.99   
  • New (2) from $50.00   
  • Used (14) from $1.99   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$50.00
Seller since 2014

Feedback rating:

(185)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
$60.00
Seller since 2014

Feedback rating:

(185)

Condition: New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 1
Showing All
Close
Sort by
Sending request ...

Overview

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.

Read More Show Less

Product Details

  • ISBN-13: 9780764543838
  • Publisher: Wiley
  • Publication date: 5/1/1999
  • Series: Beginning Series
  • Edition description: BK&CD-ROM
  • Edition number: 1
  • Pages: 896
  • Product dimensions: 7.22 (w) x 9.08 (h) x 1.96 (d)

Meet the Author

Robert Smith and David Sussman have been programming in Access since it was first released. Using their experience they teach you how the power of Visual Basic® for Applications can transform ordinary databases into great applications.
Read More Show Less

Table of Contents

Introduction.

Chapter 1. Access 2000 – A Long Journey.

Chapter 2. Designing Applications.

Chapter 3. Introduction to Event Driven Programming.

Chapter 4. Creating Code.

Chapter 5. Controlling the Program.

Chapter 6. Using Access Objects.

Chapter 7. Using DAO.

Chapter 8. Data Management Techniques.

Chapter 9. External Data.

Chapter 10. Reports.

Chapter 11. Advanced Programming Techniques.

Chapter 12. Error Handling and Debugging.

Chapter 13. Using Classes.

Chapter 14. Libraries and Add-Ins.

Chapter 15. Automation.

Chapter 16. Multi-User.

Chapter 17. The Internet.

Chapter 18. Optimizing Your Application.

Exercise Solutions.

Appendix A. Choosing Between MSDE and Jet.

Appendix B. Choosing Between DAO and ADO.

Appendix C. ADO 2.1 Object Model.

Appendix D. Access Object Model.

Appendix E. Microsoft DAO 3.6 Object Library Reference.

Appendix F. Access Events.

Appendix G. ANSI Character Set.

Appendix H. ODBC and PWS.

 

Read More Show Less

Customer Reviews

Average Rating 4
( 6 )
Rating Distribution

5 Star

(2)

4 Star

(2)

3 Star

(1)

2 Star

(1)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 7 Customer Reviews
  • Anonymous

    Posted December 30, 2004

    Good Beginner's Book

    Good text for those just beginning Access 2000 user. However, little instruction offered on how to integrate VBA code modules into a single application, for example, how to use code to control form layout and data. You will need an additional book for advanced Access VBA application programming.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted November 13, 2003

    Completely Understandable!

    This book is GREAT. Once I started reading it, it was as if I were in a classroom setting. I found that as I was reading, if something seemed a little complicated or I had questions, if I kept reading they would answer the questions in the very next paragraph. I truly enjoyed the tutorials and found everything broken down in terms I could easily understand. I highly recommend this to anyone who wants to get the most out of Access 2000!

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted January 11, 2003

    Fantastic Tutorial

    I've been teaching Access for several years and recommend this book in every class I teach... it is absolutely phenomenal. It's not designed to be a reference book - but if you're a beginning programmer looking for a book that will explain what you need to know to build great Access apps (including the whys and the concepts), this is the book for you!

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted December 3, 2001

    An Excellent Textbook

    I recently taught a class at the local junior college using this book. I think it's a GREAT textbook. So did the students. It's clear, it's easy to follow. The examples follow a single project all the way through the book, so they actually make SENSE. Each thing builds on what you've already learned. Very solid work these authors have done.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted June 7, 2001

    Excellent Text

    It is a good book with a lot of concepts for experianced developers. If Access is the main database application you use and are experiance with, then this is the one!

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted June 15, 2000

    Excellent Book for Experienced Access Power Users Who Want to Take the Next Step into VBA Programming

    This book is an excellent book for experienced Access power users who want to take the next step in professional Access development. Concepts are laid out and explained very clearly and cogently in a tutorial fashion. The book is indeed intended to be used as a tutorial and not so much as a reference book. Once again, it is another excellent computer book from WROX. I also recommend that the reader also be familiar with Visual Basic, as this will speed up the learning curve. Readers who are not familiar with VB will have some difficulties.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted March 3, 2000

    I wouldn't recomend it for a reference book.

    This book isn't the book for quick reference.You will have to read form the beginning of the book to the end before you really get what you need. Oops! I forgot to mention the index.The indexing are also poor.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing all of 7 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)