資料來源: Google Book

Automating Microsoft Access with VBA

  • 作者: Harkins, Susan Sales.
  • 其他作者: Gunderloy, Mike.
  • 出版: Indianapolis, Ind. : Que ©2005.
  • 稽核項: 1 online resource (xv, 384 pages) :illustrations.
  • 叢書名: Business solutions
  • 標題: Microsoft Access. , Database management. , COMPUTERS , Microsoft Visual Basic for applications. , COMPUTERS Programming Languages -- SQL. , Programming LanguagesSQL. , Electronic books. , Electronic book.
  • ISBN: 0789732440 , 9780789732446
  • ISBN: 0789732440
  • 試查全文@TNUA:
  • 附註: Includes index. Cover -- Copyright -- TOC36;Table of Contents -- About the Authors -- Dedication -- Acknowledgments -- We Want to Hear from You33; -- Introduction -- Part I Laying the Foundation -- CH36;Chapter 1 Why Access63; Why VBA63; -- Understanding the Place of Access in Office -- Understanding Access Programming Choices -- CH36;Chapter 2 Getting Around in the Visual Basic Editor -- Your First Glance at the Visual Basic Editor -- Introducing the VBA Modules -- Entering and Running VBA Code -- Getting Help on Code -- Establishing Good Habits in Coding -- CH36;Chapter 3 Using Variables44; Constants44; and Data Types -- Declaring Variables and Constants -- VBA Data Types -- Referencing Syntax -- CH36;Chapter 4 Using Procedures -- Understanding Procedure Types -- Declaring Procedures as Public or Private -- Passing Arguments -- Giving a Function a Data Type -- Implementing Error Handling -- Debugging Code -- CH36;Chapter 5 Choosing the Right VBA Function -- Introducing VBAs Built45;in Functions -- Converting Data Types with VBA Functions -- Working with Date Functions -- Using Mathematical and Financial Functions -- Using String Functions -- Using the Format Function -- Using the Is Functions for Flawless Processing -- Interacting Functions -- CH36;Chapter 6 Using Flow45;of45;Control Statements -- Branching and Looping -- Using If8230;Then8230;Else -- Using Select Case -- Using For8230;Next -- Using Do Loops -- Using GoTo -- CH36;Chapter 7 Working with Arrays -- Introducing Array Variables -- Declaring an Array Variable -- Understanding the Arrays Index -- Working with Array Elements -- Arrays with Multiple Dimensions -- Expanding to Dynamic Arrays -- CH36;Chapter 8 Understanding Objects -- Introducing Objects -- Reading and Setting Properties -- Invoking Methods -- Working with Collections -- Working with an Object Model -- Creating Your Own Objects -- Working with Events -- CH36;Chapter 9 Understanding Scope and Lifetime -- Whats Scope63; -- Measuring the Lifetime of a Varia
  • 電子資源: https://dbs.tnua.edu.tw/login?url=https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=136309
  • 系統號: 005319085
  • 資料類型: 電子書
  • 讀者標籤: 需登入
  • 引用網址: 複製連結
Take advantage of VBA's capabilities with this book's instruction for customizing Access database applications to meet business needs. Developers save money by using VBA instead of building custom database applications from the ground up.
來源: Google Book
評分