Access 2007 VBA Programming For Dummies

Joseph C. Stockman, Alan Simpson

  • 出版商: Hungry Minds
  • 出版日期: 2007-02-01
  • 售價: $1,250
  • 貴賓價: 9.5$1,188
  • 語言: 英文
  • 頁數: 408
  • 裝訂: Paperback
  • ISBN: 0470046538
  • ISBN-13: 9780470046531
  • 相關分類: Excel
  • 已絕版

買這商品的人也買了...

商品描述

Description

  • Completely revised, this book includes coverage of basic concepts and general VBA topics for nonprogrammers
  • Some of the basic topics covered include modules, procedures, and objects; while more advanced topics are SQL record sets and other programming activities that are unique to Access programming
  • Offers practical, ready-to-use solutions to various Access procedures so readers can just drop information into their databases and use it immediately
  • Addresses using the Visual Basic Editor; creating a simple VBA program; using VBA with multiple databases; and integrating with other Office applications
  • The companion Web site contains all the code from the book plus additional ready-to-use code snippets
  •  

    Table of Contents

    Introduction.

    Part I: Introducing VBA Programming.

    Chapter 1: Where VBA Fits In.

    Chapter 2: Your VBA Toolkit.

    Chapter 3: Jumpstart: Creating a Simple VBA Program.

    Part II: VBA Tools and Techniques.

    Chapter 4: Understanding Your VBA Building Blocks.

    Chapter 5: Controlling Access through VBA.

    Chapter 6: Programming Access Forms.

    Part III: VBA, Recordsets, and SQL.

    Chapter 7: The Scoop on SQL and Recordsets.

    Chapter 8: Putting Recordsets to Work.

    Part IV: Applying VBA in the Real World.

    Chapter 9: Creating Your Own Dialog Boxes.

    Chapter 10: Customizing Combo Boxes and List Boxes.

    Chapter 11: Creating Your Own Functions.

    Chapter 12: Testing and Debugging Your Code.

    Part V: Reaching Out with VBA.

    Chapter 13: Using VBA with Multiple Databases.

    Chapter 14: Integrating with Other Office Applications.

    Part VI: The Part of Tens.

    Chapter 15: Ten Commandments of Writing VBA.

    Chapter 16: Top Ten Nerdy VBA Tricks.

    Index.