Microsoft Access 2016 Programming by Example : With VBA, XML, and ASP.

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Korol, Julitta
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Bloomfield : Mercury Learning & Information, 2016.
Temas:
Microsoft Access.
Microsoft Access
Acceso en línea:Texto completo
Tabla de Contenidos:
  • Title Page; Copyright; Dedication; Contents; Acknowledgments; Introduction; Part I Access VBA Primer; Chapter 1 Getting Started with Access VBA; Understanding VBA Modules and Procedure Types; Writing Procedures in a Standard Module; Hands-On 1.1. Working in a Standard Module; Executing Your Procedures; Hands-On 1.2. Running Procedures and Functions; Understanding Class Modules; Events, Event Properties, and Event Procedures; Why Use Events?; Walking Through an Event Procedure; Hands-On 1.3. Writing an Event Procedure; Compiling Your Procedures; Placing a Database in a Trusted Location.
  • Hands-On 1.4. Placing an Access Database in a Trusted LocationSummary; Chapter 2 Getting to Know Visual Basic Editor (VBE); Understanding the Project Explorer Window; Understanding the Properties Window; Hands-On 2.1. Using the Properties Window to View Control Properties; Understanding the Code Window; Other Windows in the VBE; Assigning a Name to the VBA Project; Renaming the Module; Syntax and Programming Assistance; List Properties/Methods; Parameter Info; List Constants; Quick Info; Complete Word; Indent/Outdent; Hands-On 2.2. Using the Indent/Outdent Feature.
  • Comment Block/Uncomment BlockUsing the Object Browser; Hands-On 2.3. Using the Object Browser; Using the VBA Object Library; Hands-On 2.4. Using Built-In VBA Functions; Using the Immediate Window; Hands-On 2.5. Experiments in the Immediate Window; Hands-On 2.6. Asking Questions in the Immediate Window; Summary; Chapter 3 Access VBA Fundamentals; Introduction to Data Types; Understanding and Using Variables; Declaring Variables; Hands-On 3.1. Using Variables; Specifying the Data Type of a Variable; Hands-On 3.2. Understanding the Data Type of a Variable; Using Type Declaration Characters.
  • Hands-On 3.3. Using Type Declaration Characters in Variable NamesAssigning Values to Variables; Hands-On 3.4. Assigning Values to Variables; Forcing Declaration of Variables; Hands-On 3.5. Forcing Declaration of Variables; Understanding the Scope of Variables; Procedure-Level (Local) Variables; Module-Level Variables; Hands-On 3.6. Understanding Module-Level Variables; Project-Level Variables; Understanding the Lifetime of Variables; Using Temporary Variables; Creating a Temporary Variable with a TempVars Collection Object; Retrieving Names and Values of TempVar Objects.
  • Using Temporary Global Variables in ExpressionsRemoving a Temporary Variable from a TempVars Collection Object; Using Static Variables; Hands-On 3.7. Using Static Variables; Using Object Variables; Hands-On 3.8. Working with Object Variables; Disposing of Object Variables; Finding a Variable Definition; Hands-On 3.9. Finding a Variable Definition; Determining the Data Type of a Variable; Hands-On 3.10. Asking Questions about the Variable Type; Using Constants in VBA Procedures; Intrinsic Constants; Hands-On 3.11. Exploring Access's Constants.

Ejemplares similares